Search Results igs_he_st_unv_dtls_v

Overview

The view IGS_HE_ST_UNV_DTLS_V belongs to the IGS (Student System) product family, a module now classified as obsolete within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to expose "Hesa Unit Details" — that is, the unit-level (module-level) data elements that the Higher Education Statistics Agency (HESA) requires for statutory returns filed by UK higher-education institutions. In EBS terms, this view serves as a reporting and integration surface: rather than requiring downstream extract programs, statutory return scripts, or data-warehouse loads to join the underlying student-system tables manually, the view presents a denormalised, code-translated projection of the unit version records.

The view is documented in ETRM 12.2.2 as not implemented in the reference database, so it should be treated as a shipped definition that exists in environments where the IGS/HESA functionality has been deployed and patched in. Its role is read-only: it is intended for SELECT-based consumption by HESA return generation, institutional reporting, and interface extracts.

Underlying Base Objects

ETRM lists no separately documented referenced base objects, but the embedded view text identifies four source objects joined in the view definition:

• IGS_HE_ST_UNT_VS (aliased A) — the driving HESA student unit-version record, holding the unit code, version number, teaching proportion in Welsh, credit transfer scheme, module length, FTE proportion, campus location, and audit columns.
• IGS_PS_UNIT_VER (aliased B) — the standard student-system unit version table, supplying the unit short title. It is joined on both UNIT_CD and VERSION_NUMBER.
• IGS_HE_CODE_VALUES (aliased C) — the HESA code-values lookup, outer-joined on CREDIT_TRANSFER_SCHEME where CODE_TYPE = 'OSS_CRDTSCM'. This is the join that corresponds to the user's search term "oss_crdtscm".
• IGS_AD_LOCATION (aliased D) — the address/location table, outer-joined on LOCATION_CD where LOCATION_TYPE = 'CAMPUS', providing the campus description.

Both lookup joins use Oracle's outer-join operator (+), ensuring that unit-version rows are still returned when no matching code value or campus exists.

Key Columns

• ROW_ID — the physical ROWID of the driving IGS_HE_ST_UNT_VS row; useful for row-level identification and de-duplication.
• HESA_ST_UNT_VS_ID — the primary identifier of the HESA student unit version record.
• UNIT_CD and VERSION_NUMBER — the composite business key linking a unit to a specific version.
• SHORT_TITLE — the abbreviated unit title sourced from IGS_PS_UNIT_VER.
• PROP_OF_TEACHING_IN_WELSH — the proportion of teaching delivered through the medium of Welsh, a HESA return field.
• CREDIT_TRANSFER_SCHEME and CREDIT_TRANSFER_SCHEME_DESC — the coded value and its decoded description from IGS_HE_CODE_VALUES for code type OSS_CRDTSCM.
• MODULE_LENGTH and PROPORTION_OF_FTE — the unit's length and its FTE weighting.
• LOCATION_CD and LOCATION_DESC — the campus code and its descriptive name.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.
• EXCLUDE_FLAG — an indicator controlling whether the record is excluded from HESA extract processing.

Common Use Cases and Queries

Typical scenarios include building HESA unit-return extracts, validating credit transfer scheme coding, and auditing campus assignments per unit version. A representative query filtering by the credit transfer scheme code type is shown below:

• SELECT unit_cd, version_number, short_title, credit_transfer_scheme_desc, location_desc, proportion_of_fte FROM igs_he_st_unv_dtls_v WHERE credit_transfer_scheme = '01' AND exclude_flag = 'N';
• SELECT * FROM igs_he_st_unv_dtls_v WHERE unit_cd = :unit_code AND version_number = :version ORDER BY unit_cd, version_number;
• SELECT location_cd, location_desc, COUNT(*) FROM igs_he_st_unv_dtls_v GROUP BY location_cd, location_desc;

Because the view performs code translation and outer joins already, consumers should avoid re-joining the same lookup tables and should apply the EXCLUDE_FLAG filter when the requirement is to reproduce official HESA extract populations.