Search Results tac_level_of_comp

Overview

The IGS_AD_TAC_LV_OF_COM table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (iGrants) module. It functions as a master list for Tertiary Admission Center (TAC) codes that define the level of completion of an applicant's prior studies. This data is critical for admissions processing, as it standardizes how an applicant's existing qualifications are categorized and evaluated against program entry requirements. The table maintains a controlled set of valid codes (e.g., 'COMPLETE', 'PARTIAL') recognized by external admission authorities, ensuring data integrity and consistency across the student lifecycle.

Key Information Stored

The table's structure is designed to manage a simple yet essential code lookup. The primary column, TAC_LEVEL_OF_COMP (VARCHAR2(10)), stores the unique code itself. The DESCRIPTION column (VARCHAR2(60)) provides the explanatory text for the code. A critical control column is CLOSED_IND (VARCHAR2(1)), which acts as an active/inactive flag; when set, it prevents the code from being assigned to new records, supporting historical data preservation without deletion. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditability. The unique index IGS_AD_TAC_LV_OF_COM_U1 enforces the uniqueness of the TAC_LEVEL_OF_COMP code.

Common Use Cases and Queries

The primary use case is to validate and provide descriptive context for an applicant's tertiary education completion level during application entry and assessment. It is frequently referenced in forms, reports, and interfaces where qualification data is displayed or processed. A common reporting requirement is to list all active TAC levels of completion. The foundational query for accessing this data, as indicated in the ETRM, is:

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

For data maintenance or integration tasks, administrators may query the full record, including audit columns. This table is typically populated and maintained via administrative screens within the IGS module, not via direct SQL manipulation, to preserve referential integrity.

Related Objects

The IGS_AD_TAC_LV_OF_COM table serves as a parent reference table within the data model. Its primary key (TAC_LEVEL_OF_COMP) is referenced by at least one other table, establishing a clear foreign key relationship:

• IGS_AD_TER_ED_LV_COM.TAC_LEVEL_OF_COMP references IGS_AD_TAC_LV_OF_COM.TAC_LEVEL_OF_COMP. This relationship indicates that the IGS_AD_TER_ED_LV_COM table (which likely stores tertiary education level of completion details for specific applicants or qualifications) uses the codes defined in IGS_AD_TAC_LV_OF_COM as a valid value set. A typical join for reporting would be:
  SELECT a.*, t.description FROM igs.igs_ad_ter_ed_lv_com a, igs.igs_ad_tac_lv_of_com t WHERE a.tac_level_of_comp = t.tac_level_of_comp;