Search Results igs_he_st_uv_cc_all




Overview
Explore in AI Chat

Overview

IGS_HE_ST_UV_CC_ALL is a transaction table within the IGS (Student System) product schema of Oracle E-Business Suite, holding Higher Education Statistics Agency (HESA) UK statistics data for unit cost centre attribution. The table records the proportional distribution of a taught unit version across cost centres and subject categories, providing the statutory return figures required of UK higher education institutions. In the Oracle EBS 12.1.1 and 12.2.2 data model the object is registered under owner IGS, is marked VALID, and exposes twelve documented columns when generated from the ETRM 12.1.1 reference schema.

From a data-modelling perspective, the mined relationship profile classifies this object as satellite-leaning. It carries descriptive, time-stamped attributes that hang off a business entity, and its foreign key resolves to the parent unit-version entity rather than to another transactional aggregate. That classification is a heuristic suggestion only; the definitive structure is the physical schema documented in ETRM.

Key Information Stored

The twelve documented columns fall into three functional groups: the surrogate identifier, the composite business key, and the descriptive measures.

The composite business key is documented as IGS_HE_ST_UV_CC_ALL_U2 over (UNIT_CD, VERSION_NUMBER, COST_CENTRE, SUBJECT), which guarantees that a unit version cannot carry two rows for the same cost centre and subject pairing. The surrogate HESA_ST_UV_CC_ID remains the physical primary key.

Common Use Cases and Queries

The principal scenario is extraction of HESA unit cost centre returns for statutory submission, filtering by institution and academic period. Analysts also reconcile the sum of PROPORTION per unit version to confirm that full attribution has been captured, and use the table as a drill-down target when investigating cost centre allocations behind a programme of study.

A representative pattern joins the table to its parent unit version and aggregates the distribution:

  • SELECT c.UNIT_CD, c.VERSION_NUMBER, c.COST_CENTRE, c.SUBJECT, SUM(c.PROPORTION)
  • FROM IGS_HE_ST_UV_CC_ALL c
  • JOIN IGS_PS_UNIT_VER_ALL u ON u.UNIT_CD = c.UNIT_CD AND u.VERSION_NUMBER = c.VERSION_NUMBER
  • WHERE c.ORG_ID = :p_org_id GROUP BY c.UNIT_CD, c.VERSION_NUMBER, c.COST_CENTRE, c.SUBJECT;

Validation queries against IGS_HE_ST_UV_CC_ALL_U2 surface duplicates introduced by bulk data loads, while audit-oriented queries order by LAST_UPDATE_DATE to isolate recently amended attributions.

Related Objects

The documented foreign key establishes the primary dependency: IGS_PS_UNIT_VER_ALL, the unit version entity, joined on UNIT_CD and VERSION_NUMBER. Because the object is a HESA statistics satellite, related statistics tables and validation routines typically resolve back to the same unit version parent, and reporting extracts commonly join to cost centre and subject reference data. Practically, the most significant dependencies are:

  • IGS_PS_UNIT_VER_ALL — parent unit version entity; the single documented foreign key target.
  • IGS_HE_ST_UV_CC_ALL_U1 / _U2 — unique indexes enforcing the surrogate and composite business keys.
  • IGS_HE_ST_UV_CC_ALL_PK — primary key constraint on HESA_ST_UV_CC_ID.
  • HESA return extraction concurrent programs and validation reports that consume the table for statutory UK statistics submissions.
  • Cost centre and subject reference lookups used to render COST_CENTRE and SUBJECT values in reporting.