Search Results igs_ad_edugoal




Overview
Explore in AI Chat

Overview

IGS_AD_EDUGOAL is an Oracle E-Business Suite table owned by the IGS schema and delivered as part of the Student System (IGS) product family. It stores data about a person's educational goal, capturing the stated academic objective associated with an applicant or learner record. Within the EBS 12.1.1 and 12.2.2 data models, it functions as a transactional detail table that links an individual to the goal, course, and application context in which that goal was declared.

From a heuristic Data Vault modeling perspective, the mined foreign-key structure classifies this object as a link. The table does not appear to hold the master identity of a person or an application; instead it records the association between an institutional person, an admission application, a nominated course, and an education goal code. A Data Vault implementation would therefore likely place IGS_AD_EDUGOAL as a link table joining existing hubs for person, application, and code class, with descriptive and audit attributes maintained in a satellite.

Key Information Stored

The table is documented with eleven physical columns. The surrogate primary key is POST_EDUGOAL_ID, enforced through the unique constraint IGS_AD_EDUGOAL_PK. A second unique index, IGS_AD_EDUGOAL_U1, defines the business-key candidate as the composite of ADMISSION_APPL_NUMBER, EDU_GOAL_ID, NOMINATED_COURSE_CD, PERSON_ID, and SEQUENCE_NUMBER. This composite guarantees that a given person-application-goal-course combination is not duplicated for the same sequence.

  • POST_EDUGOAL_ID — surrogate primary key uniquely identifying each educational goal record.
  • PERSON_ID — identifies the individual whose educational goal is recorded; participates in the foreign key to IGS_AD_PS_APPL_INST_ALL.
  • ADMISSION_APPL_NUMBER — the admission application number linking the goal to a specific application instance.
  • NOMINATED_COURSE_CD — the course nominated or selected in relation to the educational goal.
  • SEQUENCE_NUMBER — orders multiple goal entries within the same person and application context.
  • EDU_GOAL_ID — the education goal code, validated against IGS_AD_CODE_CLASSES.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns recording who created and last modified the row.

Common Use Cases and Queries

Typical reporting and integration scenarios resolve the education goal declared by an applicant at the point of admission. A common join retrieves the goal code description for a person-application pair:

  • Joining IGS_AD_EDUGOAL to IGS_AD_CODE_CLASSES on EDU_GOAL_ID = CODE_CLASSES.EDU_GOAL_ID (via the documented FK path) to translate the goal into a display value.
  • Joining to IGS_AD_PS_APPL_INST_ALL on PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, and SEQUENCE_NUMBER to reconcile the goal with its application record.
  • Aggregating goals by nominated course to support recruitment and admission funnel analysis.
  • Auditing changes using LAST_UPDATE_DATE and LAST_UPDATED_BY for data governance and ETL delta extraction.

Queries should filter on PERSON_ID or POST_EDUGOAL_ID to exploit the primary and unique index access paths efficiently.

Related Objects

The most significant related objects are dictated by the documented foreign keys and unique index columns:

  • IGS_AD_CODE_CLASSES — referenced by IGS_AD_EDUGOAL.EDU_GOAL_ID; supplies valid education goal codes.
  • IGS_AD_PS_APPL_INST_ALL — referenced by PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, and SEQUENCE_NUMBER; the source application instance record.
  • IGS_AD_EDUGOAL_PK — the primary key constraint on POST_EDUGOAL_ID.
  • IGS_AD_EDUGOAL_U1 — the unique index enforcing the composite business key.
  • Person and application hub equivalents within the IGS student model, which depend on this link to express goal participation.