Search Results igs_ad_ps_appl_inst_all

Overview

The IGS_AD_PS_APPL_INST_ALL table is a core data structure within the Oracle E-Business Suite Student System (IGS), specifically for the Admissions module. As indicated by its description, it holds the request for program entry for an admission period. This table functions as a child table to the main application header, storing detailed information for each specific program or course instance (nominated course) that an applicant has requested within a single admission application. It is a multi-org table, as denoted by the "_ALL" suffix, meaning it stores data for all operating units with partitioning based on the ORG_ID column. It is critical to note that the provided metadata explicitly states the Student System product is marked as "Obsolete" and that this specific table is "Not implemented in this database," indicating it may be part of a reference or demonstration installation rather than a live implementation in the queried environment.

Key Information Stored

The table's primary key is a composite of four columns, uniquely identifying each program request: PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, and SEQUENCE_NUMBER. This structure allows an applicant to apply for multiple programs and potentially have multiple instances (sequences) for the same program. Beyond the key columns, the table stores statuses that track the application's progress through the admissions lifecycle for that specific program. As evidenced by the extensive foreign key list, these include ADM_CNDTNL_OFFER_STATUS, ADM_DOC_STATUS, ADM_ENTRY_QUAL_STATUS, ADM_OFFER_RESP_STATUS, and ADM_OUTCOME_STATUS. It also holds calendar references (ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER) to define the intended admission period, attendance details (ATTENDANCE_MODE, ATTENDANCE_TYPE), and data for managing deferrals (DEFERRED_ADM_CAL_TYPE, DEFERRED_ADM_CI_SEQUENCE_NUM).

Common Use Cases and Queries

The primary use case is to query and report on the status and details of program-specific requests within the broader admissions pipeline. Common operational reports would list all applications for a particular nominated course and admission period, or track the distribution of offer response statuses. A typical query would join this table to its parent, IGS_AD_APPL_ALL, and to various code lookup tables to retrieve meaningful descriptions for statuses. For example, to generate a list of pending offers for a specific program, one might filter on ADM_OUTCOME_STATUS and ADM_OFFER_RESP_STATUS codes. Due to the table's obsolete status, development of new interfaces or extensions would not be standard practice. Any existing data extraction would primarily serve historical reporting or data migration purposes.

Related Objects

This table maintains integral relationships with numerous other entities in the Student System schema, primarily through foreign key constraints. Its immediate parent is the IGS_AD_APPL_ALL table, which holds the overall application header. It is also a direct child of IGS_AD_PS_APPL_ALL, which likely contains program-application-level data. A significant number of foreign keys reference status code tables such as IGS_AD_OU_STAT (outcome status) and IGS_AD_OFR_RESP_STAT (offer response status). Critical relationships exist with the calendar entity IGS_CA_INST_ALL for admission, deferred admission, and future academic periods. Other related tables include IGS_EN_ATD_MODE_ALL (attendance mode), IGS_EN_ATD_TYPE_ALL (attendance type), and IGS_CO_CAT (correspondence category).