Search Results pue_start_dt

Overview

The IGS_PE_PERS_UNT_EXCL table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Global Systems (IGS) module. It serves as the definitive repository for recording unit exclusions applied to students as a result of institutional holds or encumbrances. The table's primary role is to enforce academic and administrative policies by preventing a student from enrolling in specific units (courses) for which they have been deemed ineligible. This enforcement is a critical component of student lifecycle management, ensuring compliance with academic standing rules, disciplinary actions, or other institutional restrictions.

Key Information Stored

The table stores a detailed record linking a person, an encumbrance, its specific effect, and the targeted academic unit. Key columns define this relationship and the exclusion's temporal validity. The mandatory columns form a composite primary key that uniquely identifies each exclusion record: PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, PEE_SEQUENCE_NUMBER, UNIT_CD, and PUE_START_DT. Of particular note is the PUE_START_DT column, which specifies the precise date the unit exclusion becomes effective. The EXPIRY_DT column indicates when the exclusion is lifted; a NULL value signifies an ongoing, current exclusion. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide essential audit trails for all data changes.

Common Use Cases and Queries

A primary use case is validating student enrollment requests against active unit exclusions. Batch processes or real-time checks will query this table to block unit enrollment for a student if a matching, unexpired record exists. Common reporting needs include generating lists of students currently excluded from specific units or auditing the history of exclusions applied under a particular encumbrance type. A sample query to find all active exclusions for a given unit would be:

SELECT person_id, unit_cd, pue_start_dt, expiry_dt
FROM igs.igs_pe_pers_unt_excl
WHERE unit_cd = 'MATH101'
  AND (expiry_dt IS NULL OR expiry_dt > SYSDATE);

Another frequent pattern involves joining to person and unit description tables to create a readable report, using the key columns to link to the parent encumbrance effect record (IGS_PE_PERSENC_EFFCT) for broader context.

Related Objects

The table's integrity is maintained through defined relational constraints with other core IGS entities. As per the provided metadata, the table has the following documented foreign key relationships:

• IGS_PE_PERSENC_EFFCT: The PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, and PEE_SEQUENCE_NUMBER columns reference the IGS_PE_PERSENC_EFFCT table. This links the unit exclusion to the specific person encumbrance effect that caused it.
• IGS_PS_UNIT: The UNIT_CD column references the IGS_PS_UNIT table. This ensures the excluded unit is a valid, defined unit within the institution's curriculum.

The table's primary key, IGS_PE_PERS_UNT_EXCL_PK, is referenced by any dependent objects or application logic that must uniquely identify a unit exclusion record.