Search Results edu_goals




Overview
Explore in AI Chat

Overview

IGS_AD_PS_APL_INST_CNTX_V is a denormalized Oracle E-Business Suite (EBS) view in the APPS schema that presents a consolidated, reporting-ready projection of applicant admission and course-instance context data within the Student Systems / Recruiting and Admissions (IGS) product family. Its role is to flatten normalized admissions data — party identity, application records, admission and academic calendar instances, course, location, and attendance attributes — into a single row per admissions application instance, enriched with decoded lookup meanings and human-readable descriptions. This makes it suitable for operational reporting, self-service pages, concurrent program extracts, and integration feeds where a single wide row is preferable to multiple joins across the base admissions tables. The view is relevant in both EBS 12.1.1 and 12.2.2; the underlying IGS schema is largely unchanged between these releases, though the 12.2.2 online patching (adop) model affects how the APPS synonym resolves.

Underlying Base Objects

The ETRM metadata excerpt for this object does not enumerate the referenced base objects, so the definitive dependency list is not documented here. However, the view text itself clearly references several IGS base tables and lookup structures, including IGS_AD_APPL_INSTANCES (aliased acai, evidenced by columns such as nominated_course_cd, admission_appl_number, sequence_number), IGS_AD_APPLICATIONS_V or an applications table (aliased aav, providing admission_cat, appl_dt, acad_cal_type), HZ_PARTIES (aliased p, providing party_id, party_number, name attributes), IGS_CA_INSTANCES or a calendar-instance table (aliased ci1/ci2, providing alternate_code, start_dt, end_dt), a course-version table (aliased crv, supplying title mapped to cgnbt_course_cd), FND_LOOKUPS (aliased lkup, for meaning), IGS_EN_UNIT_SET (for unit-set titles), and IGS_AD_CODE_CLASSES (for EDU_GOALS code names and descriptions).

Key Columns

  • cgnbt_course_cd — the course-version title from crv.title; the term the user searched for. It aliases the course-version descriptive title, distinct from the raw course_cd.
  • person_id, person_number, dsp_context_block_name — party identifiers and a display name concatenated from last name, title, and known-as/first name.
  • admission_appl_number, sequence_number, nominated_course_cd — the admissions application key and nominated course.
  • course_cd, location_cd, attendance_mode, attendance_type — delivery attributes of the application instance.
  • adm_prc_type_desc, admission_process_cat, s_admission_process_type, admission_cat — decoded admission process/category values.
  • acad_cal_type, acad_ci_sequence_number, acad_alternate_code, adm_cal_type, adm_ci_sequence_number, alternate_code, commencement_period — academic and admission calendar instance context, with the commencement period concatenating the two alternate codes.
  • acad_ci_start_dt, acad_ci_end_dt, adm_ci_start_dt, adm_ci_end_dt — calendar instance date ranges.
  • unit_set_cd, us_version_number, edu_goal_prior_enroll, edu_goal_prior_enroll_desc — unit-set and prior-education goal details.
  • created_by, creation_date, last_updated_by, last_update_date, last_update_login, row_id — standard audit and row-identification columns.

Common Use Cases and Queries

Typical uses include admission-instance enquiry reports, integration extracts feeding external student systems, and applicant self-service context blocks. A representative query selecting the searched column follows:

SELECT person_number,
       admission_appl_number,
       nominated_course_cd,
       course_cd,
       cgnbt_course_cd
FROM   apps.igs_ad_ps_apl_inst_cntx_v
WHERE  person_number = :p_person_number;

Because the view exposes cgnbt_course_cd (course-version title) alongside course_cd, it is commonly used when a report must display the human-readable course title rather than the coded value. Filtering by adm_cal_type or commencement_period supports admission-intake reporting, while joining on person_id links the context to broader party data.