Search Results igs_he_submsn_awd_u1




Overview
Explore in AI Chat

Overview

The IGS.IGS_HE_SUBMSN_AWD table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically within the IGS (iGrad Student) product family. It functions as the HESA (Higher Education Statistics Agency) Submission Award Periods table. Its primary role is to store and manage the temporal boundaries—start and end dates—for award conferral periods associated with specific HESA data submissions. This table is critical for ensuring that award-related data is correctly aligned with the appropriate reporting timeframe for statutory HESA returns, a mandatory requirement for educational institutions in the UK.

Key Information Stored

The table's structure is designed to define a unique award period within a submission. The key columns include:

  • SUB_AWD_ID (NUMBER): The internal, system-generated primary key for each record, uniquely identifying an award period definition.
  • SUBMISSION_NAME (VARCHAR2(50)): The name of the HESA submission to which this award period belongs. This column is part of a unique constraint and establishes a foreign key relationship to the submission header.
  • TYPE (VARCHAR2(12)): Denotes the Award Conferral Key Type, classifying the nature of the period.
  • KEY1, KEY2, KEY3 (VARCHAR2(60)): These are key value fields used in conjunction with the TYPE column to provide granular context or categorization for the award period.
  • AWARD_START_DATE and AWARD_END_DATE (DATE): The definitive start and end dates that bound the award conferral period for reporting purposes.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns that track the creation and last update details for each row, following EBS conventions.

Common Use Cases and Queries

This table is primarily accessed during the configuration and execution of HESA submission processes. A common use case is validating or reporting on the defined award periods for a specific submission cycle. For instance, an administrator might need to retrieve all award periods for the '2023-24 Student Return' to verify date ranges before data extraction. The fundamental query pattern, as indicated in the ETRM, selects all columns. A more targeted query to find periods for a specific submission would be: SELECT SUB_AWD_ID, TYPE, KEY1, AWARD_START_DATE, AWARD_END_DATE FROM IGS.IGS_HE_SUBMSN_AWD WHERE SUBMISSION_NAME = :p_submission_name ORDER BY AWARD_START_DATE; This table is also integral to backend logic within the HESA submission engine, where its data is used to filter and aggregate student award records that fall within the specified dates for inclusion in the statutory return files.

Related Objects

Based on the provided relationship data, IGS_HE_SUBMSN_AWD has defined connections to other EBS objects:

  • Primary Key: The table is enforced by the primary key constraint IGS_HE_SUBMSN_AWD_PK on the column SUB_AWD_ID.
  • Foreign Key (Referenced By): The table references another object via a foreign key. The column SUBMISSION_NAME references the IGS_HE_SUBMSN_HEADER table, linking each award period to a master submission record.
  • Unique Indexes: Two unique indexes exist: IGS_HE_SUBMSN_AWD_U1 on SUB_AWD_ID (supporting the PK) and IGS_HE_SUBMSN_AWD_U2 on SUBMISSION_NAME, TYPE, and KEY1, ensuring no duplicate period definitions are created for the same submission and key combination.
The table is a referenced object within the APPS schema, indicating it is likely accessed through synonym APPS.IGS_HE_SUBMSN_AWD by various application modules and custom code.