Search Results ss_acadin_id

Overview

The IGS_SS_AD_ACADIN_STG table is a staging data structure within the Oracle E-Business Suite (EBS) Student System (IGS). Its specific role is to temporarily hold data concerning academic interests submitted by prospective students as part of a self-service online admission application. As a staging table, it acts as an intermediary repository where application data is captured before being validated, processed, and potentially transferred to permanent transactional tables. It is critical to note that the IGS Student System module is marked as "Obsolete" in the provided ETRM documentation, indicating this object is part of a legacy codebase that may not be actively developed or implemented in newer installations. The metadata explicitly states it was "Not implemented in this database" for the documented instance.

Key Information Stored

The table's primary purpose is to store academic interest selections linked to a specific admission application. The most critical column is the primary key, SS_ACADIN_ID, which uniquely identifies each academic interest record within the staging environment. The table's structure is defined by its foreign key relationships. The SS_ADM_APPL_ID column links each academic interest entry to a specific admission application record in the IGS_SS_ADM_APPL_STG staging table. The FIELD_OF_STUDY column stores the code or identifier for the chosen academic program or field, referencing the master list of offerings in the IGS_PS_FLD_OF_STUDY_ALL table.

Common Use Cases and Queries

The primary use case involves processing incomplete online admission applications. Data from this table would typically be accessed by background concurrent programs or application logic responsible for validating and moving application data from the staging area to the live system. A common reporting query would involve joining this table to its parent staging table to review all academic interests for pending applications. For instance, a support query to find all staged interests for a specific application would utilize the foreign key relationship:

• SELECT * FROM igs_ss_ad_acadin_stg WHERE ss_adm_appl_id = <APPLICATION_ID>;

Another pattern involves validating the integrity of staged data by checking for orphaned records or invalid field of study codes before a batch processing job executes.

Related Objects

This table has defined relationships with two other EBS objects, as documented in the provided foreign key metadata:

• IGS_SS_ADM_APPL_STG: This is the parent staging table for the admission application header. The relationship is maintained via the IGS_SS_AD_ACADIN_STG.SS_ADM_APPL_ID column, which references a primary key in IGS_SS_ADM_APPL_STG. Every academic interest record must be associated with a valid application in this table.
• IGS_PS_FLD_OF_STUDY_ALL: This table is the master source for valid academic programs or fields of study. The relationship is through the IGS_SS_AD_ACADIN_STG.FIELD_OF_STUDY column, ensuring that the academic interest selected by the applicant corresponds to an active, defined program in the system.

The primary key constraint IGS_SS_AD_ACADIN_STG_PK on the SS_ACADIN_ID column enforces uniqueness for all records within this staging table.