Search Results igs_he_st_prog_cc_u1

Overview

The IGS.IGS_HE_ST_PROG_CC table is a data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the IGS (Oracle Student Management) product family. Its primary role is to store Higher Education Statistics Agency (HESA) cost center details defined at the program version level. As indicated by its status, this table is marked as 'Obsolete' within the provided metadata, signifying it is part of a legacy data model that may be superseded by newer structures in current implementations. It serves as a junction table to associate a specific program version with one or more financial cost centers and academic subjects, including a proportional allocation.

Key Information Stored

The table's columns capture the core identifiers, financial coding, and audit information. The primary identifier is the system-generated HE_PROG_CC_ID. The program context is defined by the COURSE_CD (Program Code) and VERSION_NUMBER. The key HESA financial and academic attributes are the COST_CENTRE code and the SUBJECT code. The PROPORTION column holds the percentage allocation for this specific cost center and subject combination within the program version. Standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) complete the record for auditing purposes.

Common Use Cases and Queries

This table supports reporting and data extraction for HESA statutory returns, enabling institutions to analyze and report on the financial and subject-based composition of their academic programs. A typical use case involves generating a breakdown of all cost centers and subjects associated with a specific program. The following query pattern, derived from the ETRM, is fundamental for data extraction:

• Retrieve Full Program Cost Center Details: SELECT HE_PROG_CC_ID, COURSE_CD, VERSION_NUMBER, COST_CENTRE, SUBJECT, PROPORTION FROM IGS.IGS_HE_ST_PROG_CC WHERE COURSE_CD = :PROG_CODE AND VERSION_NUMBER = :VERSION;
• Aggregate Proportional Allocations: SELECT COST_CENTRE, SUBJECT, SUM(PROPORTION) FROM IGS.IGS_HE_ST_PROG_CC GROUP BY COURSE_CD, VERSION_NUMBER, COST_CENTRE, SUBJECT HAVING SUM(PROPORTION) != 100; This can help identify records where the total proportion for a program version does not sum to 100%.

Related Objects

Based on the provided dependency information, the IGS.IGS_HE_ST_PROG_CC table is referenced by an object within the APPS schema named IGS_HE_ST_PROG_CC. The nature of this object (likely a synonym or view) is not fully detailed but establishes a direct dependency. The table's primary key (HE_PROG_CC_ID) is enforced by the unique index IGS_HE_ST_PROG_CC_PK. A second unique index, IGS_HE_ST_PROG_CC_U1, enforces a business key constraint on the combination of COURSE_CD, VERSION_NUMBER, COST_CENTRE, and SUBJECT, preventing duplicate assignments for the same program version.