Search Results tac_level_of_qual

Overview

The IGS_AD_TAC_LVL_OF_QF table is a reference data table within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary function is to define and store the distinct levels of educational completion or qualification that are formally recognized by a Tertiary Admissions Centre (TAC). A TAC is an external body responsible for processing applications for admission to tertiary education institutions in certain regions. This table serves as a master list, ensuring data integrity and consistency when recording an applicant's prior educational attainment in the context of TAC-related admissions processing. It is critical to note that the IGS product line, including this table, is marked as obsolete in the provided ETRM documentation for versions 12.1.1 and 12.2.2. Furthermore, the metadata explicitly states it was "Not implemented in this database," indicating it may exist in the data model but was not deployed in standard installations.

Key Information Stored

Based on the provided metadata, the table's structure centers on a single primary key column that defines the qualification level. The most critical data element is the TAC_LEVEL_OF_QUAL column, which constitutes the table's primary key (IGS_AD_TAC_LVL_OF_QF_PK). This column stores the unique code identifying a specific level of qualification recognized by the TAC, such as codes for a High School Diploma, Associate Degree, Bachelor's Degree, or other completion standards. While other descriptive columns (e.g., a description field) are typical in such reference tables, the excerpt does not detail them, emphasizing the core identifier is the TAC_LEVEL_OF_QUAL code.

Common Use Cases and Queries

The primary use case for this table is to validate and constrain data entry in related admissions transaction tables. When recording an applicant's tertiary education level for TAC processing, the system would reference this table to ensure only valid, recognized codes are used. A common reporting use case would be to analyze applicant pools by their prior qualification levels as defined by the TAC. A typical query would involve joining this table to related transaction data to translate codes into meaningful descriptions for reports.

Sample SQL Pattern:
SELECT tloq.TAC_LEVEL_OF_QUAL, tloq.DESCRIPTION, COUNT(a.applicant_id)
FROM IGS_AD_TAC_LVL_OF_QF tloq
JOIN IGS_AD_TER_ED_LVL_QF telq ON tloq.TAC_LEVEL_OF_QUAL = telq.TAC_LEVEL_OF_QUAL
JOIN IGS_AD_APPLICANT a ON telq.applicant_id = a.applicant_id -- Example join path
WHERE a.admission_term = 'FALL-2023'
GROUP BY tloq.TAC_LEVEL_OF_QUAL, tloq.DESCRIPTION;
Note: The exact join path to applicant data may vary; the above illustrates the conceptual link.

Related Objects

The table maintains a key relationship as a parent table in the data model, as documented by the foreign key constraint. The related object is:

• Table: IGS_AD_TER_ED_LVL_QF (Tertiary Education Level of Qualification)
  Foreign Key Column: IGS_AD_TER_ED_LVL_QF.TAC_LEVEL_OF_QUAL
  References: IGS_AD_TAC_LVL_OF_QF.TAC_LEVEL_OF_QUAL
  This relationship enforces that any tertiary education level qualification recorded for an applicant in the IGS_AD_TER_ED_LVL_QF table must correspond to a valid, pre-defined level in the IGS_AD_TAC_LVL_OF_QF master table.