Search Results igs_pe_unt_set_excl_pk

Overview

The IGS_PE_UNT_SET_EXCL table is a data entity within the Oracle E-Business Suite (EBS) Student System (IGS), which is documented as obsolete. It serves as a junction table that formally records the specific unit sets from which a student has been excluded as a direct consequence of an encumbrance effect placed upon their academic record. An encumbrance is a type of administrative hold or restriction. This table establishes a critical link between a student's active encumbrance effects and the defined academic unit sets (like majors or minors) in the system, explicitly capturing the exclusion relationship. Its role is to enforce academic policy by preventing enrollment in prohibited unit sets while an encumbrance is active.

Key Information Stored

The table's composite primary key uniquely identifies each exclusion record by combining identifiers from the student's encumbrance effect and the targeted unit set. Key columns include PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT (the parent encumbrance start date), S_ENCMB_EFFECT_TYPE, PEE_START_DT, and PEE_SEQUENCE_NUMBER, which together uniquely reference the specific encumbrance effect from the IGS_PE_PERSENC_EFFCT table. The UNIT_SET_CD and US_VERSION_NUMBER identify the exact version of the academic unit set from which the student is excluded. The PUSE_START_DT (presumably "Person Unit Set Exclusion Start Date") is part of the primary key, likely indicating the effective date of the exclusion itself.

Common Use Cases and Queries

This table is primarily used in scenarios involving student academic standing and enrollment eligibility. A common operational report would list all students currently excluded from specific unit sets due to active encumbrances, used by academic advisors or registry staff. A typical query would join IGS_PE_UNT_SET_EXCL to IGS_PE_PERSENC_EFFCT and IGS_EN_UNIT_SET_ALL to get student and unit set details. For example, to find exclusions related to a specific encumbrance effect for a student, one might query using the key columns referenced by the user: PEE_START_DT, PERSON_ID, ENCUMBRANCE_TYPE, and PEN_START_DT. The data is also critical for real-time validation during course enrollment to block registration attempts into excluded unit sets.

Related Objects

The table's integrity is maintained through defined foreign key relationships, as documented in the ETRM metadata. It is a child table with two primary parent entities:

• IGS_PE_PERSENC_EFFCT (Person Encumbrance Effect): This is the core parent table. IGS_PE_UNT_SET_EXCL references it via a composite foreign key on the columns PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, and PEE_SEQUENCE_NUMBER. This ensures every exclusion is tied to a valid, existing encumbrance effect.
• IGS_EN_UNIT_SET_ALL (Unit Set Definition): This table stores the master list of all academic unit sets. IGS_PE_UNT_SET_EXCL references it via the columns UNIT_SET_CD and US_VERSION_NUMBER, ensuring the exclusion points to a valid and version-controlled unit set.

These relationships are fundamental for any reporting or data integrity processes involving student academic restrictions.