Search Results tac_admission_cd




Overview
Explore in AI Chat

Overview

The IGS.IGS_AD_TAC_AD_CD table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or related education modules. It serves as the master repository for Tertiary Admission Center (TAC) admission codes, also known as matriculation categories. These standardized codes are used to classify applicants based on their current qualifications as recognized by external tertiary admission authorities. The table's primary role is to provide a validated list of codes that can be assigned to applicant records, ensuring data consistency and alignment with external reporting requirements.

Key Information Stored

The table stores the definition and administrative status of each TAC admission code. The critical columns are:

  • TAC_ADMISSION_CD (VARCHAR2(10), Primary Key): The unique identifier for the matriculation category.
  • DESCRIPTION (VARCHAR2(60)): A clear explanation of the code's meaning and the qualification basis it represents.
  • CLOSED_IND (VARCHAR2(1)): A flag indicating whether the code is active ('N') or closed ('Y'). A closed code cannot be used in new or modified admission code records, enforcing data integrity over time.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each row.

Common Use Cases and Queries

This table is primarily used for setup, validation, and reporting. Administrators maintain the list of valid codes via this table. During applicant processing, the system validates assigned admission codes against this table. A common reporting need is to list all active codes for selection in interfaces or forms. The fundamental query to retrieve all codes is as provided in the ETRM:

SELECT TAC_ADMISSION_CD, DESCRIPTION, CLOSED_IND FROM IGS.IGS_AD_TAC_AD_CD WHERE NVL(CLOSED_IND,'N') = 'N' ORDER BY TAC_ADMISSION_CD;

Another frequent use case involves joining this table to applicant data to generate reports for TAC submission or internal audit, ensuring all applicant classifications map to a recognized, active admission code.

Related Objects

The IGS_AD_TAC_AD_CD table is a parent reference table within the data model. Its primary key is enforced by the index IGS_AD_TAC_AD_CD_U1. The most significant documented relationship is:

  • Foreign Key Reference from IGS_AD_CD: The column IGS_AD_CD.TAC_ADMISSION_CD references IGS_AD_TAC_AD_CD.TAC_ADMISSION_CD. This relationship means that admission codes (IGS_AD_CD) assigned to applicants or courses must be validated against the master list of TAC admission codes stored in this table. This enforces referential integrity and ensures that only authorized TAC codes are used in operational transactions.