Search Results igs_ad_appl_all

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:

• SELECT appl.PERSON_ID, appl.ADMISSION_APPL_NUMBER, party.PARTY_NAME, stat.SYSTEM_DEFAULT_IND FROM IGS_AD_APPL_ALL appl JOIN HZ_PARTIES party ON appl.PERSON_ID = party.PARTY_ID JOIN IGS_AD_APPL_STAT stat ON appl.ADM_APPL_STATUS = stat.ADM_APPL_STATUS WHERE appl.ADM_CAL_TYPE = '&ADM_CAL_TYPE' AND appl.ADM_CI_SEQUENCE_NUMBER = &CI_SEQ_NUM;

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:

• Parent/Lookup Tables: IGS_AD_APPL_STAT (status), IGS_AD_FEE_STAT (fee status), IGS_AD_PRD_AD_PRC_CA and IGS_AD_PRCS_CAT_ALL (admission process), IGS_CA_INST_REL (calendar), HZ_PARTIES (person), IGS_AD_SS_APPL_TYP (application type).
• Key Child Tables (joined on PERSON_ID, ADMISSION_APPL_NUMBER): IGS_AD_APPL_LTR (letters), IGS_AD_APPL_PERSTAT (personal status), IGS_AD_PS_APPL_ALL (program of study), IGS_AD_PS_APPL_INST_ALL (institution), IGS_AD_ACAD_INTEREST (academic interest), IGS_AD_APP_REQ (requirements), IGS_AD_SPL_INTERESTS (special interests), IGS_AD_SPL_TALENTS (special talents).
• Referencing Object: IGS_AD_APP_INTENT (application intent) also references this table's primary key columns.