Results for “igs_he_ucas_imp_int_pk”

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

Overview

IGS_HE_UCAS_IMP_INT is a staging interface table within the Oracle E-Business Suite IGS – Student System module. It is documented as an obsolete component in the ETRM reference for releases 12.1.1 and 12.2.2, and the ETRM implementation record explicitly notes that it is not implemented in this database, meaning that on environments where the object is absent it should be treated as a legacy artifact rather than an active repository.

The table's stated purpose is to hold Higher Education Statistics Agency (HESA) student detail records arriving from UCAS and other legacy source systems. In practice it functions as an inbound landing zone: external submission files are loaded into this table, validated, corrected, and then propagated downstream into the core student registration and statutory reporting structures.

Data Vault classification is provided as a heuristic mined from the foreign-key structure and is rated standalone. Where such a classification is offered, it is best read as a modeling suggestion: the table carries no parent hub relationships of its own and is referenced only by a dependent error table, so it behaves as a single, self-contained staging entity rather than as a conventional hub, link, or satellite.

Key Information Stored

The physical schema documented for 12.1.1 defines 54 columns owned by the IGS schema. The surrogate primary key is INTERFACE_HESA_ID, enforced by the unique index IGS_HE_UCAS_IMP_INT_PK, which is also the only business-key candidate identified. The most significant columns fall into distinct groups:

• Load control: BATCH_ID groups records from a single submission; INTERFACE_HESA_ID uniquely identifies each row.
• Student identity: HUSID (HESA unique student identifier), PERSON_NUMBER (link to the person record), SURNAME, GIVEN_NAMES, BIRTH_DT, and SEX.
• Programme and entry data: COURSE_CD, UNIT_SET_CD, UCASNUM, YEAR_LEFT, and HIGHEST_QUAL_ON_ENTRY.
• Personal characteristics: DOMICILE_CD, COUNTRY_CODE, ETHNIC_ORIGIN, DISABILITY_TYPE, POSTCODE, SOCIAL_CLASS_IND, and OCCUPATION_CODE.
• Tariff and qualification detail: TOTAL_UCAS_TARIFF, the paired *N/*TS columns spanning GCE A/AS, VCE, KS, UKS, SAH, SH, SI2, SSGC, SCS, and AEA awards, plus SUBJECT_QUALAIM1 through SUBJECT_QUALAIM3 and QUALAIM_PROPORTION.
• Other: FEE_ELIGIBILITY, INST_CODE, SCOTVEC, and PREV_INST_LEFT_DATE.

Common Use Cases and Queries

Typical use is reconciliation and exception handling during statutory returns. A batch-level row count confirms load completeness:

SELECT BATCH_ID, COUNT(*) FROM IGS_HE_UCAS_IMP_INT GROUP BY BATCH_ID;

Exception triage joins the staging rows to the error table on INTERFACE_HESA_ID to isolate rejected records before correcting and resubmitting them. Tariff analysis aggregates TOTAL_UCAS_TARIFF by COURSE_CD or DOMICILE_CD, while characteristics such as ETHNIC_ORIGIN and DISABILITY_TYPE support equal-opportunities and widening-participation reporting. Because the table is documented as obsolete and unimplemented, any query against it should first be verified against the target instance's data dictionary.

Related Objects

• IGS_HE_UCAS_IMP_ERR — the principal dependent table; its INTERFACE_HESA_ID column carries a foreign key to this table, holding validation failures for each staged row.
• IGS_HE_UCAS_IMP_INT_PK — the primary key constraint and unique index on INTERFACE_HESA_ID, referenced by the error table.
• Person and student registration tables reached via PERSON_NUMBER, the practical path for promoting validated staging rows into the student record.
• Course and unit-set validation objects matched on COURSE_CD and UNIT_SET_CD to confirm the submitted programme exists.
• HESA return and extract processes that consume the characteristics and qualification columns for regulatory submissions.