Results for “admission_process_type”

50+ results




Overview
Explore in AI Chat

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

Overview

The view APPS.IGS_AD_PRCS_CAT_ADMPRCS_V belongs to the Oracle E-Business Suite Student System (formerly Oracle Student System / IGS) admissions module. It presents a denormalized, human-readable perspective of the relationship between admission categories and admission process types. In Oracle EBS 12.1.1 and 12.2.2, this view is one of the seeded IGS reporting objects used to translate internal lookup codes into descriptive meanings for operational reporting, ad hoc queries, and integration extracts.

The user search term admission_process_type maps directly to the ADMISSION_PROCESS_TYPE lookup type referenced in the view's WHERE clause. The view exists primarily to resolve the internal code s_admission_process_type into its descriptive meaning from the IGS lookup set, enabling downstream consumers to present admission process types without direct joins to lookup tables. This makes it well suited to reporting layers, BI Publisher data templates, and interface programs that must display admission configuration data in clear business language.

Underlying Base Objects

Although the ETRM metadata lists no separately documented referenced base objects, the view's SQL text clearly identifies the objects over which it is defined:

  • IGS_AD_PRCS_CAT (aliased APC) — the admission process category mapping table holding the admission_cat and s_admission_process_type pair, plus standard WHO audit columns.
  • IGS_AD_CAT (aliased AC) — the admission category master table supplying description, s_citizenship_type, and closed_ind.
  • IGS_LOOKUPS_VIEW (aliased SLV) — the standard IGS lookup view, filtered to LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE' to supply the lookup meaning.

Joins are established on AC.ADMISSION_CAT = APC.ADMISSION_CAT and SLV.LOOKUP_CODE = APC.S_ADMISSION_PROCESS_TYPE, with the lookup type restriction applied as an implicit filter.

Key Columns

  • ADMISSION_CAT — the admission category identifier; the primary business key from IGS_AD_PRCS_CAT.
  • S_ADMISSION_PROCESS_TYPE — the internal code for the admission process type, joined to the lookup set.
  • DESCRIPTION — the descriptive text of the admission category from IGS_AD_CAT.
  • MEANING — the decoded, user-facing meaning of the admission process type from IGS_LOOKUPS_VIEW.
  • S_CITIZENSHIP_TYPE — the citizenship type attribute associated with the admission category.
  • CLOSED_IND — indicator of whether the admission category is closed for further use.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns inherited from IGS_AD_PRCS_CAT.

Common Use Cases and Queries

Typical uses include validating admission configuration, populating process-type drop-downs in custom forms, and extracting admissions reference data for reporting. A representative query returns active categories and their process type descriptions:

  • SELECT admission_cat, meaning, description FROM apps.igs_ad_prcs_cat_admprcs_v WHERE closed_ind = 'N';
  • SELECT admission_cat, s_admission_process_type, meaning FROM apps.igs_ad_prcs_cat_admprcs_v WHERE meaning LIKE '%UNDERGRAD%';
  • SELECT s_admission_process_type, COUNT(*) FROM apps.igs_ad_prcs_cat_admprcs_v GROUP BY s_admission_process_type;

Because the view exposes both the coded value and its meaning, it is particularly useful when mapping legacy admission process types during data migration or when building concurrent program outputs that require readable reference data.