Search Results igs_ad_ps_appl_all




Overview
Explore in AI Chat

Overview

The table IGS_AD_PS_APPL_ALL is a core data structure within the Oracle E-Business Suite's now-obsolete Student System (IGS). It serves as a junction table that links a student's primary admission application to their nominated program of study. Its primary role is to store and manage the relationship between an applicant (via the admission application) and the specific academic course or program for which they are applying. This table is critical for tracking the academic intent of an applicant throughout the admissions lifecycle. The metadata explicitly notes this table is "Not implemented in this database," indicating it may not be present in all deployments or its data may be migrated to successor objects in later versions.

Key Information Stored

The table's structure is defined by its composite primary key and its foreign key relationships. The primary key uniquely identifies a program application record through a combination of the applicant's PERSON_ID, their ADMISSION_APPL_NUMBER, and the NOMINATED_COURSE_CD. This design allows a single admission application to target multiple programs. Key foreign key columns include BASIS_FOR_ADMISSION_TYPE, which classifies the admission basis (e.g., freshman, transfer), and ADMISSION_CD, which references a specific admission category or term. The TRANSFER_COURSE_CD column is significant for applicants seeking advanced standing, linking to a potential course record for credit transfer evaluation.

Common Use Cases and Queries

This table is central to queries that analyze applicant pools by program, track application status for specific courses, or report on admission basis types. A common reporting use case would involve joining to the person, application header, and course tables to generate a list of all applicants for a given academic program. For instance, a query to find all transfer applicants for a specific course would filter on the BASIS_FOR_ADMISSION_TYPE and NOMINATED_COURSE_CD. Another critical operational use case is validating data integrity when an applicant changes their nominated program, ensuring the relationship between the application header and the program-specific details is correctly maintained.

Related Objects

IGS_AD_PS_APPL_ALL sits at the center of a key data model, with documented relationships to several core tables:

  • IGS_AD_APPL_ALL: The parent admission application header. Joined via PERSON_ID and ADMISSION_APPL_NUMBER.
  • IGS_PS_COURSE: The nominated academic program. Joined via NOMINATED_COURSE_CD.
  • IGS_AD_CD: The admission category or term. Joined via ADMISSION_CD.
  • IGS_AD_BASIS_FOR_AD: The basis for admission type. Joined via BASIS_FOR_ADMISSION_TYPE.
  • IGS_EN_STDNT_PS_ATT_ALL: The student program attempt, linked via PERSON_ID and TRANSFER_COURSE_CD for transfer credit scenarios.
  • IGS_AD_PS_APPL_INST_ALL: A child table storing institution-specific details for the program application. Joined via the full primary key (PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD).