Search Results igs_en_pig_s_setup

Overview

The IGS_EN_PIG_S_SETUP table is a core configuration table within the Oracle E-Business Suite (EBS) Student System (IGS) module. It serves as a critical junction table that defines the relationship between Person ID Groups and specific enrollment process steps. Its primary role is to establish which groups of persons (students) are subject to particular enrollment step validations or workflows. This setup enables administrators to apply enrollment rules and controls selectively to defined cohorts of students, facilitating granular and targeted management of the student enrollment lifecycle within the application.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two critical columns. The GROUP_ID column stores a foreign key reference to a specific Person ID Group defined in the IGS_PE_PERSID_GROUP_ALL table. This identifies the cohort of students to which the setup applies. The S_ENROLMENT_STEP_TYPE column stores a code that identifies a specific type of enrollment step or process within the student system. The combination of these two fields creates a unique rule, linking a group to a mandatory or relevant enrollment step. While the provided metadata does not list additional columns, this core relationship is the table's fundamental data.

Common Use Cases and Queries

A primary use case is the administrative configuration of enrollment requirements for different student populations. For instance, an institution could create a Person ID Group for "International Graduate Students" and use this setup table to mandate specific enrollment steps, such as visa documentation verification, that do not apply to other groups. Common queries involve identifying all enrollment steps assigned to a particular group or finding all groups linked to a specific enrollment step for auditing or reporting purposes. A typical SQL pattern would be a join to the IGS_PE_PERSID_GROUP_ALL table to resolve group names:

• SELECT pig.group_name, setup.s_enrolment_step_type FROM igs_en_pig_s_setup setup, igs_pe_persid_group_all pig WHERE setup.group_id = pig.group_id;

This data is essential for generating reports on configured enrollment workflows by student cohort.

Related Objects

The IGS_EN_PIG_S_SETUP table has a direct and documented dependency on the Person ID Group master table. As per the provided relationship data:

• Primary Key: IGS_EN_PIG_S_SETUP_PK on columns (GROUP_ID, S_ENROLMENT_STEP_TYPE).
• Foreign Key (References): The GROUP_ID column is a foreign key that references the IGS_PE_PERSID_GROUP_ALL table. This enforces referential integrity, ensuring that every setup record points to a valid, existing Person ID Group. The join condition is IGS_EN_PIG_S_SETUP.GROUP_ID = IGS_PE_PERSID_GROUP_ALL.GROUP_ID.

This table is likely referenced by enrollment engine logic and related setup or validation forms within the Student System to enforce the configured rules during a student's enrollment process.