Results for “admission_process_category”

15 results




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

Overview

The IGS_AD_SS_PRC_CAT_V view is a reporting and integration object within the Oracle E-Business Suite IGS – Student System product family. It is owned by the APPS schema and is delivered with a status of VALID in both Oracle EBS 12.1.1 and 12.2.2. The view presents admission process categories in a denormalized, presentation-ready form, combining a coded identifier with its human-readable lookup meaning so that downstream reports, self-service pages, and integration interfaces do not need to perform their own joins against the lookup tables. The distinctive naming convention — the SS segment typically denoting a self-service or summary-oriented construct — indicates that this view is intended primarily for read-only consumption rather than for transactional maintenance. Users searching for the term "admission_process_category" are typically attempting to resolve how the composite admission process category label is derived, and this view is the documented source for that value. Because it exposes a concatenated display string alongside the raw code, it is well suited for list-of-values (LOV) definitions, concurrent program parameters, and BI Publisher data templates within the Student System module.

Underlying Base Objects

The view is defined over three documented base objects in the APPS schema:

  • IGS_AD_PRCS_CAT — the admission process category table, aliased APC, which supplies the primary ADMISSION_CAT code and the S_ADMISSION_PROCESS_TYPE discriminator.
  • IGS_AD_CAT — the admission category table, aliased AC, which is joined on ADMISSION_CAT and filtered so that only records where NVL(CLOSED_IND, 'N') = 'N' are returned. This means categories flagged as closed are excluded from the view.
  • IGS_LOOKUPS_VIEW — the standard Oracle lookups view, aliased ILV, which resolves the S_ADMISSION_PROCESS_TYPE code against the ADMISSION_PROCESS_TYPE lookup type to produce the meaningful description.

Although the ETRM metadata records no formal referenced base objects, the view text documents this three-table join explicitly. The join between the process category and category tables is an inner join on ADMISSION_CAT, and the lookup join is an equality between ILV.LOOKUP_CODE and APC.S_ADMISSION_PROCESS_TYPE restricted to the correct lookup type.

Key Columns

  • ADMISSION_PROCESS_CATEGORY — the composite display value, formed as APC.ADMISSION_CAT || '/' || ILV.MEANING. This is the column most directly associated with the "admission_process_category" search term.
  • ADMISSION_CAT — the raw admission category code from the base table, retained so that consumers can join or filter programmatically without parsing the concatenated string.
  • S_ADMISSION_PROCESS_TYPE — the admission process type code used as the lookup discriminator, useful for grouping or filtering categories by process type.

Common Use Cases and Queries

Typical scenarios include populating an LOV for an admission category parameter, driving self-service selection lists, and feeding extract programs. A representative query returning all active admission process categories follows:

SELECT admission_process_category, admission_cat, s_admission_process_type FROM apps.igs_ad_ss_prc_cat_v ORDER BY admission_process_category;

To restrict results to a single process type, add a predicate on s_admission_process_type:

SELECT admission_process_category FROM apps.igs_ad_ss_prc_cat_v WHERE s_admission_process_type = :p_process_type;

Because closed categories are already filtered out by the view definition, consumers do not need to re-apply the CLOSED_IND condition. All queries should be issued against the APPS schema with the appropriate MO or responsibility context, and results should be treated as read-only.