Search Results contact_hrs_lecture




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_CPS_V is a reporting and integration view within the Oracle E-Business Suite Student System (IGS) product family governing the management of unit section credit points. The view, whose name expands to "Unit Section Credit Points View" with the CPS suffix denoting the credit point structure designation, belongs to the legacy Student System module that has since been classified as obsolete. It presents a consolidated, denormalized projection of unit section credit point data joined against the unit version and unit offering option structures, allowing consumers to retrieve credit point attributes together with contextual information about the underlying academic unit and its offering.

The view is expressly documented in the ETRM 12.2.2 metadata as "Not implemented in this database." This indicates that while the object is catalogued in the reference repository, no physical implementation exists in the current environment. Consumers searching for the CONTACT_HRS_LECTURE column should understand this column originates from the base credit point table and is surfaced through this view as a pass-through attribute reflecting weekly contact hours allocated to lecture activity within a unit offering.

Underlying Base Objects

The view text revealed in the documentation indicates the definition joins three base tables:

The join predicate correlates PUV.UOO_ID to UOO.UOO_ID, and UOO.UNIT_CD / UOO.VERSION_NUMBER to the corresponding columns on UNT. The ETRM metadata notes that no referenced base objects are separately documented for this view, which is consistent with its obsolete and unimplemented status in the tracked environment. All column values derive from PUV; the UNT and UOO tables serve only to constrain and validate the returned rows.

Key Columns

The view exposes the full credit point attribute set of IGS_PS_USEC_CPS along with a derived total. Notable columns include:

Common Use Cases and Queries

The principal use case is surfacing contact hour and credit point data for a specific unit offering option, particularly where CONTACT_HRS_LECTURE is required for scheduling, workload analysis, or reporting on instructional contact time. A typical query is:

SELECT uoo_id, contact_hrs_lecture, contact_hrs_lab,
       contact_hrs_other, dsp_contact_hrs_total
  FROM igs_ps_usec_cps_v
 WHERE uoo_id = :p_uoo_id;

Integration consumers may also aggregate contact hours across offerings to derive teaching load, or reconcile billing versus contact hours for continuing education units. Because the view is documented as not implemented and the product is obsolete, any deployment relying on it should verify its physical existence and replace it with a supported equivalent before migration to later releases.