Search Results igs_ad_ter_ed_lvl_qf_n1

Overview

The IGS_AD_TER_ED_LVL_QF table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or related educational modules under the IGS schema. It functions as a master repository for institution-defined codes that classify the level of qualification achieved by an applicant from their previous tertiary education. This table is critical for standardizing and mapping internal qualification levels to external standards, such as those used by tertiary admission centers, thereby facilitating consistent applicant evaluation, reporting, and data exchange within the admissions lifecycle.

Key Information Stored

The table stores the definition and mapping for each tertiary education level of qualification code. The primary and most significant columns include:

• TERTIARY_EDU_LVL_QUAL (VARCHAR2(10), Mandatory): The unique, institution-defined identifier for the qualification level. This is the primary key of the table.
• DESCRIPTION (VARCHAR2(60)): The explanatory text for the code, providing context and meaning.
• TAC_LEVEL_OF_QUAL (VARCHAR2(10)): A critical mapping field that holds a code recognized by an external Tertiary Admission Center (TAC). This enables the translation of internal institution codes to a standardized external coding system.
• CLOSED_IND (VARCHAR2(1)): A status flag indicating whether the code is active ('N') or closed ('Y'). Closed codes cannot be used in new records, supporting data integrity and phased retirement of old codes.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns that track the creation and modification history of each record.

Common Use Cases and Queries

This table is primarily used in applicant qualification assessment, reporting, and system integration. Common operational scenarios include validating an applicant's entered qualification level against the master list, populating drop-down lists in application forms, and generating reports for admission centers that require the standardized TAC code. A fundamental query to retrieve all active qualification levels for use in an application interface or validation lookup would be:

SELECT tertiary_edu_lvl_qual,
       description,
       tac_level_of_qual
FROM   igs.igs_ad_ter_ed_lvl_qf
WHERE  NVL(closed_ind, 'N') = 'N'
ORDER BY description;

For data migration or integration with a Tertiary Admission Center, a mapping report can be generated using the provided query template from the ETRM, which selects all columns for analysis. Administrators frequently query this table to audit code usage before marking a code as closed.

Related Objects

Based on the provided metadata, the IGS_AD_TER_ED_LVL_QF table has defined relationships with other objects. The unique index (IGS_AD_TER_ED_LVL_QF_U1) on the TERTIARY_EDU_LVL_QUAL column enforces the primary key constraint. The non-unique index (IGS_AD_TER_ED_LVL_QF_N1) on the TAC_LEVEL_OF_QUAL column suggests this field is frequently used in joins or filtering, likely for mapping operations. This table is a referenced lookup table, meaning its primary key (TERTIARY_EDU_LVL_QUAL) is almost certainly used as a foreign key in other transactional tables within the IGS schema that store applicant-specific qualification details, such as tables related to applicant academic history or previous institutions attended. Identifying these specific dependent tables would require examining the foreign key constraints in the EBS data model.