Search Results unit_sec_credit_points_id




Overview
Explore in AI Chat

Overview

IGS.IGS_PS_USEC_CPS is a transactional table in the Oracle E-Business Suite Student System (IGS) schema that captures the credit point definitions associated with a specific unit section offering. In EBS 12.1.1 and 12.2.2, it sits within the Academic Structure / Student Records functional area, where a "unit section" is an occurrence of a unit of study offered in a given term. This table stores the quantitative credit-bearing attributes of that section — minimum, maximum, and achievable credit points, lecture/laboratory/other breakdowns, contact hours, billing hours, and financial-aid-related credit measures. It is a child of the unit offering option construct via UOO_ID and is central to enrolment, workload computation, and fee/billing credit calculations.

From a heuristic Data Vault modelling perspective, the metadata classifies this object as a link. The subordinate UOO_ID acts as the business key referencing the parent offering construct, while the surrogate UNIT_SEC_CREDIT_POINTS_ID operates as a unique row identifier. The credit point attributes themselves behave satellite-like, describing measurable facts about the section.

Key Information Stored

The surrogate primary key is UNIT_SEC_CREDIT_POINTS_ID (IGS_PS_USEC_CPS_U1), generated per credit-point record. A second unique index, IGS_PS_USEC_CPS_U2, enforces uniqueness on UOO_ID, making it the business-key candidate that ties each section's credit definition back to its unit offering option.

Common Use Cases and Queries

This table is queried to determine the credit load of a section, compute student workload, drive billing, and validate enrolment against maximum credit limits. A typical join retrieves credit points per offering option:

  • Section credit lookup: join IGS_PS_USEC_CPS.UOO_ID to the unit offering option to resolve credit points for a specific section.
  • Billing and fee calculation: aggregate BILLING_CREDIT_POINTS and BILLING_HRS per student enrolment.
  • Financial-aid reporting: sum FIN_AID_CP and FIN_AID_HRS across a term.
  • Workload analysis: report WORK_LOAD_CP_LECTURE, WORK_LOAD_CP_LAB, and WORK_LOAD_OTHER for departmental planning.

A representative pattern:

SELECT u.UOO_ID, c.MINIMUM_CREDIT_POINTS, c.MAXIMUM_CREDIT_POINTS,
       c.ACHIEVABLE_CREDIT_POINTS, c.BILLING_CREDIT_POINTS
FROM   IGS_PS_USEC_CPS c, IGS_PS_UNIT_OFR_OPT_ALL u
WHERE  c.UOO_ID = u.UOO_ID;

Related Objects

The documented foreign key on UOO_ID references IGS_PS_UNIT_OFR_OPT_ALL, which is the principal parent and the most significant related object. Other relevant IGS objects include IGS_PS_UNIT_OFR_OPT (the base offering option table), IGS_PS_UNIT_SECTIONS and IGS_PS_UNITS for section and unit context, and IGS_EN_SS_USEC_CP / student enrolment credit tables that consume these values. Reporting is typically exposed through IGS enrolment and billing views, and the credit points feed fee-calculation and workload APIs in the Student System.