Search Results igs_pe_pers_unt_excl_pk

Overview

The table IGS_PE_PERS_UNT_EXCL is a core data entity within the Oracle E-Business Suite Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. It serves a critical administrative function by formally recording instances where a student has been excluded from a specific academic unit. This exclusion is typically a consequence of an active student encumbrance, which is a type of administrative hold or sanction. The table's role is to maintain a detailed and auditable link between a student's encumbrance effect and the precise unit from which they are barred, ensuring academic rules and disciplinary actions are enforced within the system's registration and enrollment processes.

Key Information Stored

The table stores a composite record that uniquely identifies a unit exclusion for a student under a specific encumbrance. Its primary key is a combination of seven columns, reflecting its dependent relationship on parent encumbrance data. The most critical columns include:

• PERSON_ID: The unique identifier for the student.
• ENCUMBRANCE_TYPE and PEN_START_DT: Key identifiers for the parent person encumbrance.
• S_ENCMB_EFFECT_TYPE, PEE_START_DT, and PEE_SEQUENCE_NUMBER: Key identifiers for the specific encumbrance effect detail that triggered the exclusion.
• UNIT_CD: The code of the academic unit from which the student is excluded.
• PUE_START_DT: The start date of the unit exclusion period.

This structure ensures exclusions are tracked with full context, tied to the authoritative source encumbrance and its effective details.

Common Use Cases and Queries

This table is central to operational reporting and process validation. A primary use case is preventing an excluded student from enrolling in a barred unit via the system's enrollment engine. Administrators use it to generate lists of active exclusions for audit or student advising purposes. Common reporting queries involve joining to person and unit tables to get descriptive information. For example, to find all active unit exclusions for a student:

SELECT ue.UNIT_CD, u.UNIT_NAME, ue.PUE_START_DT
FROM IGS_PE_PERS_UNT_EXCL ue
JOIN IGS_PS_UNIT u ON ue.UNIT_CD = u.UNIT_CD
WHERE ue.PERSON_ID = :student_id
AND SYSDATE BETWEEN ue.PUE_START_DT AND NVL(ue.PUE_END_DT, SYSDATE);

Another critical query validates exclusions against a student's attempted class schedule by joining with enrollment tables, ensuring regulatory compliance.

Related Objects

IGS_PE_PERS_UNT_EXCL has defined foreign key relationships that anchor it firmly within the Student System's data model. Its data integrity and meaning are derived from these parent entities:

• IGS_PE_PERSENC_EFFCT: This is the primary parent table. The exclusion record is a child of a specific encumbrance effect. The join uses the composite key: PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, PEE_SEQUENCE_NUMBER.
• IGS_PS_UNIT: This table provides the master definition and description of the academic unit (UNIT_CD) from which the student is excluded.

Consequently, this table is often accessed in conjunction with IGS_PE_PERSON (for student details), IGS_PE_PERS_ENCUMB (for the main encumbrance record), and the aforementioned tables in any comprehensive query or interface.