Search Results igs_pe_course_excl

Overview

The IGS_PE_COURSE_EXCL table is a core data entity within the Oracle E-Business Suite's Student System (IGS) module, specifically in versions 12.1.1 and 12.2.2. It serves as a critical component for managing student disciplinary and administrative holds by formally recording courses from which a student has been excluded. Its primary function is to enforce institutional policies by blocking a student's admission or enrollment into specific academic programs. For example, it can prevent an applicant from being admitted to a particular course due to a prior academic or behavioral encumbrance. The table operates as a child entity, providing detailed course-level exclusions that are linked to a broader student encumbrance record.

Key Information Stored

The table's structure is defined by a composite primary key that intricately links the course exclusion to its parent encumbrance record. The key columns are PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, and PEE_SEQUENCE_NUMBER, which together uniquely identify the specific encumbrance effect. The COURSE_CD column stores the code of the course from which the student is excluded, referencing the master course definition. The PCE_START_DT column is a critical timestamp indicating the effective start date of this particular course exclusion. This design ensures that a student's exclusion is precisely tied to a defined period and a specific institutional action.

Common Use Cases and Queries

A primary use case is during the admissions or course enrollment process, where the system must check for active exclusions before permitting a student to apply for or enroll in a course. Administrators may also run reports to audit all active course exclusions across the student population. Common SQL queries involve joining this table with person and course master tables to generate meaningful lists. For instance, to find all active exclusions for a specific course, one might query: SELECT pce.* FROM igs_pe_course_excl pce JOIN igs_pe_persenc_effct pee ON pce.person_id = pee.person_id AND pce.encumbrance_type = pee.encumbrance_type WHERE pce.course_cd = '&course_code' AND SYSDATE BETWEEN pce.pce_start_dt AND NVL(pee.expiry_dt, SYSDATE+1);. Another typical pattern is identifying all exclusions for a given student by filtering on PERSON_ID and checking for non-expired parent encumbrance effects.

Related Objects

The IGS_PE_COURSE_EXCL table maintains strict referential integrity through documented foreign key relationships. It is a dependent child table of two key entities:

• IGS_PS_COURSE: The COURSE_CD column references IGS_PS_COURSE, ensuring that an exclusion can only be placed against a valid, defined course in the system.
• IGS_PE_PERSENC_EFFCT: This is the primary parent table. The foreign key links on the composite columns (PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, PEE_SEQUENCE_NUMBER) tether each course exclusion record to a specific instance of a personal encumbrance effect. This relationship is fundamental, as the course exclusion is an effect or detail of a broader encumbrance placed on the student's record.

These relationships are essential for data consistency and for navigating from a high-level student hold down to the specific course restrictions it imposes.