Search Results igs_he_poous_all




Overview
Explore in AI Chat

Overview

The IGS_HE_POOUS_ALL table is a core data object within the Oracle E-Business Suite Student System (IGS). It serves as the central repository for storing Higher Education Statistics Agency (HESA) related details that are specifically linked to the combination of a Program Offering Option and a Unit Set. In the context of UK higher education reporting, HESA requires detailed information on student enrollments, programs, and funding. This table acts as a critical junction, associating HESA-specific attributes—particularly funding source information—with the precise academic structure defined by a program offering option and a student's unit set. Its role is essential for generating accurate statutory returns and managing government funding allocations tied to specific course pathways and study patterns.

Key Information Stored

The table's primary function is to link three key entities and store associated HESA metadata. Its structure is defined by foreign key relationships. The critical columns include the surrogate primary key, HESA_POOUS_ID, and the composite foreign keys that define its relationships. The columns COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE together reference a specific Program Offering Option (IGS_PS_OFR_OPT_ALL). The columns UNIT_SET_CD and US_VERSION_NUMBER reference a specific version of a Unit Set (IGS_EN_UNIT_SET_ALL). A pivotal data point stored directly in this table is the FUNDING_SOURCE column, which links to the IGS_FI_FUND_SRC_ALL table to identify the HESA-recognized source of funding for this particular academic combination.

Common Use Cases and Queries

The primary use case for this table is the extraction and validation of data for HESA student returns. Reports and interfaces will query this table to determine the correct funding source and HESA classification for a student based on their enrolled program and unit set. A typical query would join student enrollment records to this table via the program offering option and unit set to retrieve the statutory funding code. Sample SQL often involves complex joins:

  • Identifying the HESA funding source for students in a specific program and unit set combination for a reporting period.
  • Validating that all active program/unit-set combinations required for HESA reporting have a corresponding funding source defined in IGS_HE_POOUS_ALL.
  • Generating audit lists of records where the FUNDING_SOURCE is null or points to an invalid code, which would cause issues in statutory submissions.

Related Objects

The IGS_HE_POOUS_ALL table sits at the intersection of several fundamental Student System entities, as documented by its foreign key constraints:

  • IGS_PS_OFR_OPT_ALL (Program Offering Option): Joined via the composite key (COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE). This defines the specific program instance.
  • IGS_EN_UNIT_SET_ALL (Unit Set): Joined via the composite key (UNIT_SET_CD, US_VERSION_NUMBER). This defines the specific set of academic units.
  • IGS_FI_FUND_SRC_ALL (Funding Source): Joined via the FUNDING_SOURCE column. This provides the valid HESA funding code applicable to the linked program and unit set.

The table's primary key, IGS_HE_POOUS_ALL_PK on HESA_POOUS_ID, ensures uniqueness and is likely referenced by other HESA-related detail or history tables.