Search Results cost_centre




Overview
Explore in AI Chat

Overview

The IGS.IGS_HE_ST_UV_CC_ALL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, specifically designed for the Higher Education Statistics Agency (HESA) reporting framework in the UK. Its primary role is to store detailed unit cost center mappings for statistical reporting. The table is flagged as 'Obsolete' in the provided metadata, indicating it is part of a legacy data model that may have been superseded in later application versions or patches. It functions as a junction table, linking academic units (with specific versions) to the financial cost centers and subjects responsible for their delivery, including the proportional contribution of each center.

Key Information Stored

The table's columns are designed to capture the essential dimensions of unit cost allocation. The HESA_ST_UV_CC_ID serves as the unique, system-generated primary key for each record. The academic unit is identified by the combination of UNIT_CD and VERSION_NUMBER. The financial and subject dimensions are captured by COST_CENTRE and SUBJECT, respectively. A critical business attribute is the PROPORTION column, which stores the numeric value representing the fractional contribution (e.g., 0.5 for 50%) of the specified cost center and subject towards the total cost of the unit version. Standard WHO (Who, When, How) columns track audit information, and the ORG_ID supports multi-organization architecture (MOAC).

Common Use Cases and Queries

The primary use case is generating statutory HESA returns that require a breakdown of unit costs by financial and academic responsibility. Common queries involve aggregating proportions for a given unit or cost center. A typical reporting pattern would join this table to the unit definition table to pull descriptive unit names.

  • Retrieve all cost center allocations for a specific unit:
    SELECT UNIT_CD, VERSION_NUMBER, COST_CENTRE, SUBJECT, PROPORTION FROM IGS.IGS_HE_ST_UV_CC_ALL WHERE UNIT_CD = 'MATH101' AND VERSION_NUMBER = 1;
  • Verify total proportional allocation for a unit version sums to 1 (100%):
    SELECT UNIT_CD, VERSION_NUMBER, SUM(PROPORTION) AS TOTAL_PROP FROM IGS.IGS_HE_ST_UV_CC_ALL GROUP BY UNIT_CD, VERSION_NUMBER HAVING SUM(PROPORTION) != 1;
  • Standard data extraction for interface or reporting:
    SELECT HESA_ST_UV_CC_ID, UNIT_CD, VERSION_NUMBER, COST_CENTRE, SUBJECT, PROPORTION, CREATION_DATE FROM IGS.IGS_HE_ST_UV_CC_ALL WHERE ORG_ID = :p_org_id;

Related Objects

Based on the provided relationship data, this table has defined dependencies within the IGS schema. It is the child table in a foreign key relationship, ensuring referential integrity to the master unit version definition.

  • Primary Key: The table is uniquely identified by the constraint IGS_HE_ST_UV_CC_ALL_PK on the HESA_ST_UV_CC_ID column.
  • Foreign Key (References): The table references IGS.IGS_PS_UNIT_VER_ALL via the UNIT_CD column (and implicitly VERSION_NUMBER), ensuring that every cost center record is associated with a valid, existing academic unit version.
  • Unique Indexes: Two unique indexes enforce business rules: IGS_HE_ST_UV_CC_ALL_U1 on the primary key and IGS_HE_ST_UV_CC_ALL_U2 on the combination of UNIT_CD, VERSION_NUMBER, COST_CENTRE, and SUBJECT, preventing duplicate allocations.