Search Results igs_he_unt_ou_cc




Overview
Explore in AI Chat

Overview

The IGS_HE_UNT_OU_CC table is a transactional data object in the Oracle E-Business Suite Student System (IGS) product family. It was introduced as a replacement for the legacy unit-level cost centre table, extending the earlier design so that organization unit details can be recorded alongside cost centre details for a given academic unit and version. This dual purpose reflects the reporting demands of higher education institutions, where cost allocation must be traceable both to the delivering organizational unit and to the funding cost centre under which activity is booked.

The table resides in the IGS schema and is fully valid in both Oracle EBS 12.1.1 and 12.2.2. Under the heuristic Data Vault classification mined from its foreign-key structure, the table is identified as standalone — that is, it carries no outbound foreign keys to other documented parents. From a modeling perspective, this suggests it is best treated as a satellite-like structure: its rows hold descriptive and proportional attributes (cost centre, organizational unit, subject, proportion) attached to a unit/version business key, rather than acting as a link that resolves relationships between two independent hubs.

Key Information Stored

The table contains twelve documented columns. The surrogate primary key, enforced by the unique index IGS_HE_UNT_OU_CC_PK, is HESA_UNIT_CC_ID, a system-generated identifier that uniquely distinguishes each row. A second unique index, IGS_HE_UNT_OU_CC_U1, defines the business key and comprises UNIT_CD, VERSION_NUMBER, ORG_UNIT_CD, COST_CENTRE, and SUBJECT. The presence of this composite uniqueness constraint means that, for a single unit and version, the combination of organizational unit, cost centre, and subject can appear only once.

  • UNIT_CD — the academic unit code to which the cost centre allocation belongs.
  • VERSION_NUMBER — the version of the unit record, supporting version-controlled maintenance of cost centre data.
  • ORG_UNIT_CD — the organization unit responsible for the activity being costed.
  • COST_CENTRE — the cost centre against which the activity is allocated.
  • SUBJECT — the subject classification associated with the allocation line.
  • PROPORTION — the share or weighting attributable to the combination, allowing split allocations across multiple cost centres.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns capturing who created and last modified the row, when, and through which login session.

Common Use Cases and Queries

Typical usage centers on cost allocation reporting and the reconciliation of unit activity against institutional cost centres. A common query retrieves all cost centre allocations for a specific unit and version:

  • SELECT org_unit_cd, cost_centre, subject, proportion FROM igs_he_unt_ou_cc WHERE unit_cd = :unit AND version_number = :version;
  • Aggregating proportion by cost centre to validate that totals reconcile to 100 percent for a unit/version.
  • Joining to historical data extracts to compare cost centre assignments between versions of the same unit.
  • Auditing changes using LAST_UPDATED_BY and LAST_UPDATE_DATE to identify recently amended allocations.

Related Objects

The metadata classifies this table as standalone, with no documented foreign keys to parent tables. Nonetheless, it is functionally associated with the following objects:

  • IGS_HE_UNIT — the parent unit entity; join on UNIT_CD and VERSION_NUMBER.
  • IGS_HE_UNIT_VERSION — version control for unit records, supplying VERSION_NUMBER context.
  • HR_ALL_ORGANIZATION_UNITS — resolves ORG_UNIT_CD to organization unit names and hierarchies.
  • GL_CODE_COMBINATIONS / FND_FLEX_VALUES — validate and describe COST_CENTRE values.
  • IGS_HE_UNIT_CC — the legacy cost centre table that this object supersedes.
  • IGS_HE_UNT_OU_CC_PK and IGS_HE_UNT_OU_CC_U1 — the supporting unique indexes enforcing identity and business-key integrity.