Search Results pcge_start_dt

Overview

The IGS_PE_CRS_GRP_EXCL table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Oracle Student Management (OSM) or Campus Solutions modules. It functions as a detailed transaction table that records instances where a student (person) is formally excluded from a defined group of academic programs (course group) as a direct consequence of an institutional hold or encumbrance. Its primary role is to enforce academic and administrative policies by preventing student admission or enrollment into any program belonging to the excluded group, thereby maintaining data integrity and policy compliance within the student lifecycle.

Key Information Stored

The table stores a composite record linking a person, their active encumbrance, and the specific program group exclusion enacted. Key columns include identifiers for the person (PERSON_ID) and the encumbrance effect (ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, PEE_SEQUENCE_NUMBER). The critical academic data points are the COURSE_GROUP_CD, which identifies the prohibited program group, and the PCGE_START_DT (the user's search term), which is the effective start date of this specific program group exclusion. The EXPIRY_DT indicates when the exclusion is no longer in effect, with a null value signifying an ongoing restriction. Standard WHO columns (CREATED_BY, CREATION_DATE, etc.) are present for auditing.

Common Use Cases and Queries

This table is central to reporting on and validating student holds. Common use cases include generating lists of students currently excluded from specific program groups for academic advising, validating enrollment eligibility in real-time during application or enrollment processes, and auditing the history of exclusions linked to disciplinary or financial holds. A typical query would join to person and course group tables to produce a readable report.

Sample Query: Find active exclusions for a program group:

SELECT pg.person_id,
       p.last_name,
       p.first_name,
       pg.course_group_cd,
       pg.pcge_start_dt,
       pg.expiry_dt
FROM igs.igs_pe_crs_grp_excl pg
JOIN igs.igs_pe_person p ON pg.person_id = p.person_id
WHERE pg.course_group_cd = '&GROUP_CODE'
  AND (pg.expiry_dt IS NULL OR pg.expiry_dt > SYSDATE)
ORDER BY pg.pcge_start_dt DESC;

Related Objects

The table maintains defined relational integrity through its primary and foreign keys, linking it to master and transactional data.

• Primary Key: IGS_PE_CRS_GRP_EXCL_PK (Composite key on PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, PEE_SEQUENCE_NUMBER, COURSE_GROUP_CD, PCGE_START_DT).
• Foreign Key Reference to IGS_PE_PERSENC_EFFCT: The columns (PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, PEE_SEQUENCE_NUMBER) reference the person encumbrance effect detail, ensuring every exclusion is tied to a valid, established hold effect.
• Foreign Key Reference to IGS_PS_GRP_ALL: The COURSE_GROUP_CD column references the master table of defined program groups, ensuring the exclusion applies to a valid academic grouping.