Search Results igs_he_prog_ou_cc




Overview
Explore in AI Chat

Overview

IGS.IGS_HE_PROG_OU_CC is a transactional table within the Oracle E-Business Suite Student System (IGS) product family. It was introduced to replace a legacy cost centre table that previously operated at the program level, extending that structure so that users can record organizational unit details alongside cost centre details for a specific program and version combination. The table is classified as VALID in the ETRM metadata for both Oracle EBS 12.1.1 and 12.2.2 and is owned by the IGS schema.

The object supports the Higher Education Statistics Agency (HESA) data model used by Oracle Student System, associating academic programs and versions with the organizational units and cost centres that carry financial and statutory reporting responsibility. Its presence in the data model allows institutions to allocate program-level costs and organizational ownership across multiple units with proportional weighting, satisfying both internal costing requirements and external regulatory reporting obligations.

From a data warehousing modeling perspective, the heuristic Data Vault classification for this table is standalone, mined from its foreign key structure. Because no confirmed parent keys are documented, the table is best treated as a self-contained satellite or reference entity rather than a hub or link. Analysts building a dimensional or Data Vault model around IGS tables should validate the true parent relationships before assuming integration dependencies.

Key Information Stored

The table contains 12 documented columns in the 12.1.1 physical schema. The most significant are the identifier and business-key attributes that define each record's meaning:

  • HESA_PROG_CC_ID — the surrogate primary key, defined by the IGS_HE_PROG_OU_CC_PK constraint. Serves as the unique row identifier.
  • COURSE_CD — the course code identifying the program to which the organizational unit and cost centre allocation applies.
  • VERSION_NUMBER — the program version, allowing distinct allocation rules across versions of the same course.
  • ORG_UNIT_CD — the organizational unit code associated with the program or version.
  • COST_CENTRE — the cost centre value that carries the financial cost for the program.
  • SUBJECT — the subject classification used in HESA reporting, distinguishing allocations by subject area.
  • PROPORTION — the weighting applied to each organizational unit / cost centre combination, permitting split allocation across multiple units.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns that record who created and last modified each row, and when.

The business key is enforced by the unique index IGS_HE_PROG_OU_CC_U1, covering COURSE_CD, VERSION_NUMBER, ORG_UNIT_CD, COST_CENTRE, SUBJECT. Together these columns ensure a given program version cannot record duplicate allocations for the same organizational unit, cost centre, and subject combination, while the surrogate key provides a stable reference for joins and integration.

Common Use Cases and Queries

Typical usage centers on reporting and validation. Institutions query this table to report cost centre distribution per program version, to verify that proportions reconcile against expected totals, and to extract HESA-relevant allocation data for statutory returns.

A representative query retrieving allocations for a given program version:

  • SELECT course_cd, version_number, org_unit_cd, cost_centre, subject, proportion FROM igs_he_prog_ou_cc WHERE course_cd = :course AND version_number = :version ORDER BY subject, org_unit_cd;

A validation query identifying programs where recorded proportions do not sum to 1 (or 100%, depending on the unit of measure stored):

  • SELECT course_cd, version_number, SUM(proportion) FROM igs_he_prog_ou_cc GROUP BY course_cd, version_number HAVING SUM(proportion) != 1;

Audit and change-tracking reports commonly use LAST_UPDATED_BY and LAST_UPDATE_DATE to identify recent maintenance activity, while integration extract routines join on COURSE_CD and VERSION_NUMBER to enrich downstream cost allocation and finance systems.

Related Objects

Because the ETRM metadata records no confirmed foreign key relationships for this table, the relationships below are the logical associations inferred from its business-key columns. They should be verified against the actual database constraints before being relied upon in production queries.

  • IGS_HE_PROG_CC (or equivalent legacy program cost centre table) — the predecessor object this table replaces; both share COURSE_CD and VERSION_NUMBER as the program/version linkage.
  • Program/version master tables within the IGS schema — referenced by COURSE_CD and VERSION_NUMBER; typically the source of valid program and version values.
  • Organizational unit definitions — referenced by ORG_UNIT_CD, providing the name and hierarchy of each unit.
  • Cost centre / general ledger mappings — associated via COST_CENTRE, linking student allocations to financial reporting structures.
  • HESA reporting views and extracts within the IGS module — consume this table's SUBJECT and PROPORTION values for statutory returns.
  • Standard EBS audit columns — CREATED_BY, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN reference the FND user and login entities common across all Oracle EBS applications.

Consult the actual foreign key constraints defined in the IGS schema to confirm each relationship before using this table as a source in integrated reporting or data warehouse loads.