Search Results tertiary_edu_lvl_qual

Overview

The table IGS_AD_TER_ED_LVL_QF is a reference data table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the now-obsolete IGS (Student System) module. Its primary function is to store institutionally defined codes that describe the level of qualification an applicant achieved during their previous tertiary education. This table acts as a central lookup, enabling consistent classification of prior academic attainment for use in admissions processing and applicant evaluation workflows. The provided ETRM metadata explicitly notes this table is "Not implemented in this database," indicating it may have been part of a data model that was not deployed in a standard installation or was superseded in later releases.

Key Information Stored

The table's structure is designed to manage a controlled list of qualification levels. The central column is TERTIARY_EDU_LVL_QUAL, which serves as the unique primary key for each qualification level record. This column typically holds a short code or identifier. While the full column list is not detailed in the excerpt, a table of this nature would commonly include descriptive columns such as a full name, description, effective dates, and an order or hierarchy indicator. The foreign key column TAC_LEVEL_OF_QUAL establishes a link to another reference table (IGS_AD_TAC_LVL_OF_QF), suggesting a potential relationship to tertiary admissions center or external qualification frameworks.

Common Use Cases and Queries

The primary use case is to validate and categorize an applicant's prior education level during data entry or batch processing. For reporting, it enables analysis of applicant pools by their highest prior qualification. A typical query would join this table to the main applicant tertiary education history table to translate codes into meaningful descriptions for reports.

• Basic Lookup: SELECT tertiary_edu_lvl_qual, description FROM igs_ad_ter_ed_lvl_qf WHERE sysdate BETWEEN start_date AND NVL(end_date, sysdate);
• Reporting Join: SELECT te.applicant_id, te.institution, qf.description AS qual_level FROM igs_ad_ter_edu te JOIN igs_ad_ter_ed_lvl_qf qf ON te.tertiary_edu_lvl_qual = qf.tertiary_edu_lvl_qual;

Related Objects

The ETRM metadata defines clear foreign key relationships for this table, outlining its integration points within the obsolete Student System data model.

• Referenced Foreign Key: The column IGS_AD_TER_ED_LVL_QF.TAC_LEVEL_OF_QUAL references the table IGS_AD_TAC_LVL_OF_QF. This links the internal qualification level to an external or standardized classification.
• Referencing Foreign Key: The column IGS_AD_TER_EDU.TERTIARY_EDU_LVL_QUAL references IGS_AD_TER_ED_LVL_QF.TERTIARY_EDU_LVL_QUAL. This is the primary usage link, where each record in the IGS_AD_TER_EDU table (which stores details of an applicant's prior tertiary education) is assigned a level of qualification from this lookup table.