Search Results igs_ad_appl_all




Overview
Explore in AI Chat

Overview

The IGS_AD_APPL_ALL table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS), specifically in releases 12.1.1 and 12.2.2. It serves as the master table for storing admission application records, describing the admission of an applicant to an institution. As a multi-organization enabled table (indicated by the "_ALL" suffix), it contains data for all operating units, making it the primary transactional source for application data. Its central role is to track the lifecycle of an applicant's admission request, linking key entities such as the person, the academic calendar, the admission process, and the application's financial and status attributes.

Key Information Stored

The table's structure is defined by its primary and unique keys, which are critical for data integrity and application logic. The primary key (IGS_AD_APPL_PK) is a composite of PERSON_ID and ADMISSION_APPL_NUMBER, uniquely identifying each application for a specific individual. A separate unique key (IGS_AD_APPL_UK) is defined on the APPLICATION_ID column. Key data points stored include identifiers for the admission calendar (ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER) and academic calendar (ACAD_CAL_TYPE, ACAD_CI_SEQUENCE_NUMBER), the admission category and process type (ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE), and the current statuses of the application and its associated fees (ADM_APPL_STATUS, ADM_FEE_STATUS). The APPLICATION_TYPE column categorizes the nature of the admission request.

Common Use Cases and Queries

This table is fundamental for admission-related reporting, process automation, and data integrations. Common operational scenarios include generating application status reports, tracking application volumes by admission cycle or category, and interfacing application data to external systems. A typical query to retrieve active applications for a specific admission cycle would join to person and status tables:

Another frequent use case involves data validation and cleanup scripts that verify foreign key relationships, particularly with the linked calendar instances and process categories.

Related Objects

The IGS_AD_APPL_ALL table has extensive relationships, acting as a hub for numerous child tables and referencing several key lookup and setup tables. Based on the provided foreign key metadata, primary relationships include: