Search Results igs_ps_usec_cps_u2

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.

• MINIMUM_CREDIT_POINTS / MAXIMUM_CREDIT_POINTS — bounds for variable-credit sections.
• VARIABLE_INCREMENT — increment step where credit points are variable.
• ACHIEVABLE_CREDIT_POINTS — credit points awarded on successful completion.
• LECTURE_CREDIT_POINTS / LAB_CREDIT_POINTS / OTHER_CREDIT_POINTS — component credit split.
• WORK_LOAD_CP_LECTURE / WORK_LOAD_CP_LAB / WORK_LOAD_OTHER — teaching workload measures by component.
• CONTACT_HRS_LECTURE / CONTACT_HRS_LAB / CONTACT_HRS_OTHER — scheduled contact hours.
• CLOCK_HOURS / NON_SCHD_REQUIRED_HRS — total and non-scheduled required hours.
• BILLING_CREDIT_POINTS / BILLING_HRS — billable credit and hour values.
• FIN_AID_CP / FIN_AID_HRS / CLAIMABLE_HOURS — financial-aid and claimable-hour measures.
• ENROLLED_CREDIT_POINTS / CONTINUING_EDUCATION_UNITS — enrolled and CE unit values.
• EXCLUDE_FROM_MAX_CP_LIMIT — flag affecting maximum credit-point limits.
• Standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) support auditing.

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.