Search Results igs_ad_tac_ad_cd_pk

Overview

The IGS_AD_TAC_AD_CD table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It functions as a reference table that defines and stores the specific admission codes recognized by a Tertiary Admissions Centre (TAC). A TAC is a central organization that processes applications on behalf of multiple educational institutions in certain regions. This table provides the standardized code set that links an institution's internal admission processes with the external codes mandated by the relevant admissions authority. Its role is to ensure data integrity and consistency when exchanging application information between the institution's Oracle Student System and external TAC systems, forming a critical part of the admissions management workflow in releases 12.1.1 and 12.2.2.

Key Information Stored

The primary data element stored in this table is the TAC admission code itself. Based on standard Oracle EBS design patterns and the provided metadata, the table's structure is centered around a unique code column that serves as the primary key. While the full column list is not detailed in the excerpt, the existence of a primary key constraint (IGS_AD_TAC_AD_CD_PK) on the column TAC_ADMISSION_CD confirms this as the central identifier. This table typically contains descriptive attributes for each code, such as an active date, inactive date, and a description field to clarify the code's meaning. The table acts as a validated list of permissible values for TAC-related admissions data.

Common Use Cases and Queries

The primary use case is the validation and translation of admission codes during the application intake and processing stages. When an application is received from or submitted to a TAC, the system references this table to ensure the associated admission code is valid. It is also crucial for generating standardized reports for TAC compliance. Common queries involve listing all active codes for a specific admissions cycle or joining with application data. A typical reporting query would be:

• SELECT tac_admission_cd, description FROM igs.igs_ad_tac_ad_cd WHERE sysdate BETWEEN start_date AND NVL(end_date, sysdate) ORDER BY 1;

Another frequent operation is a lookup to validate an incoming application record: checking if the provided :p_tac_admission_cd exists in the IGS_AD_TAC_AD_CD table before proceeding with further processing.

Related Objects

The table maintains a direct foreign key relationship with a core admissions table, as documented in the provided metadata. The IGS_AD_CD table references IGS_AD_TAC_AD_CD via its TAC_ADMISSION_CD column. This relationship signifies that admission codes (IGS_AD_CD) within the Student System can be associated with an official TAC admission code defined in this reference table. The foreign key ensures that any TAC admission code used in the IGS_AD_CD table must first be defined as a valid code in the IGS_AD_TAC_AD_CD table, enforcing referential integrity across the admissions data model.