Results for “igs_en_cat_prc_step_all_pk”

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

Overview

IGS_EN_CAT_PRC_STEP_ALL is an Oracle E-Business Suite table owned by the IGS (Student System) schema. It defines the individual steps that make up an enrolment procedure (enrolment category) and the sequence in which those steps must be executed. Each row represents one step within a procedure, drawn from the set of system-defined enrolment steps available in the product. The table therefore acts as the structural backbone of enrolment processing, governing both which steps a given category uses and the order in which they must occur.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. This suggests it is best treated as a satellite or reference-type entity rather than as a hub or link, since the FK mining did not surface strong parent-child relationships. Modelers may nonetheless choose to represent it as a link if the composite business key is decomposed into independent hub references during a warehouse implementation.

Key Information Stored

The table carries twelve documented columns. The most operationally significant are:

• ENROLMENT_CAT — the enrolment category that the procedure belongs to; a key discriminator of the procedure.
• S_STUDENT_COMM_TYPE — the student communication type associated with the procedure step.
• ENR_METHOD_TYPE — the enrolment method type, distinguishing procedures by delivery method.
• S_ENROLMENT_STEP_TYPE — the system-defined enrolment step being selected.
• STEP_ORDER_NUM — the sequence number controlling the order in which the step must be performed.
• MANDATORY_STEP_IND — a flag indicating whether the step is mandatory within the procedure.
• ORG_ID — the operating unit that owns the record, enabling multi-org security.

The four columns ENROLMENT_CAT, S_STUDENT_COMM_TYPE, ENR_METHOD_TYPE, and S_ENROLMENT_STEP_TYPE together form the primary key (IGS_EN_CAT_PRC_STEP_ALL_PK). The same four columns also constitute the unique index IGS_EN_CAT_PRC_STEP_ALL_U1, making them the business-key candidate. The primary key is effectively a composite business key rather than a system-generated surrogate, so there is no separate single-column surrogate identifier on this table.

Standard EBS audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are also present and should be referenced in any audit or change-tracking report.

Common Use Cases and Queries

Typical uses include reconstructing the ordered step list for a given enrolment category, verifying which steps are mandatory, and validating that a procedure has been configured consistently before enrolment processing. A representative query returns the ordered procedure for one category:

• SELECT s_enrolment_step_type, step_order_num, mandatory_step_ind
• FROM igs.igs_en_cat_prc_step_all
• WHERE enrolment_cat = :p_cat
• AND s_student_comm_type = :p_comm
• AND enr_method_type = :p_method
• AND org_id = :p_org
• ORDER BY step_order_num;

Reporting scenarios include producing a catalogue of all enrolment procedures with their step counts, identifying procedures that contain no mandatory steps, and auditing sequence gaps or duplicate step-order values within a single procedure. Because ORG_ID is present, all query patterns should be filtered by operating unit when multi-org access is enabled.

Related Objects

The metadata describes this object as standalone, so its references are primarily to lookup and category definitions rather than to enforced FK parents. The principal related objects are:

• IGS_EN_CAT_PRC_STEP_ALL_PK / IGS_EN_CAT_PRC_STEP_ALL_U1 — the primary key and unique index enforcing uniqueness on the four business-key columns.
• Enrolment category definitions — the parent concept referenced via ENROLMENT_CAT.
• Student communication type lookups — referenced via S_STUDENT_COMM_TYPE.
• Enrolment method type lookups — referenced via ENR_METHOD_TYPE.
• System-defined enrolment step types — referenced via S_ENROLMENT_STEP_TYPE.
• IGS enrolment processing APIs and concurrent programs — consume the ordered step rows defined here during procedure execution.

Implementers should verify lookup dependencies at the time of deployment, since the documented schema records no enforced foreign keys for this table.