Search Results ss_edugoa_id

Overview

The IGS_SS_AD_EDUGOA_STG table is a staging table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (iGrad Student) product family. Its primary function is to temporarily hold data related to an applicant's stated education goals for the period after enrollment. This data is captured as part of a self-service admission application program instance. 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 existence supports the modular and efficient handling of admission application data within the self-service workflow.

Key Information Stored

The table stores a focused set of columns to track applicant post-enrollment goals and audit information. The most critical column is SS_EDUGOA_ID, a mandatory unique identifier (primary key) for each record in this staging table. The SS_ADMAPPL_PGM_ID column provides the foreign key link to the specific self-service admission application program instance (IGS_SS_APP_PGM_STG). The EDU_GOAL_ID is a foreign key that stores the identifier for the actual education goal, likely referencing a code lookup table (IGS_AD_CODE_CLASSES). Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are included for full audit trail compliance, recording the user and timestamp for record creation and modification.

Common Use Cases and Queries

This table is central to processes involving the batch loading or synchronization of applicant goal data. A common use case is extracting and validating education goal information from external systems or flat files before it is formally processed into the core application tables. For reporting on staged applicant data, a typical query would join this table to its parent tables to retrieve descriptive information. For example:

SELECT stg.SS_EDUGOA_ID,
       stg.SS_ADMAPPL_PGM_ID,
       goal.MEANING AS EDUCATION_GOAL,
       stg.CREATION_DATE
FROM IGS.IGS_SS_AD_EDUGOA_STG stg,
     IGS.IGS_AD_CODE_CLASSES goal
WHERE stg.EDU_GOAL_ID = goal.CODE_CLASS_ID
  AND stg.CREATION_DATE > TRUNC(SYSDATE-1);

This query is useful for generating daily audit logs of newly staged education goal records or for troubleshooting data integration jobs.

Related Objects

The IGS_SS_AD_EDUGOA_STG table has defined relationships with other key staging and reference tables in the IGS schema:

• Primary Key: IGS_SS_AD_EDUGOA_STG_PK on column SS_EDUGOA_ID.
• Foreign Key (Parent): The SS_ADMAPPL_PGM_ID column references the IGS_SS_APP_PGM_STG table, linking the education goal to a specific application program instance.
• Foreign Key (Parent): The EDU_GOAL_ID column references the IGS_AD_CODE_CLASSES table, which stores the valid list of education goal codes and their descriptions.
• Referenced By: The APPS schema holds a synonym (IGS_SS_AD_EDUGOA_STG) for this table, indicating it is accessed by the application tier, typically via public synonyms and grants.