Results for “igs_he_st_unt_vs_all_pk”

4 results




Overview
Explore in AI Chat

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

Overview

IGS_HE_ST_UNT_VS_ALL is an Oracle E-Business Suite table within the IGS – Student System (Obsolete) product family. It stores Higher Education Statistics Agency (HESA) information on Units, captured at the unit version level. The table supports statutory HESA returns by holding the teaching, credit, funding, and delivery attributes that the institution must report for each versioned unit of study.

The metadata notes that this object is not implemented in the documented database, and the product classification is marked obsolete. It therefore exists primarily as a reference object for institutions that historically ran the IGS/HESA reporting stack or maintained legacy ETRM documentation. No runtime data dictionary entry should be expected in a current 12.1.1 or 12.2.2 environment unless the obsolete IGS product group was explicitly installed.

From a Data Vault modeling perspective, the mined relationship data classifies this table as satellite-leaning. Its foreign key to IGS_PS_UNIT_VER_ALL on UNIT_CD and VERSION_NUMBER indicates a dependent descriptive record rather than an independent hub or a many-to-many link. The surrogate key HESA_ST_UNT_VS_ID anchors the satellite rows, while the natural identifier ties each row to exactly one unit version.

Key Information Stored

The table contains 15 documented columns. The most significant are:

  • HESA_ST_UNT_VS_ID — the surrogate primary key defined by IGS_HE_ST_UNT_VS_ALL_PK and enforced by unique index IGS_HE_ST_UNT_VS_ALL_U1.
  • UNIT_CD and VERSION_NUMBER — the business-key candidates, forming unique index IGS_HE_ST_UNT_VS_ALL_U2 and serving as the foreign key to IGS_PS_UNIT_VER_ALL.
  • ORG_ID — the operating unit, supporting multi-org reporting.
  • PROP_OF_TEACHING_IN_WELSH — the proportion of teaching delivered through the medium of Welsh, a HESA-specific statutory field.
  • CREDIT_TRANSFER_SCHEME — indicates the credit transfer arrangement applicable to the unit.
  • MODULE_LENGTH — the reported length of the module/unit.
  • PROPORTION_OF_FTE — the proportion of full-time equivalent study represented by the unit.
  • LOCATION_CD — the delivery location code.
  • EXCLUDE_FLAG — a suppression indicator that excludes the record from HESA submission processing.

Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — provide auditability. Together, these fields describe a single unit version's HESA characteristics.

Common Use Cases and Queries

The primary use case is HESA statutory returns, where institutions extract unit-level data for the Student, Unit, and Qualifications records. Secondary uses include internal quality assurance and credit framework reporting.

A typical query joins the satellite back to its parent unit version to retrieve descriptive unit details:

  • HESA extract: select UNIT_CD, VERSION_NUMBER, PROP_OF_TEACHING_IN_WELSH, CREDIT_TRANSFER_SCHEME, MODULE_LENGTH, PROPORTION_OF_FTE, and LOCATION_CD from IGS_HE_ST_UNT_VS_ALL where EXCLUDE_FLAG is not set.
  • Version comparison: filter by UNIT_CD and order by VERSION_NUMBER to track attribute changes across versions.
  • Multi-org reporting: restrict by ORG_ID where the institution operates multiple reporting entities.

Because the object is obsolete and not implemented, these patterns apply to legacy or migrated environments. Any production query should first confirm table existence and column availability in the target instance.

Related Objects

The documented relationships identify the following significant dependencies:

  • IGS_PS_UNIT_VER_ALL — the parent unit version table, joined on UNIT_CD and VERSION_NUMBER. This is the only documented foreign key target and the principal join partner.
  • IGS_HE_ST_UNT_VS_ALL_PK — the primary key constraint defining uniqueness on HESA_ST_UNT_VS_ID.
  • IGS_HE_ST_UNT_VS_ALL_U1 — unique index on the surrogate key.
  • IGS_HE_ST_UNT_VS_ALL_U2 — unique index on UNIT_CD and VERSION_NUMBER, enforcing one HESA satellite row per unit version.
  • Sibling HESA tables within the IGS_HE_* namespace — related satellites for student, qualification, and institution-level returns that share the same obsolete product grouping.

No views or APIs are documented as referencing this table in the supplied metadata; integration should be validated against the specific instance before use.