Search Results igs_ad_edugoal_u1

Overview

IGS.IGS_AD_EDUGOAL is a transactional table within the Oracle E-Business Suite (12.1.1 and 12.2.2) student and admissions management module, owned by the IGS schema (Student Systems / Oracle Student System lineage). It stores data about a person's educational goal as captured during the admissions process. Each row links a person to a nominated course of study and an associated educational goal code, providing the admissions office with structured intent data used for application processing, course allocation, and educational reporting.

Under a heuristic Data Vault classification mined from its foreign key structure, this table can be modeled as a link entity: it resolves many-to-many style relationships between a person/application (PERSON_ID, ADMISSION_APPL_NUMBER) and an educational goal or class code (EDU_GOAL_ID). It carries its own descriptive and sequence attributes rather than serving purely as a junction, so it also exhibits satellite-like characteristics. This classification is offered as a modeling suggestion only.

Key Information Stored

The table contains 11 documented columns. The most significant are:

• POST_EDUGOAL_ID — Numeric (15) surrogate primary key, described as the post educational unit identifier. It is the sole column behind the IGS_AD_EDUGOAL_PK primary key index and is the column referenced in the user's search.
• PERSON_ID — Numeric (15) identifier of the person for whom the educational goal is recorded; a foreign key to IGS_AD_PS_APPL_INST_ALL.
• ADMISSION_APPL_NUMBER — Numeric admission application number tying the goal to a specific application.
• NOMINATED_COURSE_CD — VARCHAR2 nominated course code, identifying the course the applicant intends to pursue.
• SEQUENCE_NUMBER — Numeric sequencing value, supporting ordered recording of multiple goals.
• EDU_GOAL_ID — Numeric (15) educational goal identifier; a foreign key to IGS_AD_CODE_CLASSES, resolving to a coded goal value.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who columns providing audit and concurrency information.

The business-key candidate is captured by the unique index IGS_AD_EDUGOAL_U1 over (ADMISSION_APPL_NUMBER, EDU_GOAL_ID, NOMINATED_COURSE_CD, PERSON_ID, SEQUENCE_NUMBER), which distinguishes it from the surrogate POST_EDUGOAL_ID. A nonunique index (IGS_AD_EDUGOAL_N1) exists on EDU_GOAL_ID, and the PK index (IGS_AD_EDUGOAL_PK) is on POST_EDUGOAL_ID.

Common Use Cases and Queries

Typical applications include admissions pipeline reporting, applicant intent analysis, and course-demand forecasting. Administrators query this table to list all educational goals recorded against an application or person. A representative query patterns the join to decode the goal:

• Retrieve goals for a person: SELECT POST_EDUGOAL_ID, PERSON_ID, EDU_GOAL_ID, NOMINATED_COURSE_CD FROM IGS.IGS_AD_EDUGOAL WHERE PERSON_ID = :person_id ORDER BY SEQUENCE_NUMBER;
• Join to the admissions instance table via PERSON_ID, and to the code classes table via EDU_GOAL_ID, to produce a descriptive report of applicant goals.
• Reporting on nominated course demand: aggregate by NOMINATED_COURSE_CD across applications.
• Audit checks using the Who columns to trace record creation and last modification.

Related Objects

The FK metadata documents two referenced parent tables and one dependent application object:

• IGS.IGS_AD_CODE_CLASSES — joined on EDU_GOAL_ID to translate the goal code into a description.
• IGS.IGS_AD_PS_APPL_INST_ALL — joined on PERSON_ID to link the goal to the applicant instance record.
• APPS.IGS_AD_EDUGOAL — the APPS-layer synonym or view that references the base table.

Common related tables in the admissions domain include the admission application header and person tables, which are reached through PERSON_ID and ADMISSION_APPL_NUMBER. When querying through the APPS synonym, users should be aware of the underlying IGS ownership and the standard APPS schema grant model.