Results for “organization_unit”

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

Overview

The IGS_HE_POOUS_OU_ALL table is a core HESA (Higher Education Statistics Agency) data store within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to store HESA Organization Unit information for Program Offering Option Unit Sets. In practice, this table captures the mapping between a specific student program offering option — identified by course, course version, calendar type, location, attendance mode and attendance type — and the organization unit responsible for delivery, together with the proportion of the unit set attributed to that organization.

From a dimensional modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table carries descriptive and qualifier attributes (ORGANIZATION_UNIT, PROPORTION) that hang off the composite business key formed by the program offering option and unit set references, rather than acting as a pure hub of unique business entities. This classification is a heuristic suggestion derived from the FK topology, not a declared constraint.

Key Information Stored

The table contains 17 documented columns. The most significant are outlined below.

• HESA_POOUS_OU_ID — the surrogate primary key, enforced by the IGS_HE_POOUS_OU_ALL_PK constraint and additionally covered by the unique index IGS_HE_POOUS_OU_ALL_U1. It uniquely identifies each row and is the column referenced by dependent child tables.
• COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE — the composite reference to the program offering option (IGS_PS_OFR_OPT_ALL). These columns define the offering option context to which the organization unit information applies.
• UNIT_SET_CD, US_VERSION_NUMBER — the reference to the unit set (IGS_EN_UNIT_SET_ALL) associated with the offering option.
• ORGANIZATION_UNIT — the HESA organization unit code assigned to the option/unit-set combination.
• PROPORTION — the share or weighting attributed to that organization unit.
• ORG_ID — the multi-org operating unit identifier, supporting operating unit security partitioning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO columns providing auditability and concurrency tracking.

Note that the eight business columns (COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE, UNIT_SET_CD, US_VERSION_NUMBER) plus ORGANIZATION_UNIT form the business-key candidate enforced by the unique index IGS_HE_POOUS_OU_ALL_U2, distinct from the surrogate HESA_POOUS_OU_ID in U1.

Common Use Cases and Queries

This table is typically queried for HESA statutory returns, where the organization unit and its proportion must be reported against each program offering option unit set. Typical reporting patterns include:

• Retrieving all organization units and proportions for a given offering option.
• Aggregating proportion values per unit set to validate that allocations sum correctly.
• Joining to IGS_PS_OFR_OPT_ALL and IGS_EN_UNIT_SET_ALL to produce human-readable HESA extracts.

A representative query pattern is:

• SELECT p.hesa_poous_ou_id, p.course_cd, p.crv_version_number, p.unit_set_cd, p.organization_unit, p.proportion FROM igs_he_poous_ou_all p WHERE p.org_id = :org_id AND p.course_cd = :course_cd;
• SELECT p.unit_set_cd, p.organization_unit, SUM(p.proportion) FROM igs_he_poous_ou_all p GROUP BY p.unit_set_cd, p.organization_unit;

Related Objects

The following objects have the most significant documented relationships with this table.

• IGS_PS_OFR_OPT_ALL — parent of the offering option reference; joined via COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE.
• IGS_EN_UNIT_SET_ALL — parent of the unit set reference; joined via UNIT_SET_CD and US_VERSION_NUMBER.
• IGS_HE_POOUS_OU_CC — child table referencing this table through HESA_POOUS_OU_ID, typically used for correction or override tracking within HESA processing.
• IGS_HE_POOUS_OU_ALL_PK — the primary key constraint on HESA_POOUS_OU_ID.
• IGS_HE_POOUS_OU_ALL_U1 and IGS_HE_POOUS_OU_ALL_U2 — unique indexes enforcing the surrogate and business-key uniqueness respectively.