Search Results final_unit_set_cd

Overview

The IGS_SS_APP_PGM_STG table is a staging table within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 Student Systems (SS) module. Its primary role is to temporarily hold data for individual program instances associated with a Self Service admission application during the application processing lifecycle. As a staging table, it facilitates data validation and transformation before information is migrated to permanent transactional tables. It acts as a central hub within the admission application staging area, linking an applicant's program choices to their core application, personal details, and specific academic preferences.

Key Information Stored

The table stores detailed preferences for a specific program within an admission application. Key columns include the unique identifiers SS_ADMAPPL_PGM_ID (primary key) and SS_ADM_APPL_ID (linking to the main application). Program selection is defined by NOMINATED_COURSE_CD and CRV_VERSION_NUMBER, while PREFERENCE_NUMBER indicates the applicant's ranking for this program. The table also captures intended study details like ATTENDANCE_MODE and ATTENDANCE_TYPE. Notably, several columns for majors (UNIT_SET_1, UNIT_SET_2) are documented as obsolete. A critical column for the user's search is FINAL_UNIT_SET_CD, which, based on the provided foreign key relationship, stores the code for a final unit set and references the IGS_EN_UNIT_SET_ALL table. The table also includes a set of descriptive flexfield columns (ATTRIBUTE_CATEGORY, ATTRIBUTE1-5) for institution-specific extensions.

Common Use Cases and Queries

This table is central to reporting and validating applicant program choices before final submission. Common use cases include generating summary reports of all program preferences for a given application cycle, identifying applications for specific programs, and validating data integrity during the staging process. A sample query to retrieve an applicant's final unit set information, as implied by the user's search, would join through the relevant foreign keys:

• SELECT appgm.SS_ADM_APPL_ID, appgm.NOMINATED_COURSE_CD, appgm.FINAL_UNIT_SET_CD, us.UNIT_SET_NAME FROM IGS.IGS_SS_APP_PGM_STG appgm JOIN IGS.IGS_EN_UNIT_SET_ALL us ON appgm.FINAL_UNIT_SET_CD = us.UNIT_SET_CD WHERE appgm.SS_ADM_APPL_ID = :APPLICATION_ID;
• Another typical query would list all program preferences for an applicant, ordered by preference: SELECT PREFERENCE_NUMBER, NOMINATED_COURSE_CD FROM IGS.IGS_SS_APP_PGM_STG WHERE SS_ADM_APPL_ID = :APPLICATION_ID ORDER BY PREFERENCE_NUMBER;

Related Objects

The IGS_SS_APP_PGM_STG table has extensive relationships within the Student Systems schema, as documented by its foreign key constraints. It is a child of the main application staging table (IGS_SS_ADM_APPL_STG) and references master data for persons (HZ_PARTIES), programs (IGS_PS_VER_ALL), schools (IGS_AD_SCHL_APLY_TO), locations (IGS_AD_LOCATION_ALL), attendance types and modes (IGS_EN_ATD_TYPE_ALL, IGS_EN_ATD_MODE_ALL), code classes (IGS_AD_CODE_CLASSES), and unit sets (IGS_EN_UNIT_SET_ALL via FINAL_UNIT_SET_CD). Conversely, it is a parent table to two other staging entities: IGS_SS_AD_EDUGOA_STG (for educational goals) and IGS_SS_AD_UNITSE_STG (for unit set details), which reference its primary key (SS_ADMAPPL_PGM_ID).