Results for “award_start_date”

18 results




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

Overview

The IGS_HE_SUBMSN_AWD table is a core data object within the IGS — Student System product of Oracle E-Business Suite, appearing in both release 12.1.1 and 12.2.2. It stores the award period information that is assembled and transmitted to the Higher Education Statistics Agency (HESA) as part of a statutory student return. Each row represents a single award period record associated with a named HESA submission, capturing the qualifying dates and categorisation keys that describe when a student's award was active during the reporting reference period.

The table is owned by the IGS schema and holds a documented status of VALID. Its primary key, IGS_HE_SUBMSN_AWD_PK, is defined on the surrogate column SUB_AWD_ID. A foreign key relationship ties SUBMISSION_NAME back to IGS_HE_SUBMSN_HEADER, meaning the award records are always scoped to a parent submission header.

Applying a heuristic Data Vault classification, the table models as satellite-leaning. It carries descriptive, time-bounded attributes (award start and end dates plus type and key qualifiers) that hang off a parent business key (the submission), which is the characteristic shape of a satellite rather than a hub or a link.

Key Information Stored

Thirteen columns are documented for this table. The most significant include:

  • SUB_AWD_ID — the surrogate primary key, uniquely identifying each award period row. It is also enforced by the unique index IGS_HE_SUBMSN_AWD_U1.
  • SUBMISSION_NAME — the parent submission identifier, foreign-keyed to IGS_HE_SUBMSN_HEADER.SUBMISSION_NAME. This is the principal business-key column.
  • TYPE, KEY1, KEY2, KEY3 — classification and qualifier columns used to distinguish the nature of the award period and to align it with HESA coding requirements. The combination of SUBMISSION_NAME, TYPE, and KEY1 is enforced as a unique business key by index IGS_HE_SUBMSN_AWD_U2.
  • AWARD_START_DATE and AWARD_END_DATE — the effective start and end dates of the award period, which drive the reporting window logic.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns tracking who created and last modified each record and when.

The distinction between the surrogate key (SUB_AWD_ID) and the business-key candidates (SUBMISSION_NAME, TYPE, KEY1) is important when writing de-duplication or reconciliation logic.

Common Use Cases and Queries

Typical use cases centre on validating and reconciling a HESA return before transmission. Practitioners frequently need to confirm that every award period falls within the reporting year, or that no submission header is missing its expected award rows.

A representative query confirms award periods for a given submission:

  • SELECT sub_awd_id, submission_name, type, key1, award_start_date, award_end_date FROM igs.igs_he_submsn_awd WHERE submission_name = :p_submission ORDER BY award_start_date;
  • Detecting overlapping or out-of-range award periods: SELECT * FROM igs.igs_he_submsn_awd WHERE award_start_date < :reference_start OR award_end_date > :reference_end;
  • Auditing recently modified records: SELECT * FROM igs.igs_he_submsn_awd WHERE last_update_date >= TRUNC(SYSDATE) - 7;

Related Objects

The following objects are most significant in relation to this table:

  • IGS_HE_SUBMSN_HEADER — the parent table; joined via IGS_HE_SUBMSN_AWD.SUBMISSION_NAME = IGS_HE_SUBMSN_HEADER.SUBMISSION_NAME.
  • IGS_HE_SUBMSN_AWD_PK — the primary key constraint on SUB_AWD_ID.
  • IGS_HE_SUBMSN_AWD_U1 and IGS_HE_SUBMSN_AWD_U2 — unique indexes supporting surrogate and business-key integrity.
  • Other IGS_HE_SUBMSN_* satellite tables (e.g. student, module, and qualification submission tables) that share the same submission header, forming the wider HESA return set.