Search Results igs_ps_usec_cps_v

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:

• IGS_PS_USEC_CPS (aliased PUV) — the primary table holding unit section credit point records keyed by UNIT_SEC_CREDIT_POINTS_ID and UOO_ID.
• IGS_PS_UNIT_VER (aliased UNT) — the unit version table providing UNIT_CD and VERSION_NUMBER context.
• IGS_PS_UNIT_OFR_OPT (aliased UOO) — the unit offering option table linking the credit point row to an offered unit offering through UOO_ID.

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:

• UNIT_SEC_CREDIT_POINTS_ID — primary identifier of the credit point record.
• UOO_ID — foreign key linking to the unit offering option.
• CONTACT_HRS_LECTURE, CONTACT_HRS_LAB, CONTACT_HRS_OTHER — discrete contact hour components by activity class.
• DSP_CONTACT_HRS_TOTAL — a computed column equal to the arithmetic sum of the three contact hour fields, intended for display.
• LECTURE_CREDIT_POINTS, LAB_CREDIT_POINTS, OTHER_CREDIT_POINTS — decomposed credit point values by activity.
• MINIMUM_CREDIT_POINTS, MAXIMUM_CREDIT_POINTS, VARIABLE_INCREMENT — the variable credit point envelope.
• WORK_LOAD_CP_LECTURE, WORK_LOAD_CP_LAB, WORK_LOAD_OTHER — workload credit point components.
• CLOCK_HOURS, BILLING_HRS, BILLING_CREDIT_POINTS, CLAIMABLE_HOURS, FIN_AID_CP, FIN_AID_HRS — institutional reporting measures used for billing, funding, and financial aid calculations.
• ENROLLED_CREDIT_POINTS, ACHIEVABLE_CREDIT_POINTS — enrollment-facing aggregates.
• EXCLUDE_FROM_MAX_CP_LIMIT — flag governing maximum credit point enforcement.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus ROW_ID derived from PUV.ROWID.

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.