Search Results hz_gender




Overview
Explore in AI Chat

Overview

IGS_AD_PS_APLCNTX_LKUP_V is a lookup-oriented view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema and part of the Oracle Student System (formerly Student Information System) product family. The IGS_ prefix and the _AD_PS_ naming convention identify it as belonging to the Admissions module, specifically the person/applicant context subsystem. The view exposes admitted-applicant and application-context attributes alongside decoded lookup meanings, and is designed to present human-readable values in conjunction with the underlying code values stored in the database.

The _LKUP_V suffix signals that the view exists primarily to resolve lookup codes into their display meanings. In this case, the lookup translation is applied to the SEX column, which is decoded against the HZ_GENDER lookup type using a scalar subquery against FND_LOOKUP_VALUES. This makes the view suitable for reports, concurrent programs, OAF pages, and integration extracts where gender must be rendered as a meaning rather than a code.

Underlying Base Objects

The documented view text shows that IGS_AD_PS_APLCNTX_LKUP_V is defined entirely over a single underlying view:

The ETRM metadata does not document the base tables referenced by IGS_AD_PS_APPL_APLCNTX_V; it is listed as an internal view. A secondary, non-persistent source is the Oracle Applications lookup infrastructure:

Because the view layers a decode over its source, it introduces no new persistence and simply projects the context view's columns with one derived descriptive attribute.

Key Columns

Common Use Cases and Queries

This view is typically used to report on admitted applicants with their commencement period, application number, and gender presented in display form. A representative query retrieving applicant context is:

  • SELECT person_id, admission_appl_number, nominated_course_cd, commencement_period, sex, meaning_sex FROM apps.igs_ad_ps_aplcntx_lkup_v WHERE commencement_period = :p_period;
  • SELECT person_id, admission_appl_number, birth_dt FROM apps.igs_ad_ps_aplcntx_lkup_v WHERE encumbered_ind = 'Y';
  • SELECT admission_process_cat, COUNT(*) FROM apps.igs_ad_ps_aplcntx_lkup_v GROUP BY admission_process_cat;

Typical scenarios include admissions reporting by intake/commencement period, integration feeds that require a decoded gender value, and extract programs joining on PERSON_ID or ADMISSION_APPL_NUMBER. As with all APPS views, appropriate grants and a compatible language/session context are required for the HZ_GENDER lookup to resolve correctly.