Results for “igsbv_ad_appl_edugoal”

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

Overview

The view IGSBV_AD_APPL_EDUGOAL is a read-only reporting object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. It presents information about an applicant's educational goal as recorded after enrollment and tied to an admission application. The view is defined with the WITH READ ONLY clause, confirming that it is intended exclusively for query, reporting, and integration consumption rather than for direct data manipulation. This reflects the standard IGS design pattern in which denormalized, business-friendly views are exposed to downstream consumers while write operations remain against the underlying base tables.

The primary lookup column associated with this object is POST_EDUCATION_GOAL_ID, which the view exposes as its leading identifier. This makes IGSBV_AD_APPL_EDUGOAL the natural reporting surface for any query resolving a post-education goal against the person and application context in Oracle EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over three base objects joined in a single SELECT statement:

• IGS_AD_EDUGOAL AED — the primary IGS table holding educational goal records for the applicant, driving the view's grain.
• HZ_PARTIES P — the TCA (Trading Community Architecture) party registry, joined on AED.PERSON_ID = P.PARTY_ID and providing PARTY_NUMBER.
• HZ_PERSON_PROFILES PP — the TCA person profile, joined on P.PARTY_ID = PP.PARTY_ID and supplying PERSON_NAME.

The join to HZ_PERSON_PROFILES is an outer join (PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED') and is further constrained by an effective-dating predicate: SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE, SYSDATE). This ensures that only the currently effective, user-entered person profile row is returned, which is significant because person profiles in TCA are date-tracked and may contain multiple historical or system-generated versions. Note that although the view text references these base tables, the ETRM 12.2.2 metadata documents no referenced base objects, so verification against the database definition in a given instance is advisable.

Key Columns

The view exposes the following columns, which align to the base object attributes:

• POST_EDUCATION_GOAL_ID — the primary identifier for the post-enrollment education goal record.
• PERSON_ID — the person/party identifier from the applicant record.
• PERSON_NUMBER — the human-readable party number from HZ_PARTIES.
• PERSON_NAME — the person's name from the effective HZ_PERSON_PROFILES row.
• ADMISSION_APPLICATION_NUMBER — the admission application number (source column ADMISSION_APPL_NUMBER).
• NOMINATED_PROGRAM_CODE — the nominated course/program code (source column NOMINATED_COURSE_CD).
• APPLICATION_INST_SEQUENCE_NUM — the sequence number distinguishing multiple goals within an application (source column SEQUENCE_NUMBER).
• EDUCATION_GOAL_ID — the reference to the education goal value itself.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include admission reporting, applicant roster extracts, and integrations that need the post-education goal associated with a person and application. A common query retrieves goals for a specific person:

SELECT post_education_goal_id,
       person_number,
       person_name,
       admission_application_number,
       nominated_program_code,
       education_goal_id
FROM   igsbv_ad_appl_edugoal
WHERE  person_id = :p_person_id;

Reporting by application or program is equally straightforward:

SELECT admission_application_number,
       nominated_program_code,
       COUNT(*) goal_count
FROM   igsbv_ad_appl_edugoal
GROUP  BY admission_application_number, nominated_program_code;

Because the view is read-only and denormalized across IGS and TCA, it is well suited to operational reports and extract interfaces where resolving the person name and party number would otherwise require additional joins.