Search Results igs_en_pig_cp_setup_pk

Overview

The IGS_EN_PIG_CP_SETUP table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It functions as a configuration table that establishes a link between a defined group of persons and specific rules or thresholds for enrollment credit points. Its primary role is to support the management and automated processing of student academic loads by associating credit point parameters with a predefined Person ID Group. This setup enables administrators to apply consistent credit point policies, such as minimum or maximum load requirements, to a specific cohort of students, streamlining administrative tasks in enrollment and progression.

Key Information Stored

The table's structure is designed to map a group identifier to its corresponding enrollment credit point configuration. The primary and most critical column is GROUP_ID, which stores the unique identifier for a Person ID Group as defined in the related IGS_PE_PERSID_GROUP_ALL table. This column serves as the foreign key linking to the group definition. While the provided metadata does not list additional columns, typical setup tables in this context would also store fields for credit point values (e.g., minimum credit points, maximum credit points, standard load), effective dates, and status flags. The primary key constraint IGS_EN_PIG_CP_SETUP_PK ensures that each GROUP_ID is unique within this setup table.

Common Use Cases and Queries

A primary use case is the batch validation of student course enrollments against credit point limits defined for their assigned group. For example, during the enrollment period, a process can query this table to determine the maximum allowed credit points for a student's cohort to prevent over-enrollment. Common reporting involves listing all active credit point setups by group. A fundamental query pattern retrieves the setup details for a specific group or joins to person records to assess compliance.

SELECT s.group_id, g.group_cd, [additional_credit_point_columns]
FROM igs_en_pig_cp_setup s,
     igs_pe_persid_group_all g
WHERE s.group_id = g.group_id
AND g.group_cd = '&GROUP_CODE';

Related Objects

The table maintains a strict foreign key relationship with the Person ID Group master table. This is its principal documented dependency.

• IGS_PE_PERSID_GROUP_ALL: This is the master table defining Person ID Groups. The IGS_EN_PIG_CP_SETUP.GROUP_ID column references IGS_PE_PERSID_GROUP_ALL.GROUP_ID. Any setup record must correspond to a valid, existing group in this parent table. This relationship is enforced by the foreign key constraint listed in the metadata.

While not explicitly listed, this setup table is likely referenced by various enrollment engine packages and views responsible for calculating academic load, checking enrollment eligibility, and generating related student system reports.