Search Results admission_process_type




Overview
Explore in AI Chat

Overview

IGS_AD_PRCS_CAT_V is an Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 view owned by the APPS schema and belonging to the Student System (IGS) product family, specifically the Admissions module. The view presents admission process category definitions in a denormalized, reporting-friendly form. Its central purpose is to resolve the coded value stored in the S_ADMISSION_PROCESS_TYPE column of the underlying IGS_AD_PRCS_CAT table into a human-readable meaning via the IGS_LOOKUPS_VIEW, and to attach the descriptive text of the associated admission category from IGS_AD_CAT. Because the view encapsulates these joins, consumers—whether Oracle Forms-based inquiry windows, concurrent programs, OBIEE/XML Publisher reports, or external integration extracts—can retrieve admission process types without re-implementing lookup translation logic. The documented reference to the search term "admission_process_type" reflects the view's dependence on the lookup type ADMISSION_PROCESS_TYPE, which drives the join condition and supplies the decoded meaning.

Underlying Base Objects

The ETRM metadata documents the view as a join across three objects:

  • IGS_AD_PRCS_CAT APC — the primary admission process category table, supplying the ROW_ID, ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE, OFFER_RESPONSE_OFFSET, CLOSED_IND, and standard WHO audit columns.
  • IGS_LOOKUPS_VIEW L — the IGS lookup view, filtered with LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE', joined on LOOKUP_CODE = APC.S_ADMISSION_PROCESS_TYPE to return the decoded MEANING.
  • IGS_AD_CAT AC — the admission category table, joined on ADMISSION_CAT to supply the category DESCRIPTION.

Two placeholder NULL, NULL columns appear in the outer projection, indicating reserved or legacy positions in the view definition. No additional base objects are documented in the ETRM record.

Key Columns

  • ROW_ID — unique identifier for the process category row.
  • ADMISSION_CAT — code of the associated admission category; foreign key to IGS_AD_CAT.
  • DESCRIPTION — descriptive text of the admission category, sourced from IGS_AD_CAT.
  • S_ADMISSION_PROCESS_TYPE — the stored, coded admission process type value.
  • MEANING — the decoded, user-facing meaning of the process type from IGS_LOOKUPS_VIEW.
  • OFFER_RESPONSE_OFFSET — offset value applied in determining offer response deadlines within the process.
  • CLOSED_IND — indicator of whether the process category is closed.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit (WHO) columns.

Common Use Cases and Queries

Typical scenarios include building admission process setup reports, validating that lookup values are defined for each stored process type, and extracting category/process combinations for integration into downstream admissions systems.

List all active admission process categories with decoded meanings:

  • SELECT admission_cat, description, s_admission_process_type, meaning, offer_response_offset
  • FROM apps.igs_ad_prcs_cat_v
  • WHERE closed_ind = 'N';

Diagnose stored values that fail lookup decoding (null meaning):

  • SELECT row_id, admission_cat, s_admission_process_type
  • FROM apps.igs_ad_prcs_cat_v
  • WHERE meaning IS NULL;

Retrieve the process types configured for a specific admission category:

  • SELECT meaning, offer_response_offset
  • FROM apps.igs_ad_prcs_cat_v
  • WHERE admission_cat = :p_admission_cat
  • ORDER BY meaning;

Because the view already performs the lookup and category joins, reports and integrations should query it directly rather than joining IGS_AD_PRCS_CAT, IGS_LOOKUPS_VIEW, and IGS_AD_CAT independently.