Results for “igs_he_submsn_header_u1”

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

Overview

IGS.IGS_HE_SUBMSN_HEADER is a transactional table in the Oracle E-Business Suite IGS (Student Systems / Higher Education) schema. It holds the header-level definition of a HESA (Higher Education Statistics Agency) return submission, capturing the parameters that are applied across every return included within that submission. Because a single submission can bundle multiple returns, this table acts as the controlling record that governs date filtering, offset behaviour, completion state, and validation configuration shared by all associated return detail rows.

The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, consistent with standard transactional data storage in EBS 12.1.1 and 12.2.2. From a Data Vault modeling perspective, the mined relationship structure (two dependent child tables referencing this object via SUBMISSION_NAME, with no upward foreign keys) suggests a hub-leaning classification. This should be treated as a modeling suggestion only, reflecting that the table functions as a business-key anchor around which submission-level details are organized.

Key Information Stored

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

• SUB_HDR_ID — Sequence-generated surrogate identifier that uniquely identifies each submission header. It is enforced by the unique index IGS_HE_SUBMSN_HEADER_U2 and serves as the internal technical key.
• SUBMISSION_NAME — A VARCHAR2(50) business identifier for the submission. It is the documented primary key column (IGS_HE_SUBMSN_HEADER_PK) and is also enforced by the unique index IGS_HE_SUBMSN_HEADER_U1. This makes it both the declared PK and the principal business-key candidate, and it is the column through which child tables join.
• DESCRIPTION — VARCHAR2(200) free-text description of the submission's purpose.
• ENROLMENT_START_DATE and ENROLMENT_END_DATE — The bounds of the enrolment period for which the submission is defined.
• OFFSET_DAYS — A numeric offset applied during return filtering, together with APPLY_TO_ATMPT_ST_DT and APPLY_TO_INST_ST_DT, which flag whether that offset is applied to the Program Attempt Start Date or the Calendar Instance Start Date respectively.
• COMPLETE_FLAG — Indicates whether the submission has been sent and successfully verified by HESA.
• VALIDATION_COUNTRY — VARCHAR2(30) code identifying the validation country used when running the HESA validation kit.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide audit lineage.

Common Use Cases and Queries

Typical scenarios include identifying open or completed submissions for a given enrolment period, reviewing offset configuration before a return run, and joining header parameters to return and award detail rows. A representative query resolves submissions still pending completion:

• SELECT sub_hdr_id, submission_name, enrolment_start_date, enrolment_end_date FROM igs.igs_he_submsn_header WHERE complete_flag = 'N';
• To expand a submission into its constituent returns and awards, join on SUBMISSION_NAME to IGS_HE_SUBMSN_RETURN and IGS_HE_SUBMSN_AWD, which enables reporting on which awards fall inside a submission's enrolment window.
• Offset auditing: select OFFSET_DAYS alongside APPLY_TO_ATMPT_ST_DT and APPLY_TO_INST_ST_DT to confirm date-filter behaviour prior to generating a HESA return, so that the validation kit is applied against the intended population.

Related Objects

The FK metadata identifies two child tables that reference this header through the SUBMISSION_NAME column:

• IGS.IGS_HE_SUBMSN_RETURN — joins on SUBMISSION_NAME → IGS_HE_SUBMSN_HEADER.SUBMISSION_NAME; holds the individual returns belonging to the submission.
• IGS.IGS_HE_SUBMSN_AWD — joins on SUBMISSION_NAME → IGS_HE_SUBMSN_HEADER.SUBMISSION_NAME; holds award-level data scoped to the submission.

Together these dependent objects inherit the enrolment window, offset, and validation-country parameters defined here, confirming IGS_HE_SUBMSN_HEADER as the parent hub of the HESA submission structure.