Results for “igs_he_poous_cc_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_HE_POOUS_CC_ALL table belongs to the IGS (Student System) product family within Oracle E-Business Suite, a module that is designated as Obsolete in the ETRM 12.1.1 and 12.2.2 reference data. The table stores HESA (Higher Education Statistics Agency) Cost Centre information for Program Offering Option Unit Sets. In practical terms, it associates a cost centre and subject classification with the combination of a program offering option, a unit set, and the contextual attributes (calendar type, location, attendance mode, and attendance type) that identify a specific delivery of that unit set. This supports HESA statutory returns, where each taught unit must be attributed to a valid cost centre and subject code for funding and statistical reporting.

The ETRM metadata records the object as "Not implemented in this database," indicating that the table definition is delivered but is not populated in a standard installation. Its physical schema documents an owner of IGS and eighteen columns. The heuristic Data Vault classification mined from the foreign key structure is link. Consistent with that suggestion, the table behaves as an associative construct that resolves many-to-many relationships between program offering options, unit sets, and their cost centre/subject attributions, rather than as a standalone descriptive hub or satellite.

Key Information Stored

The surrogate primary key is HESA_POOUS_CC_ID, enforced by the IGS_HE_POOUS_CC_ALL_PK constraint and also by the unique index IGS_HE_POOUS_CC_ALL_U1. A second unique index, IGS_HE_POOUS_CC_ALL_U2, defines the business-key candidate over COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE, UNIT_SET_CD, US_VERSION_NUMBER, COST_CENTRE, and SUBJECT. This composite uniqueness ensures that a given delivery context cannot carry duplicate cost centre/subject attributions.

The most significant columns are:

• COURSE_CD and CRV_VERSION_NUMBER — identify the program offering option version, joining to IGS_PS_OFR_OPT_ALL.
• UNIT_SET_CD and US_VERSION_NUMBER — identify the unit set version, joining to IGS_EN_UNIT_SET_ALL.
• CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE — contextual delivery attributes that complete the business key.
• COST_CENTRE — the HESA cost centre to which the offering option/unit set combination is attributed.
• SUBJECT — the HESA subject classification associated with the attribution.
• PROPORTION — the numeric share of the attribution, supporting apportionment across multiple cost centres or subjects.
• ORG_ID — the operating unit, supporting multi-org security.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical usage centers on HESA cost centre and subject reporting, funding reconciliation, and validating that every offering option/unit set delivery carries a complete attribution. A representative query joins the table to its parent unit set and program offering option:

• Reporting cost centre distribution: SELECT COURSE_CD, UNIT_SET_CD, COST_CENTRE, SUBJECT, PROPORTION FROM IGS_HE_POOUS_CC_ALL WHERE ORG_ID = :org_id;
• Validation of missing attributions by joining to IGS_EN_UNIT_SET_ALL on UNIT_SET_CD and US_VERSION_NUMBER and to IGS_PS_OFR_OPT_ALL on the COURSE_CD/version/context columns.
• Proportion reconciliation to confirm that attributions for a given offering option version sum to the expected total.
• Extract queries feeding HESA returns, filtered by COST_CENTRE or SUBJECT.

Related Objects

The principal related objects, derived from the documented foreign keys, are:

• IGS_PS_OFR_OPT_ALL — parent for COURSE_CD and the associated version/context columns.
• IGS_EN_UNIT_SET_ALL — parent for UNIT_SET_CD and US_VERSION_NUMBER.
• IGS_HE_POOUS_CC_ALL_PK and unique indexes IGS_HE_POOUS_CC_ALL_U1 / U2 — constrain identity and business uniqueness.
• Related HESA cost centre reference and validation objects used to decode COST_CENTRE and SUBJECT values.

Because IGS is obsolete in the referenced releases, implementations should treat this table as legacy and confirm current alternatives before relying on it for new development.