Search Results igs_ss_ad_unitse_stg_pk

Overview

The table IGS_SS_AD_UNITSE_STG is a core staging entity within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically supporting the self-service admissions functionality. It acts as a transient data repository designed to hold an applicant's desired unit set selections during the online application process for a specific admission program instance. This table facilitates the capture of academic intent before the data is formally validated and processed into the permanent student records, ensuring data integrity and managing the workflow of the admissions lifecycle from application submission to final enrollment.

Key Information Stored

The table's primary purpose is to link an applicant's self-service application program instance with their chosen academic unit sets. The key columns include the surrogate primary key, SS_UNITSE_ID, which uniquely identifies each desired unit set record. The foreign key SS_ADMAPPL_PGM_ID links the record to the specific application program instance in the IGS_SS_APP_PGM_STG table. The academic unit set itself is identified by the combination of UNIT_SET_CD and VERSION_NUMBER, which together reference a valid, versioned unit set definition in the master IGS_EN_UNIT_SET_ALL table. This structure allows an applicant to specify multiple desired unit sets for a single application program.

Common Use Cases and Queries

The primary use case is supporting the online admissions portal where applicants select their intended majors, minors, or other unit sets. Data in this staging table is typically processed by concurrent programs or APIs that validate the selections against admission rules and transfer approved records into the core enrollment tables. Common reporting and validation queries involve joining this table to its referenced master tables. For example, to list all unit set choices for a batch of applications:

• SELECT app.APPLICANT_NUMBER, us.UNIT_SET_CD, us.VERSION_NUMBER, us.TITLE FROM IGS_SS_AD_UNITSE_STG stg JOIN IGS_SS_APP_PGM_STG app ON stg.SS_ADMAPPL_PGM_ID = app.SS_ADMAPPL_PGM_ID JOIN IGS_EN_UNIT_SET_ALL us ON stg.UNIT_SET_CD = us.UNIT_SET_CD AND stg.VERSION_NUMBER = us.VERSION_NUMBER WHERE app.APPLICATION_STATUS = 'SUBMITTED';

Administrative data cleansing scripts may also query this table to identify orphaned staging records or selections that reference invalid or inactive unit sets.

Related Objects

IGS_SS_AD_UNITSE_STG is centrally connected to two critical tables via documented foreign key relationships. It is a child of the IGS_SS_APP_PGM_STG table, joined on the column SS_ADMAPPL_PGM_ID. This relationship ties every unit set choice to a specific applicant's program application instance. Furthermore, it references the master definition table IGS_EN_UNIT_SET_ALL via the composite key (UNIT_SET_CD, VERSION_NUMBER), ensuring that the applicant's selections align with valid and version-controlled academic structures within the institution. The table's primary key constraint is named IGS_SS_AD_UNITSE_STG_PK.