Search Results igs_he_sub_rtn_qual

Overview

The IGS_HE_SUB_RTN_QUAL table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a master definition table for qualifying periods associated with a Destination of Leavers from Higher Education (DLHE) submission return. A DLHE return is a standard survey of graduate outcomes. This table stores the valid time periods (e.g., specific academic years or terms) for which student data can be included in a given DLHE submission return, ensuring data integrity and proper reporting boundaries. Its primary role is to define the temporal scope of a return, which is then referenced when linking individual student DLHE records to that submission.

Key Information Stored

The table's structure is defined by its composite primary key and its relationship to the parent submission return. The critical columns are:

• SUBMISSION_NAME, USER_RETURN_SUBCLASS, RETURN_NAME: These columns form part of the foreign key to the parent table IGS_HE_SUBMSN_RETURN, uniquely identifying the specific DLHE submission return to which this qualifying period belongs.
• QUAL_PERIOD_CODE: The fourth component of the primary key (IGS_HE_SUB_RTN_QUAL_PK). This code identifies the specific qualifying academic period (e.g., "2021-22") that is valid for the associated submission return. The combination of these four columns ensures a unique qualifying period definition per return.

Together, these fields establish which time periods are eligible for inclusion in a specific DLHE data collection exercise.

Common Use Cases and Queries

This table is primarily used in administrative setup and validation processes. A common operational use case is during the configuration of a new DLHE survey cycle, where an administrator defines the one or more academic periods that qualify for the return. For reporting and data validation, a typical query would join this table to the student data to verify or list all qualifying periods for a return. For example:

SELECT qual.submission_name, qual.return_name, qual.qual_period_code
FROM igs.igs_he_sub_rtn_qual qual
WHERE qual.submission_name = '&SUBMISSION'
AND qual.return_name = '&RETURN'
ORDER BY qual.qual_period_code;

Another critical use is as a constraint when generating or submitting individual student DLHE records; the system validates that a student's record period matches a QUAL_PERIOD_CODE defined in this table for the relevant return.

Related Objects

The IGS_HE_SUB_RTN_QUAL table sits at the center of a key relationship hierarchy within the DLHE functionality.

• Parent Table (Foreign Key): IGS_HE_SUBMSN_RETURN is the primary parent. The foreign key on SUBMISSION_NAME, USER_RETURN_SUBCLASS, and RETURN_NAME ensures every qualifying period is attached to a valid submission return definition.
• Child Table (Foreign Key): IGS_HE_STDNT_DLHE is the primary child table. It stores the individual student DLHE records and references IGS_HE_SUB_RTN_QUAL via its columns SUBMISSION_NAME, USER_RETURN_SUBCLASS, RETURN_NAME, and QUAL_PERIOD_CODE. This enforces that each student record is associated with a pre-defined, valid qualifying period for that return.

This relationship chain ensures data consistency from the high-level return definition down to the granular student records.