Search Results ss_acadin_id

Overview

The IGS_SS_AD_ACADIN_STG table is a staging table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the IGS (iGrants) schema. Its primary function is to temporarily hold data related to academic interests declared by applicants during a Self Service Admission Application process. As a staging table, it serves as an intermediary data store, typically used for data validation, transformation, or batch processing before information is moved to permanent transactional tables. Its role is integral to the flow of admissions data, ensuring that applicant preferences for fields of study are captured and managed efficiently within the broader Student Systems architecture.

Key Information Stored

The table stores a concise set of columns focused on linking an applicant to their academic interests. The SS_ACADIN_ID column is the primary key, providing a unique identifier for each academic interest record. The SS_ADM_APPL_ID is a foreign key that links the interest to a specific Self Service Admission Application record. The FIELD_OF_STUDY column stores the code representing the applicant's chosen academic discipline. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing purposes. The mandatory nature of SS_ACADIN_ID and SS_ADM_APPL_ID underscores the criticality of these identifiers for data integrity.

Common Use Cases and Queries

A primary use case involves extracting or reporting on the academic interests submitted for a batch of applications, often as part of an admissions workflow or data interface. Support and development teams may query this table to troubleshoot data issues within the self-service application flow. Common SQL patterns include selecting interests for a specific application or joining to parent tables for more comprehensive reporting. A typical query to retrieve all academic interests would be:

SELECT ssaai.ss_acadin_id, ssaai.ss_adm_appl_id, ssaai.field_of_study, ssaas.person_id FROM igs.igs_ss_ad_acadin_stg ssaai JOIN igs.igs_ss_adm_appl_stg ssaas ON ssaai.ss_adm_appl_id = ssaas.ss_adm_appl_id;

This table is also a target for data loading programs (e.g., via SQL*Loader or custom PL/SQL APIs) that populate staging data from external sources or user interfaces.

Related Objects

The IGS_SS_AD_ACADIN_STG table has defined relationships with other key staging and setup tables, forming a part of the admissions data model. The documented foreign key relationships are:

• IGS_SS_ADM_APPL_STG: The SS_ADM_APPL_ID column references this table, establishing that every academic interest must be associated with a valid Self Service Admission Application record.
• IGS_PS_FLD_OF_STUDY_ALL: The FIELD_OF_STUDY column references this table, ensuring that the entered academic interest code corresponds to a valid, predefined field of study within the system.

The table's primary key, IGS_SS_AD_ACADIN_STG_PK (on SS_ACADIN_ID), ensures uniqueness. The table is referenced by objects within the APPS schema, indicating its data is accessed through synonym-based application code.