Search Results igs_pe_crs_grp_excl_pk

Overview

The IGS_PE_CRS_GRP_EXCL table is a core data entity within the Oracle E-Business Suite Student System (IGS) module, versions 12.1.1 and 12.2.2. It serves a critical administrative function by recording specific academic restrictions placed on students. The table's primary purpose is to document instances where a person (student) has been formally excluded from a defined course group due to an encumbrance. An encumbrance is a type of hold or sanction, such as an academic probation or disciplinary action. This table provides the granular link between a person's active encumbrance effect and the specific academic program groupings from which they are barred, enabling enforcement of enrollment and registration rules within the student lifecycle management system.

Key Information Stored

The table stores a composite record keyed to a specific person and their encumbrance details. The primary key is a combination of eight columns, ensuring a unique record for each exclusion linked to a precise encumbrance effect and course group. Critical columns include PERSON_ID, which identifies the student, and the set of columns (ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, PEE_SEQUENCE_NUMBER) that collectively form a foreign key to the IGS_PE_PERSENC_EFFCT table, pinpointing the exact encumbrance effect instance. The COURSE_GROUP_CD references the excluded academic program group from IGS_PS_GRP_ALL. The PCGE_START_DT is a timestamp for the exclusion record itself, allowing for historical tracking if multiple exclusions are applied or modified over time.

Common Use Cases and Queries

This table is central to processes that validate a student's eligibility for course enrollment or program admission. A common operational use case is a background validation during student self-service enrollment, where the system checks this table to prevent a student with an active exclusion from registering for courses within the barred group. For reporting and administrative queries, one might identify all students currently excluded from a particular course group. A sample SQL pattern, referencing the user's search term, would be:

• SELECT person_id, course_group_cd, pcge_start_dt FROM igs_pe_crs_grp_excl WHERE pee_start_dt > SYSDATE - 365;

This query finds exclusion records linked to encumbrance effects (PEE_START_DT) initiated within the last year. Another critical query joins IGS_PE_CRS_GRP_EXCL with IGS_PE_PERSENC_EFFCT and IGS_PE_PERSON to generate a list of excluded students with their personal details for academic advising or disciplinary review.

Related Objects

The IGS_PE_CRS_GRP_EXCL table is a dependent entity with defined foreign key relationships to two master tables, as documented in the provided metadata.

• IGS_PS_GRP_ALL: This table defines the valid course groups within the institution. The foreign key relationship is via the COURSE_GROUP_CD column. A join on this column retrieves the description and details of the academic group from which the person is excluded.
• IGS_PE_PERSENC_EFFCT: This is the key parent table for person encumbrance effects. The foreign key relationship is a composite link using the columns PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, and PEE_SEQUENCE_NUMBER. This relationship ensures every exclusion is tied to a valid, active encumbrance effect record, maintaining referential integrity for the student's sanction.