Search Results tertiary_edu_lvl_comp

Overview

The IGS_AD_TER_ED_LV_COM table is a core reference data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (formerly Oracle Campus Solutions) module. It functions as a master lookup table that defines and stores institution-specific codes representing an applicant's level of completion in previous tertiary (post-secondary) education. This data is critical for the admissions process, as it standardizes how an applicant's prior educational attainment is categorized and assessed. The table also provides a mechanism to optionally map these internal codes to standardized codes used by external Tertiary Admission Centers (TAC), facilitating data exchange and reporting for centralized admissions bodies.

Key Information Stored

The table's structure is designed to manage code definitions and their lifecycle. The primary and most significant column is TERTIARY_EDU_LVL_COMP (VARCHAR2(10)), which is the unique, institution-defined identifier for a completion level. Its corresponding DESCRIPTION (VARCHAR2(60)) provides the explanatory text. The TAC_LEVEL_OF_COMP (VARCHAR2(10)) column holds the optional mapping to an external admission center's equivalent code. The CLOSED_IND (VARCHAR2(1)) flag controls the code's active status, preventing its use in new records when set, which is a standard practice for maintaining historical data integrity. The table also includes the standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

This table is primarily used in two contexts: setup and transactional reporting. During application configuration, administrators populate this table with valid completion levels (e.g., 'ASSOC', 'BACH', 'DIPL'). In daily operations, the codes are referenced when entering or processing an applicant's prior education history. A common reporting requirement is to list all active codes with their external mappings for validation. The foundational query, as indicated in the ETRM, is:

SELECT tertiary_edu_lvl_comp,
description,
tac_level_of_comp,
closed_ind
FROM igs.igs_ad_ter_ed_lv_com
WHERE NVL(closed_ind, 'N') = 'N'
ORDER BY tertiary_edu_lvl_comp;

Another frequent use case involves joining this table to applicant education records to generate reports that translate internal codes into human-readable descriptions or external TAC codes for submission.

Related Objects

The IGS_AD_TER_ED_LV_COM table sits at the center of specific data relationships, as confirmed by the provided dependency information. It is referenced by key transactional tables and itself references another lookup table.

• Primary Key Reference: The table's primary key (IGS_AD_TER_ED_LV_COM_PK) is on TERTIARY_EDU_LVL_COMP. This unique key is referenced by the foreign key in the IGS_AD_TER_EDU table (column: TERTIARY_EDU_LVL_COMP). This is a critical relationship, as it validates the completion level code used in an applicant's recorded tertiary education history.
• Foreign Key Reference: The table contains a foreign key where its TAC_LEVEL_OF_COMP column references the IGS_AD_TAC_LV_OF_COM table. This enforces referential integrity, ensuring that any mapped TAC code exists in the dedicated TAC level of completion master table.