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, andKEY1is enforced as a unique business key by indexIGS_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.
-
HESA Submission Award Periods Table
-
In Oracle Internet Expenses, both the view projects and Task Function and the Task Number List of Values are based on this view
APPS.AP_WEB_PA_PROJECTS_TASKS_V·↳ AP_WEB_FND_LOOKUPS_PKG·↳ FND_PROFILE·↳ GMS_SSA_AWARDS_V·Explore AP module →
-
In Oracle Internet Expenses, both the view projects and Task Function and the Task Number List of Values are based on this view
APPS.AP_WEB_PA_PROJECTS_TASKS_V·↳ AP_WEB_FND_LOOKUPS_PKG·↳ FND_PROFILE·↳ GMS_SSA_AWARDS_V·Explore AP module →
-
TABLE: IGS.IGS_HE_SUBMSN_AWD 12.1.1
-
View: GMS_BIS_AWD_ACT_SRC_V 12.2.2
Not implemented in this database·Explore GMS module →
-
View: GMS_BIS_AWD_ACT_SRC_V 12.1.1
Not implemented in this database·Explore GMS module →
-
Set Distribution Table.
-
Set Distribution Table.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.