Search Results ss_unitse_id

Overview

The IGS_SS_AD_UNITSE_STG table is a staging table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the IGS (iGrants) schema. Its primary function is to temporarily hold applicant-desired unit set details during the processing of a self-service admission application program instance. As a staging table, it serves as an intermediary data store, facilitating the validation, transformation, and eventual migration of unit set preference data into core transactional tables. This structure is typical in EBS for managing complex, multi-step application processes, ensuring data integrity before final commitment.

Key Information Stored

The table stores the preferences an applicant specifies for academic unit sets (like majors or specializations) as part of their admission application. The SS_UNITSE_ID column acts as the unique primary key for each record. The SS_ADMAPPL_PGM_ID is a foreign key linking the preference to a specific self-service admission application program instance. The academic preference itself is defined by the UNIT_SET_CD and its VERSION_NUMBER. A critical functional column is RANK, which allows the applicant to indicate the order of preference among multiple selected unit sets. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

The primary use case is supporting the online admission application workflow where applicants select and rank their desired academic programs. Data in this staging table is typically processed by concurrent programs or PL/SQL logic that validates the unit set codes and versions against the master catalog (IGS_EN_UNIT_SET_ALL) before formal assignment. Common reporting and validation queries include retrieving all preferences for a specific application or identifying applications with incomplete unit set selections. A fundamental sample query to extract this data is:

• SELECT SS_UNITSE_ID, SS_ADMAPPL_PGM_ID, UNIT_SET_CD, VERSION_NUMBER, RANK FROM IGS.IGS_SS_AD_UNITSE_STG WHERE SS_ADMAPPL_PGM_ID = :APPL_ID ORDER BY RANK;

This query is essential for displaying the applicant's ranked choices back to them or for internal processing.

Related Objects

The table has defined relationships with other key EBS objects, primarily through foreign key constraints. The SS_ADMAPPL_PGM_ID column references the IGS_SS_APP_PGM_STG table, which stores the overarching self-service application program instance details. This links the unit set preference to the correct application. Furthermore, the UNIT_SET_CD column references the IGS_EN_UNIT_SET_ALL table, which is the master list of all valid academic unit sets and their versions within the institution. This ensures referential integrity, guaranteeing that applicants can only select unit sets that are officially defined and active in the system.