Search Results igs_ad_ps_aplinstunt_all




Overview
Explore in AI Chat

Overview

The table IGS_AD_PS_APLINSTUNT_ALL is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically for the admissions process. It stores detailed information about individual unit applications submitted as part of a larger admission application. This includes applications for units within a nominated program of study or for non-award units. The table functions as a child entity, linking an applicant's broader admission application instance to the specific academic units for which they are applying. Its design supports the complex, multi-step nature of admissions in higher education, tracking each unit request's status, location, and academic parameters.

Key Information Stored

The table's primary key is the surrogate key ADM_PS_APPL_INST_UNIT_ID. A unique key enforces business rule integrity by combining identifiers for the applicant (PERSON_ID, ADMISSION_APPL_NUMBER), the nominated course (NOMINATED_COURSE_CD, ACAI_SEQUENCE_NUMBER), and the specific unit details (UNIT_CD, UV_VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, UNIT_CLASS). Critical columns include ADM_UNIT_OUTCOME_STATUS, which links to a lookup of possible unit application outcomes, and UNIT_MODE, defining the study mode. The table also captures supervisory unit relationships (SUP_UNIT_CD, SUP_UV_VERSION_NUMBER), assessment tracking (ASS_TRACKING_ID), and data on any waived prerequisites (RULE_WAIVED_PERSON_ID).

Common Use Cases and Queries

This table is central to generating reports on unit-level demand during an admissions cycle, analyzing applicant preferences for specific units, locations, and study modes. A common operational use case is processing unit application outcomes, such as offers or rejections. Administrators may query this table to list all unit applications for a specific admission application or to identify applications for a particular unit version. A typical reporting query would join to the parent application instance and unit details:

  • SELECT iapi.person_id, iapi.admission_appl_number, iau.unit_cd, iau.unit_class, iau.adm_unit_outcome_status FROM igs_ad_ps_aplinstunt_all iau JOIN igs_ad_ps_appl_inst_all iapi ON iau.person_id = iapi.person_id AND iau.admission_appl_number = iapi.admission_appl_number WHERE iau.nominated_course_cd = :p_course_code;

Related Objects

The table maintains extensive foreign key relationships, primarily as a child table. Its core parent is IGS_AD_PS_APPL_INST_ALL, linking via PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, and ACAI_SEQUENCE_NUMBER. It references master data and configuration tables for validation: IGS_AD_UNIT_OU_STAT (for ADM_UNIT_OUTCOME_STATUS), IGS_PS_UNIT_OFR_OPT_ALL and IGS_PS_UNIT_OFR_PAT_ALL (for UNIT_CD, UV_VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, UNIT_CLASS), IGS_AS_UNIT_CLASS_ALL (for UNIT_CLASS), IGS_AS_UNIT_MODE (for UNIT_MODE), and IGS_AD_LOCATION_ALL (for LOCATION_CD). It also links to IGS_PS_UNIT_VER_ALL for supervisory units, IGS_TR_ITEM_ALL for assessment tracking, and HZ_PARTIES for the person who waived a prerequisite rule.