Search Results igs_ad_tac_lv_of_com_pk

Overview

The IGS_AD_TAC_LV_OF_COM table is a reference data table within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its core function is to define and store the distinct levels of educational completion that are formally recognized by a Tertiary Admissions Centre (TAC). A TAC is a central body responsible for processing applications for admission to tertiary education institutions in certain regions. This table serves as a master list of valid completion levels (e.g., High School Diploma, Associate Degree, Bachelor's Degree with Honours) against which individual applicant records can be validated. It is important to note that the IGS Student System is marked as obsolete in the provided ETRM documentation, indicating this table is part of a legacy codebase that may not be actively developed or implemented in all EBS 12.1.1 or 12.2.2 environments. The metadata explicitly states "Not implemented in this database," suggesting its presence is conditional on specific installation choices.

Key Information Stored

Based on the documented structure, the table's primary purpose is to maintain a unique list of completion codes. The central and likely only significant column is TAC_LEVEL_OF_COMP, which serves as the table's primary key. This column would typically store a short code or key that uniquely identifies a specific level of educational completion. While the ETRM excerpt does not list additional descriptive columns, it is common for such reference tables to include supporting fields such as a description (e.g., LEVEL_DESCRIPTION), an effective date range, and an active/inactive indicator. Any such columns would provide context and meaning to the primary key code.

Common Use Cases and Queries

The primary use case for this table is to ensure data integrity and provide descriptive information for applicant educational history. It acts as a constraint table for the IGS_AD_TER_ED_LV_COM table, which stores the specific level of completion achieved by an applicant for a particular tertiary education period. Common operations would involve querying the list of valid codes for validation during data entry or for use in application reports. A typical query would join this table to the related transactional table to translate codes into meaningful descriptions for reporting purposes.

Sample Query:
SELECT ed.tac_level_of_comp, lk.description
FROM igs_ad_ter_ed_lv_com ed,
igs_ad_tac_lv_of_com lk
WHERE ed.tac_level_of_comp = lk.tac_level_of_comp
AND ed.person_id = :applicant_id;

Related Objects

The documented relationship data shows a clear foreign key dependency from a transactional table. The related objects are:

• Primary Key: IGS_AD_TAC_LV_OF_COM_PK on column TAC_LEVEL_OF_COMP. This enforces uniqueness of the completion level codes.
• Foreign Key Relationship: The table IGS_AD_TER_ED_LV_COM references IGS_AD_TAC_LV_OF_COM. The column IGS_AD_TER_ED_LV_COM.TAC_LEVEL_OF_COMP must contain a value that exists in IGS_AD_TAC_LV_OF_COM.TAC_LEVEL_OF_COMP. This ensures that every level of completion recorded for an applicant's tertiary education is a valid, pre-defined type recognized by the TAC.