Results for “organization_unit_code”

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

Overview

The view IGSFV_UK_PRG_OFR_OPT_ORG_UNITS is a full (F) Oracle E-Business Suite view owned by the APPS schema and defined within the IGS – Student System product. Its documented purpose is to expose Program Offering Option Unit Set HESA Details – Organizations. In practice this view provides a denormalized, read-only reporting layer over the UK Higher Education Statistics Agency (HESA) data held for the organizational unit allocations attached to a program offering option's unit set. It is a "full view" in the ETRM sense: rather than returning only the identifiers needed to drive a form, it resolves description columns so that downstream reports, extracts and HESA returns can be produced without further joins.

Because the object is a view with the WITH READ ONLY clause, it cannot be used for DML. Its role is confined to query, reporting and integration workloads — typically the generation of statutory HESA organization/proportion returns and internal management reporting on which organizations co-deliver a unit set within a program offering option.

Underlying Base Objects

The view text is defined over four mandatory base tables joined on the program/unit-set identity, plus several correlated scalar sub-queries against reference tables. The four driving tables are:

• IGS_HE_POOUS_OU_ALL (alias POU) — the Program Offering Option Unit Set Organization Unit allocation table; the primary HESA detail source containing organization unit, proportion and audit columns.
• IGS_PS_VER_ALL (alias PS) — program version records supplying program title, short title and abbreviation.
• IGS_EN_UNIT_SET_ALL (alias EN) — unit set versions supplying unit set title, short title and abbreviation.
• IGS_CA_TYPE (alias CA) — calendar type definitions supplying calendar description and abbreviation.

Joins are made on COURSE_CD and CRV_VERSION_NUMBER (to the program version), UNIT_SET_CD and US_VERSION_NUMBER (to the unit set version), and CAL_TYPE (to the calendar type). Three correlated sub-queries resolve further descriptions: IGS_AD_LOCATION_ALL for the location description, IGS_EN_ATD_MODE_ALL for the attendance mode description, and IGS_EN_ATD_TYPE_ALL for the attendance type description. The organization unit name is resolved through HZ_PARTIES joined to IGS_PE_HZ_PARTIES on OSS_ORG_UNIT_CD and PARTY_ID. No base objects are separately documented in the ETRM metadata, but the view text identifies the above as the effective source tables.

Key Columns

• HESA_POOUS_OU_ID — surrogate primary key of the underlying organization unit allocation row.
• PROGRAM_CODE, PROGRAM_TITLE, PROGRAM_SHORT_TITLE, PROGRAM_ABBREVIATION, PROGRAM_VERSION_NUMBER — identification of the program offering option.
• CALENDAR_TYPE, CALENDAR_DESC, CALENDAR_ABBREVIATION — calendar context for the offering.
• LOCATION_CODE, LOCATION_DESC — delivery location and its resolved description.
• ATTENDANCE_MODE, ATTENDANCE_MODE_DESC, ATTENDANCE_TYPE, ATTENDANCE_TYPE_DESC — attendance attributes with resolved reference descriptions.
• UNIT_SET_CODE, UNIT_SET_TITLE, UNIT_SET_SHORT_TITLE, UNIT_SET_ABBREVIATION, UNIT_SET_VERSION_NUMBER — the unit set and version to which the organization allocation belongs.
• ORGANIZATION_UNIT_CODE, ORGANIZATION_UNIT_NAME, ORGANIZATION_UNIT_PROP — the organization unit, its party name, and the proportion of the unit set attributed to it; central to HESA organization reporting.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns.

Common Use Cases and Queries

The view is typically queried to produce HESA organization returns for a program offering option, and to audit the proportion split across organizations. A representative query is:

• SELECT PROGRAM_CODE, PROGRAM_TITLE, UNIT_SET_CODE, ORGANIZATION_UNIT_CODE, ORGANIZATION_UNIT_NAME, ORGANIZATION_UNIT_PROP FROM APPS.IGSFV_UK_PRG_OFR_OPT_ORG_UNITS WHERE PROGRAM_CODE = :p_program_code;
• SELECT UNIT_SET_CODE, ORGANIZATION_UNIT_NAME, SUM(ORGANIZATION_UNIT_PROP) FROM APPS.IGSFV_UK_PRG_OFR_OPT_ORG_UNITS GROUP BY UNIT_SET_CODE, ORGANIZATION_UNIT_NAME HAVING SUM(ORGANIZATION_UNIT_PROP) <> 1;
• SELECT CALENDAR_TYPE, CALENDAR_DESC, LOCATION_DESC, ATTENDANCE_MODE_DESC, ORGANIZATION_UNIT_NAME FROM APPS.IGSFV_UK_PRG_OFR_OPT_ORG_UNITS WHERE HESA_POOUS_OU_ID = :id;

Because it is read-only and pre-joins the descriptive attributes, the view is well suited to BIPublisher, Discoverer and custom concurrent-program extracts, removing the need for consumers to replicate the IGS-HESA join logic.