Search Results step_group_type




Overview
Explore in AI Chat

Overview

IGS_AD_PRCS_CAT_STEP_V is a seeded Oracle EBS database view owned by the APPS schema, defined in the Oracle Student System (also known as Oracle Student Information System, or IGS) product family. It presents the set of admission process catalog steps that a given admission category is permitted to follow, combining configuration rows from the IGS_AD_PRCS_CAT_STEP base table with descriptive attribute information drawn from the IGS lookups infrastructure. The view exposes a denormalized, reporting-friendly projection of admissions setup data, supporting admissions process configuration queries, catalog validation, and integration extracts without requiring the caller to join the lookup views and tracking-type tables directly.

The view is of particular interest to implementers researching the column step_type_restriction_num_ind, an indicator that governs whether a numeric step-type restriction value must be supplied for a given admission step type within a catalog step definition.

Underlying Base Objects

The view is defined as a UNION ALL-style composition of two SELECT branches. Although the ETRM metadata lists no documented referenced base objects, the embedded view text identifies them explicitly:

  • IGS_AD_PRCS_CAT_STEP (APCS) — the driving table holding admission category, process type, admission step type, step group type, mandatory step indicator, step type restriction number, step ordering, and standard audit columns.
  • IGS_LOOKUPS_VIEW (LKUPV1) — supplies the step meaning, the step_type_restriction_num_ind indicator, and closed indicator for non-TRACK step group rows. It is joined on LOOKUP_TYPE = 'ADMISSION_STEP_TYPE', LOOKUP_CODE = S_ADMISSION_STEP_TYPE, and matching STEP_GROUP_TYPE.
  • IGS_TR_TYPE (TRT) — supplies tracking-type description and closed indicator for the TRACK branch.
  • IGS_LOOKUP_VALUES (LKUPV2) — supplies the tracking-type meaning for the TRACK branch, joined on LOOKUP_TYPE = 'TRACKING_TYPE'.

The first branch returns rows where STEP_GROUP_TYPE is not 'TRACK'; the second returns rows where STEP_GROUP_TYPE equals 'TRACK', with S_TRACKING_TYPE and S_TRK_MEANING populated in place of the step meaning columns.

Key Columns

Common Use Cases and Queries

This view is typically used to list the steps available within an admission category, to identify which steps require a numeric step-type restriction, or to extract catalog step configuration into downstream interfaces. A representative query is:

  • SELECT admission_cat, s_admission_step_type, step_group_type, step_type_restriction_num_ind, step_type_restriction_num, step_order_num FROM apps.igs_ad_prcs_cat_step_v WHERE admission_cat = :p_category ORDER BY step_order_num;
  • SELECT admission_cat, s_admission_step_type, step_order_num FROM apps.igs_ad_prcs_cat_step_v WHERE step_type_restriction_num_ind = 'Y';
  • SELECT step_group_type, COUNT(*) FROM apps.igs_ad_prcs_cat_step_v GROUP BY step_group_type;

Because the view already resolves lookup meanings and tracking descriptions, it is preferable to the underlying base table for read-only reporting, while remaining unsuitable for direct DML.