Search Results igs_ss_app_pgm_stg




Overview
Explore in AI Chat

Overview

The IGS_SS_APP_PGM_STG table is a core staging entity within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. As a staging table, its primary role is to serve as a temporary data repository during the processing of student admission applications. It holds detailed information for individual program instances associated with an application, acting as a child record to the main application staging header (IGS_SS_ADM_APPL_STG). This structure facilitates the validation, transformation, and eventual migration of application data into the core transactional tables of the Student System, ensuring data integrity and supporting complex admission workflows.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships, which indicate the critical data points it captures for each application program instance. The primary key, SS_ADMAPPL_PGM_ID, uniquely identifies each staged program record. Essential foreign key columns define the context of the application: SS_ADM_APPL_ID links to the parent application, PERSON_ID references the applicant party in HZ_PARTIES, and NOMINATED_COURSE_CD with CRV_VERSION_NUMBER specify the proposed program of study from IGS_PS_VER_ALL. Additional key columns store the applicant's preferences and institutional decisions, such as LOCATION_CD (campus), ATTENDANCE_MODE, ATTENDANCE_TYPE, SCH_APL_TO_ID (application term), and FINAL_UNIT_SET_CD (major or specialization). The EDU_GOAL_PRIOR_ENROLL column captures coded educational goals.

Common Use Cases and Queries

This table is central to admission batch processing and reporting on in-progress applications. Common operational use cases include validating the completeness of application program data before submission, generating lists of applicants for a specific course or location, and tracking application statuses during an intake cycle. For reporting, analysts frequently join this table to its parent and related code tables to analyze applicant demographics and preferences. A typical query pattern involves selecting application program details for a specific admission cycle or course:

  • SELECT app_pgm.*, appl.application_number, crs.course_cd, loc.location_name FROM igs_ss_app_pgm_stg app_pgm JOIN igs_ss_adm_appl_stg appl ON app_pgm.ss_adm_appl_id = appl.ss_adm_appl_id JOIN igs_ps_ver_all crs ON app_pgm.nominated_course_cd = crs.course_cd AND app_pgm.crv_version_number = crs.version_number JOIN igs_ad_location_all loc ON app_pgm.location_cd = loc.location_cd WHERE appl.admission_cat = '<CATEGORY>' AND appl.adm_cal_type = '<CALENDAR>';

Data from this staging table is ultimately processed by Student System concurrent programs to create or update official application records in the transactional schema.

Related Objects

The IGS_SS_APP_PGM_STG table has extensive relationships within the Student System, as documented by its foreign keys. It is a central hub in the admission staging data model. Key dependencies include:

These relationships enforce business rules and ensure that staged application data aligns with the institution's configured academic structure, making the table integral to a valid and consistent admission process.