Search Results igs_ad_prcs_cat_step_all

Overview

The IGS_AD_PRCS_CAT_STEP_ALL table is a core configuration table within the Oracle E-Business Suite Student System (IGS). It defines the specific processing steps that must be completed for a given admission category and admission process type. This table establishes the workflow sequence for handling applications, linking high-level admission classifications to the granular, actionable steps required to process them. Its role is to serve as a master definition table, ensuring consistent application processing rules are enforced across the institution. As an "_ALL" table, it is designed to support multi-organization access (MOAC) within EBS, allowing data to be partitioned by operating unit.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies a step within a specific admission process and category. The key columns are ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE, and S_ADMISSION_STEP_TYPE. These columns store codes that reference lookup values, defining the admission category (e.g., Undergraduate, Graduate), the type of process (e.g., Application Review, Document Verification), and the specific step to be executed (e.g., "Fee Check," "Transcript Received"). While the provided metadata does not list all columns, typical related tables would include control columns such as ENABLED_FLAG, SEQUENCE_NUMBER (to order steps), and possibly attributes controlling step behavior, mandatory status, and responsibility assignments.

Common Use Cases and Queries

This table is primarily queried for configuration validation and to drive application workflow engines. Common use cases include generating a checklist of required steps for a new application based on its category, validating setup during implementation, and creating audit reports of defined processes. A typical query would join to the IGS_AD_PRCS_CAT_ALL table to list all steps for a specific admission category.

Sample SQL Pattern:
SELECT step.s_admission_process_type,
step.s_admission_step_type
FROM igs_ad_prcs_cat_step_all step
WHERE step.admission_cat = 'UG_FRESHMAN'
ORDER BY <sequence_column>;

Reporting often involves joining this table to application transactional data to track completion status against the defined requirements for each application.

Related Objects

The table maintains a critical foreign key relationship with the IGS_AD_PRCS_CAT_ALL table, which defines the admission categories and process types themselves. This enforces referential integrity, ensuring that steps cannot be defined for non-existent categories or process types.

• Primary Key: IGS_AD_PRCS_CAT_STEP_PK on (ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE, S_ADMISSION_STEP_TYPE).
• Foreign Key (References): The table IGS_AD_PRCS_CAT_STEP_ALL references IGS_AD_PRCS_CAT_ALL via the columns ADMISSION_CAT and S_ADMISSION_PROCESS_TYPE. This is a many-to-one relationship where many steps are defined for a single admission category/process type combination.

Other related objects would include the lookup tables for the step type (S_ADMISSION_STEP_TYPE) and various application transaction tables that record the completion of these defined steps for individual applicants.