Search Results igs_ad_ter_ed_lv_com_pk

Overview

The IGS_AD_TER_ED_LV_COM table is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically supporting the admissions functionality. It serves as a reference or lookup table that standardizes and defines the various levels of completion an applicant may have achieved in their previous tertiary education. Its primary role is to maintain a controlled list of completion statuses—such as "Completed," "Partially Completed," or "Diploma Awarded"—which can then be consistently assigned to an applicant's educational history records. This ensures data integrity and uniformity in reporting and processing admissions decisions across the institution.

Key Information Stored

The table's structure is designed to store descriptive codes for completion levels. The central column is TERTIARY_EDU_LVL_COMP, which acts as the primary key. This column holds the unique code identifying a specific level of completion. While the full column list is not detailed in the provided metadata, such a reference table typically includes complementary columns such as a description field (e.g., DESCRIPTION), an active/inactive indicator, and who columns for creation and last update details. The existence of a foreign key relationship to the IGS_AD_TAC_LV_OF_COM table suggests this table may also store a corresponding code (TAC_LEVEL_OF_COMP) used for integration or alignment with other parts of the admissions system.

Common Use Cases and Queries

This table is primarily referenced during the applicant data entry and qualification review processes. When an admissions officer records an applicant's prior tertiary education, they select a completion level from the values defined in this table. Common reporting use cases include generating lists of applicants who have fully completed a prior degree or analyzing the completion statuses of incoming students' previous studies. A typical query would join this table to the main tertiary education history table to retrieve a meaningful description.

SELECT te.institution,
       telc.tertiary_edu_lvl_comp,
       telc.description
FROM   igs_ad_ter_edu te,
       igs_ad_ter_ed_lv_com telc
WHERE  te.tertiary_edu_lvl_comp = telc.tertiary_edu_lvl_comp
AND    te.person_id = :applicant_id;

Related Objects

The table maintains defined relationships with other key tables in the Student System, as per the provided foreign key metadata:

• Primary Key: IGS_AD_TER_ED_LV_COM_PK on TERTIARY_EDU_LVL_COMP.
• Referenced by IGS_AD_TER_EDU: The IGS_AD_TER_EDU.TERTIARY_EDU_LVL_COMP column is a foreign key to this table. This is the primary relationship, linking an applicant's specific tertiary education record to its completion level.
• References IGS_AD_TAC_LV_OF_COM: The column IGS_AD_TER_ED_LV_COM.TAC_LEVEL_OF_COMP is a foreign key to the IGS_AD_TAC_LV_OF_COM table. This indicates a mapping or alignment between tertiary education completion levels and another, potentially broader, set of completion codes within the system.