Search Results s_enrolment_step_type




Overview
Explore in AI Chat

Overview

The IGS_EN_PIG_S_SETUP table is a configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (formerly Oracle Campus Solutions) product. Its primary role is to define the behavior of enrollment processes for predefined groups of persons (Person ID Groups). The table acts as a junction, linking a specific Person ID Group with specific enrollment step types and specifying the type of notification—either a warning or a denial—that should be triggered when a student in that group encounters the specified step during enrollment. This setup enables institutions to enforce differentiated enrollment rules and validations based on student attributes or classifications.

Key Information Stored

The table stores a concise set of columns essential for its configuration purpose. The GROUP_ID is a mandatory numeric column serving as the foreign key to a Person ID Group, identifying the specific student population. The S_ENROLMENT_STEP_TYPE is a mandatory 30-character VARCHAR2 column that holds the code for a specific type of enrollment step or validation (e.g., prerequisites, financial holds, time conflicts). The NOTIFICATION_FLAG is a 10-character VARCHAR2 column that dictates the system's response, accepting values such as 'Deny' to block enrollment or 'Warn' to allow it with a message. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing. The primary key is a composite of GROUP_ID and S_ENROLMENT_STEP_TYPE, ensuring a unique rule per group and step type combination.

Common Use Cases and Queries

A primary use case is configuring enrollment restrictions for specific student cohorts, such as probationary students or those in a particular academic program. An administrator might set a rule where students in a "Financial Hold" group receive a 'Deny' notification for any enrollment step, effectively blocking their enrollment until the hold is cleared. For reporting and administration, common queries include listing all configured rules for a specific group or identifying which groups have a 'Deny' flag for a critical enrollment step. A sample query to review all setup data is:

SELECT pigss.GROUP_ID,
       pigss.S_ENROLMENT_STEP_TYPE,
       pigss.NOTIFICATION_FLAG,
       pig.group_name
FROM IGS.IGS_EN_PIG_S_SETUP pigss,
     IGS.IGS_PE_PERSID_GROUP_ALL pig
WHERE pigss.GROUP_ID = pig.group_id
ORDER BY pig.group_name, pigss.S_ENROLMENT_STEP_TYPE;

Related Objects

The table has defined relationships with other key objects in the EBS data model. Its primary key (GROUP_ID, S_ENROLMENT_STEP_TYPE) is enforced by the IGS_EN_PIG_S_SETUP_PK constraint. A critical foreign key relationship exists where the GROUP_ID column references IGS.IGS_PE_PERSID_GROUP_ALL. This links the setup rule to the master definition of Person ID Groups. The dependency information confirms that the table is referenced by the APPS schema synonym IGS_EN_PIG_S_SETUP, which is the standard access point for application code and reports. This setup table is central to the enrollment engine's logic for applying group-specific validations.