Search Results qual_period_start_date

Overview

The IGS.IGS_HE_SUB_RTN_QUAL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Higher Education (HE) product family. It functions as the master repository for defining and managing qualifying periods associated with a Destination of Leavers from Higher Education (DLHE) submission return. A qualifying period represents a specific timeframe, such as an academic year or term, used to identify the cohort of students (leavers, researchers, or manually selected) who are subject to a particular survey. This table is essential for configuring and executing statutory reporting processes mandated by educational authorities, ensuring the correct student population is captured for employment outcome surveys.

Key Information Stored

The table stores configuration details that define each qualifying period's temporal boundaries and purpose. The primary key is a composite of SUBMISSION_NAME, USER_RETURN_SUBCLASS, RETURN_NAME, and QUAL_PERIOD_CODE. Critical operational columns include QUAL_PERIOD_TYPE, which classifies the student cohort as Leaver (L), Research (R), or Manual (M). The date columns QUAL_PERIOD_START_DATE and QUAL_PERIOD_END_DATE define the effective period, while CENSUS_DATE is a pivotal date used for official population counts. SURVEY_START_DATE and SURVEY_END_DATE delineate the active survey window. The CLOSED_IND flag (Y/N) controls whether the period is available for data entry or processing. Notably, the CENSUS_DATE column, central to the user's search, serves as the official snapshot date for determining student eligibility within the qualifying period.

Common Use Cases and Queries

This table is primarily accessed for configuring survey cycles and generating student lists for DLHE returns. Common operational and reporting scenarios include identifying all open qualifying periods for a specific return, validating census dates for a reporting cycle, and troubleshooting student inclusion in a survey. A typical query to find active periods for a return, including the key census date, would be:

• SELECT submission_name, return_name, qual_period_code, census_date, qual_period_start_date, qual_period_end_date FROM igs.igs_he_sub_rtn_qual WHERE closed_ind = 'N' AND return_name = :p_return_name ORDER BY qual_period_start_date;

Another critical use case involves joining this table to student data tables to extract the target survey population based on the QUAL_PERIOD_TYPE and the date boundaries, particularly using the CENSUS_DATE as a key filter for student academic status.

Related Objects

The IGS_HE_SUB_RTN_QUAL table is a foundational reference table within the HE submissions architecture. It is referenced by any process or form that requires qualifying period details, such as submission batch programs and survey data entry screens. The unique primary key index IGS_HE_SUB_RTN_QUAL_PK enforces data integrity. This table likely has foreign key relationships with parent submission definition tables (e.g., IGS_HE_SUB_RTN) and is a parent table to transactional data tables that store the actual student survey responses or leaver records for each defined qualifying period. Its data is integral to the APIs and concurrent processes that generate the final statutory return files.