Search Results ss_admappl_pgm_id




Overview
Explore in AI Chat

Overview

The IGS_SS_ADMAPPL_PGM table is a core data object within the Oracle E-Business Suite (EBS) Student Systems (SS) module, specifically for versions 12.1.1 and 12.2.2. It functions as the primary repository for detailed program-level information associated with online admission applications. When a prospective student submits an application, this table stores the specific academic programs, preferences, and supplementary details for each application. Its role is critical in managing the applicant's chosen course of study, tracking preferences, and capturing application-specific declarations such as financial aid intent and personal statements, thereby forming a foundational part of the admissions workflow.

Key Information Stored

The table's columns capture a comprehensive set of data points for each program preference on an application. The primary key, SS_ADMAPPL_PGM_ID, uniquely identifies each program preference record. Key relational columns include SS_ADM_APPL_ID, which links to the parent admission application, and NOMINATED_COURSE_CD with CRV_VERSION_NUMBER, which define the specific program and its version the applicant is seeking. The PREFERENCE_NUMBER indicates the applicant's ranking for this program among their choices. Supplementary data includes financial aid indicators (APPLY_FOR_FINAID, FINAID_APPLY_DATE), unit sets for academic concentrations (UNIT_SET_1, UNIT_SET_2), and personal statement text (PS_NOTE_TEXT). The table also provides a Descriptive Flexfield (DFF) structure through the ATTRIBUTE_CATEGORY and ATTRIBUTE1-9 columns, allowing for institution-specific customization.

Common Use Cases and Queries

This table is central to admissions reporting and process automation. Common use cases include generating lists of applicants for a specific program, analyzing applicant preferences, and processing financial aid flags. A typical query would join to the main application header table to retrieve applicant and program details. For example, to find all primary program choices for applications in a given term:

  • SELECT appl.APPLICANT_NUMBER, pgm.NOMINATED_COURSE_CD, pgm.PREFERENCE_NUMBER FROM IGS_SS_ADMAPPL_PGM pgm, IGS_SS_ADM_APPL appl WHERE pgm.SS_ADM_APPL_ID = appl.SS_ADM_APPL_ID AND pgm.PREFERENCE_NUMBER = 1 AND appl.ADMISSION_CAT = '&CATEGORY';

Another frequent reporting need is to identify applicants who have indicated an interest in financial aid for auditing or follow-up processes, utilizing the APPLY_FOR_FINAID and FINAID_APPLY_DATE columns.

Related Objects

The IGS_SS_ADMAPPL_PGM table has defined relationships with other key EBS Student Systems tables, primarily through foreign key constraints. The most significant relationship is with the main admission application header table, IGS_SS_ADM_APPL, via the SS_ADM_APPL_ID column. The primary key column, SS_ADMAPPL_PGM_ID, is referenced by the unique index IGS_SS_ADMAPPL_PGM_PK. While the provided metadata does not list explicit foreign key dependencies, logical relationships exist with tables storing course (CRV) and unit set (IGS_EN_UNIT_SET) master data, linked through NOMINATED_COURSE_CD/CRV_VERSION_NUMBER and UNIT_SET_1/UNIT_SET_2 columns, respectively. It is also commonly joined with person (PER_ALL_PEOPLE_F) and applicant tables in comprehensive reports.