Search Results igs_ps_usec_cps




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_CPS is a transactional table within the Oracle E-Business Suite Student System (IGS) product family. It resides in the IGS schema and is documented as valid in both EBS 12.1.1 and 12.2.2. Its stated purpose is to capture the credit points applicable to a unit section — that is, the academic credit weighting, workload distribution, and billing-hour attributes assigned to a specific offering of a unit. In the IGS model, a "unit" is roughly analogous to a course, and a "unit section" is a scheduled teaching instance of that course. This table therefore stores the credit-point configuration for the section-offering combination rather than for the catalog unit itself.

From a Data Vault modeling perspective, the FK structure suggests this object is best classified as a link. It carries no natural hub-like business entity of its own; instead, it joins a unit offering option (UOO_ID) to the credit-point attributes that describe it. The heuristic classification is a suggestion only, and the physical implementation remains a conventional normalized relational table.

Key Information Stored

The table is documented with 30 columns; the surrogate primary key is UNIT_SEC_CREDIT_POINTS_ID, enforced by the IGS_PS_USEC_CPS_PK constraint and also surfaced as unique index IGS_PS_USEC_CPS_U1. A second unique index, IGS_PS_USEC_CPS_U2, is defined on UOO_ID, making the unit offering option identifier the principal business-key candidate. The most consequential data columns are:

Common Use Cases and Queries

Typical usage includes enrollment credit validation, fee and billing calculations, financial-aid reporting, and workload analysis. A representative join retrieves the credit definition for each offering option:

  • Joining IGS_PS_USEC_CPS to IGS_PS_UNIT_OFR_OPT_ALL on UOO_ID to obtain section-level credit rules alongside offering details.
  • Summing LECTURE_CREDIT_POINTS, LAB_CREDIT_POINTS, and OTHER_CREDIT_POINTS to verify total credit for a section.
  • Filtering on BILLING_CREDIT_POINTS or BILLING_HRS to produce invoicing extracts.
  • Comparing ENROLLED_CREDIT_POINTS against MAXIMUM_CREDIT_POINTS to enforce enrollment caps, excluding rows where EXCLUDE_FROM_MAX_CP_LIMIT is set.
  • Auditing rows by CREATION_DATE or LAST_UPDATE_DATE for data-quality and change-tracking reports.

Related Objects

The dominant relationship is with IGS_PS_UNIT_OFR_OPT_ALL, joined on UOO_ID and the source of the foreign-key constraints documented for this table. Significant related objects include the unit offering and section tables, the enrollment registration tables that consume credit-point values at the point of enrollment, the fee and billing calculation components that read BILLING_CREDIT_POINTS and BILLING_HRS, and the IGS Student System concurrent programs and APIs that maintain unit section credit definitions. Reporting views in the IGS schema generally reference IGS_PS_USEC_CPS through the UOO_ID join rather than directly, making that column the essential lookup key for integration and ad hoc queries.