Search Results igs_ad_cd




Overview
Explore in AI Chat

Overview

The IGS_AD_CD table is a core data structure within the Oracle E-Business Suite Student System (IGS). It serves as the master repository for user-defined admission codes. These codes are critical for defining the specific matriculation qualifications required for admission to academic programs. The table functions as a reference entity, enabling the consistent classification and tracking of the various admission criteria and qualifications that applicants must meet. Its role is foundational to the admissions process, as these codes are linked directly to program applications, admission basis types, and tertiary admission center data, ensuring standardized data entry and processing across the student lifecycle.

Key Information Stored

The table's primary purpose is to store the definition and attributes of each unique admission code. While the full column list is not detailed in the provided metadata, the structure is anchored by the ADMISSION_CD column, which serves as the unique identifier and primary key (IGS_AD_CD_PK). Other significant columns, as indicated by the foreign key relationships, include BASIS_FOR_ADMISSION_TYPE and TAC_ADMISSION_CD. These columns link the admission code to its corresponding admission basis type and to any related Tertiary Admission Centre (TAC) codes, respectively. The table likely contains additional descriptive columns, such as a name, description, effective dates, and status fields to manage the active lifecycle of each code.

Common Use Cases and Queries

This table is central to admissions-related setup, reporting, and validation. Common use cases include configuring the list of valid admission qualifications for a new academic program, generating reports on applicant demographics by admission type, and validating data entered on application forms. A typical query would involve joining IGS_AD_CD to application tables to analyze applicant pools.

  • Listing Active Admission Codes: SELECT admission_cd, description FROM igs.igs_ad_cd WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE) ORDER BY 1;
  • Finding Applications by Admission Code: SELECT a.application_number, cd.admission_cd, cd.description FROM igs.igs_ad_ps_appl_all a, igs.igs_ad_cd cd WHERE a.admission_cd = cd.admission_cd AND a.program_cd = 'BSC_COMP';

Related Objects

The IGS_AD_CD table has integral relationships with several other key tables in the Student System, as defined by its foreign key constraints. It is a parent table to the IGS_AD_PS_APPL_ALL table, which stores program application details, linking each application to a specific admission code. Furthermore, IGS_AD_CD references two other tables: IGS_AD_BASIS_FOR_AD (via BASIS_FOR_ADMISSION_TYPE) to define the basis for admission, and IGS_AD_TAC_AD_CD (via TAC_ADMISSION_CD) for integration with external tertiary admission centers. These relationships ensure data integrity and enforce business rules across the admissions module.