Results for “edu_goal_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_SS_AD_EDUGOA_STG is a staging table within the Oracle E-Business Suite Student System (IGS) module. Its documented purpose is to hold applicant education goals post-enrollment details associated with a self-service admission application program instance. In the Oracle EBS 12.1.1 and 12.2.2 documentation sets, this object is explicitly classified as obsolete and is annotated as "Not implemented in this database." Its presence in the data dictionary is therefore historical and referential rather than operational; implementations on supported releases will not normally encounter populated rows or runtime dependencies.

Functionally, staging tables in the IGS self-service admission flow act as transient holding areas where data captured through a web-facing application is validated and subsequently promoted into the permanent applicant and enrollment tables. IGS_SS_AD_EDUGOA_STG occupies that role for education goal selections tied to a specific application program instance. Based on the foreign key topology provided in the metadata, the heuristic Data Vault classification is link: the table resolves relationships between an application program staging record and a coded education goal value rather than carrying a full descriptive payload of its own.

Key Information Stored

The table is documented with eight physical columns, of which the following are the most significant for identification and joining:

• SS_EDUGOA_ID — The surrogate primary key, defined by the unique index IGS_SS_AD_EDUGOA_STG_PK. This is the single business-key candidate documented for the table and uniquely identifies each staged education goal record. The search term "igs_ss_ad_edugoa_stg_pk" refers directly to this constraint.
• SS_ADMAPPL_PGM_ID — Foreign key to IGS_SS_APP_PGM_STG. It associates the education goal row with the parent self-service admission application program instance staged in that table.
• EDU_GOAL_ID — Foreign key to IGS_AD_CODE_CLASSES. It identifies the specific education goal value drawn from the admissions code class reference data.
• CREATED_BY, CREATION_DATE — Standard Oracle EBS audit columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification user, timestamp, and login context.

The audit columns follow the conventional WHO column pattern used throughout Oracle Applications, enabling traceability of who inserted or amended each staged row.

Common Use Cases and Queries

Because the object is marked obsolete and not implemented, practical query activity is limited to historical schemas, migration analysis, and impact assessment. Typical investigative patterns include:

• Structural discovery — Confirming the primary key and column list when reconciling older 11i-era customizations against a 12.1.1 or 12.2.2 instance.
• Joining staged goals to their parent application — SELECT g.SS_EDUGOA_ID, g.EDU_GOAL_ID, p.SS_ADMAPPL_PGM_ID FROM IGS_SS_AD_EDUGOA_STG g JOIN IGS_SS_APP_PGM_STG p ON g.SS_ADMAPPL_PGM_ID = p.SS_ADMAPPL_PGM_ID;
• Resolving goal descriptions — SELECT g.SS_EDUGOA_ID, c.DESCRIPTION FROM IGS_SS_AD_EDUGOA_STG g JOIN IGS_AD_CODE_CLASSES c ON g.EDU_GOAL_ID = c.EDU_GOAL_ID;
• Audit reporting — Filtering on CREATION_DATE or LAST_UPDATE_DATE to trace the origin and modification history of staged admission data during migration validation.

Any production use of these patterns should be preceded by a check of USER_TABLES, since the documentation states the table is not implemented in the supplied database.

Related Objects

The metadata documents two foreign key dependencies, which are the principal related objects:

• IGS_SS_APP_PGM_STG — Referenced through IGS_SS_AD_EDUGOA_STG.SS_ADMAPPL_PGM_ID. This is the parent staging table for the self-service admission application program instance and the primary relationship in the model.
• IGS_AD_CODE_CLASSES — Referenced through IGS_SS_AD_EDUGOA_STG.EDU_GOAL_ID. This admissions code class table supplies the valid education goal values.
• IGS_SS_AD_EDUGOA_STG_PK — The unique index enforcing the surrogate primary key on SS_EDUGOA_ID, and the object named in the original search.

Beyond these documented relationships, dependent objects would be limited to any legacy self-service admission packages or views that referenced the staging table prior to its obsolescence; such dependencies should be confirmed against the specific instance's data dictionary rather than assumed.