Search Results tac_level_of_qual

Overview

The IGS_AD_TAC_LVL_OF_QF table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Oracle Student Management (OSM) product family under the IGS (iGrants) schema. It functions as a master list of standardized codes that define an applicant's level of academic qualification, as recognized by a Tertiary Admissions Centre (TAC). TACs are central bodies that process applications for higher education in certain regions. This table provides a controlled vocabulary, such as 'TB' for Bachelors Degree or 'TCM' for Masters Degree by Coursework, enabling consistent mapping and evaluation of applicant qualifications against institutional admission requirements across the student lifecycle.

Key Information Stored

The table is structured to store the code, its description, and its active status. The primary and most critical column is TAC_LEVEL_OF_QUAL, a mandatory VARCHAR2(10) field storing the unique TAC-recognized code. The DESCRIPTION column (VARCHAR2(60)) provides the full textual explanation of the code. The CLOSED_IND flag (VARCHAR2(1)) controls the code's lifecycle, preventing its use in new records when set, effectively making it inactive. Standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are present for auditing and compliance. The table is indexed on the TAC_LEVEL_OF_QUAL column to ensure fast, unique lookups.

Common Use Cases and Queries

This table is primarily used during the admissions process for applicant qualification assessment and reporting. A common operational use case is validating and displaying the description of a TAC level of qualification code attached to an applicant's record. For reporting, administrators often generate lists of active codes for setup or data validation purposes. A typical query to retrieve all active codes and their descriptions is:

• SELECT tac_level_of_qual, description FROM igs.igs_ad_tac_lvl_of_qf WHERE closed_ind = 'N' ORDER BY 1;

Another frequent pattern is a join to related applicant data, such as the IGS_AD_TER_ED_LVL_QF table, to report on the distribution of applicant qualification levels. The table is maintained via the application's user interface to ensure referential integrity and is not typically subject to direct data manipulation language (DML) operations outside of standard administration.

Related Objects

The IGS_AD_TAC_LVL_OF_QF table serves as a parent reference table within the admissions data model. Its primary key (IGS_AD_TAC_LVL_OF_QF_PK) on TAC_LEVEL_OF_QUAL is referenced by a foreign key constraint in the IGS_AD_TER_ED_LVL_QF table. This relationship indicates that the IGS_AD_TER_ED_LVL_QF.TAC_LEVEL_OF_QUAL column stores values that must exist in the IGS_AD_TAC_LVL_OF_QF table. This enforces data integrity, ensuring that any tertiary education level of qualification recorded for an applicant is mapped to a valid, predefined TAC standard. There are no other documented dependencies where this table references another object.