Results for “igs_ad_ps_appl_aplcntx_v”

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

Overview

IGS_AD_PS_APPL_APLCNTX_V is a database view owned by the APPS schema within the IGS (Student System) product family of Oracle E-Business Suite. Its documented purpose is to present a de-normalized projection of the IGS_AD_PS_APPL admissions application table so that Oracle Forms-based screens can treat it as a context block. In ETRM the object is explicitly flagged as Obsolete, meaning Oracle no longer supports or certifies its use for new development. The view remains VALID in the data dictionary for the 12.1.1 and 12.2.2 releases but should be regarded as legacy. Technically it is a join view rather than a simple projection: it merges the application header record with person, admissions-map, and course-version data to expose a single flat row suitable for a Form's context block region, where the block displays read-only descriptive fields for a selected application.

Underlying Base Objects

The ETRM metadata records "none documented" for referenced base objects, but the published view text shows four source objects, three of which are themselves views:

• IGS_AD_PS_APPL (alias ACA) — the admissions application base table, supplying ROW_ID, PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD and audit columns.
• IGS_PE_PERSON_V (alias PDV) — person view joined on PERSON_ID, supplying person number, full name, sex, birth date, and the CONTEXT_BLOCK_NAME used by Forms.
• IGS_AD_APPL_ADMAPPL_V (alias AAV) — admissions application map view, joined on PERSON_ID together with ADMISSION_APPL_NUMBER, supplying COMMENCEMENT_PERIOD and ADMISSION_PROCESS_CAT.
• IGS_PS_VER (alias CRV) — course version table joined on NOMINATED_COURSE_CD, restricted by a scalar sub-query to MAX(VERSION_NUMBER) so that only the latest version of the nominated course is returned.

The relationship is therefore one application row to one person, one map row, and the current course version, giving a single flat result set per application.

Key Columns

• ROW_ID — the primary key of the underlying application row, exposed for Forms row identification.
• PERSON_ID / PERSON_NUMBER / API_PERSON_ID / PERSON_ID_TYPE — person identifiers, including the API-level key used by person integration.
• ADMISSION_APPL_NUMBER — the application number that uniquely identifies the admission application within the person's record.
• NOMINATED_COURSE_CD — the course the applicant has nominated.
• FULL_NAME, SURNAME, GIVEN_NAMES, PREFERRED_GIVEN_NAME, PE_TITLE, SEX, SEX_MEANING, BIRTH_DT — personal descriptive attributes.
• ENCUMBERED_IND, DECEASED_IND — person status indicators, typically surfaced read-only.
• CONTEXT_BLOCK_NAME — the Forms context block identifier carried through from the person view.
• COMMENCEMENT_PERIOD, ADMISSION_PROCESS_CAT — admission intake period and process category.
• TITLE — the course title from the latest course version.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Because the view is obsolete, it should be used only for enquiry or retro-fit reporting against existing Forms customizations, never for new interfaces. A typical lookup retrieves a person's application context with the current course title:

SELECT person_number, admission_appl_number, full_name, nominated_course_cd, title, commencement_period, admission_process_cat FROM igs_ad_ps_appl_aplcntx_v WHERE person_id = :p_person_id;

A second pattern supports applicant-list reporting filtered by intake:

SELECT admission_appl_number, surname, given_names, nominated_course_cd, title FROM igs_ad_ps_appl_aplcntx_v WHERE commencement_period = :p_period AND admission_process_cat = :p_category ORDER BY surname, given_names;

For any new requirement, replace this view with a direct join across IGS_AD_PS_APPL, IGS_PE_PERSON_V, IGS_AD_APPL_ADMAPPL_V and IGS_PS_VER to avoid dependency on an obsolete, unsupported object whose definition may change without notice across patch levels.