Search Results igs_pe_unt_set_excl_u1




Overview
Explore in AI Chat

Overview

The IGS_PE_UNT_SET_EXCL table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Student System (IGS) module. It serves a critical regulatory function by recording instances where a student is formally excluded from a specific unit set (a defined program or course of study). This exclusion is typically a consequence of an institutional hold or encumbrance placed on the student's record. The table acts as a junction, linking a student's person encumbrance effect to a particular unit set, thereby enforcing academic and administrative policies that restrict a student's enrollment in certain programs based on defined hold conditions.

Key Information Stored

The table stores the effective period of the exclusion and its relationship to the underlying administrative action. Key columns include the identifiers for the student (PERSON_ID), the specific hold effect (S_ENCMB_EFFECT_TYPE, PEE_START_DT, PEE_SEQUENCE_NUMBER), and the targeted unit set (UNIT_SET_CD, US_VERSION_NUMBER). The temporal attributes defining the exclusion period are paramount: PUSE_START_DT marks the date the exclusion becomes effective, and EXPIRY_DT indicates when it ceases to be in force. The table's unique primary key is a composite of nine columns, ensuring a precise one-to-one link between a hold effect instance and a unit set exclusion instance.

Common Use Cases and Queries

Primary use cases involve compliance reporting, audit trails, and process automation within student administration. Common operational queries include identifying all active unit set exclusions for a student to enforce enrollment restrictions, or generating lists of students excluded from a specific program for departmental review. A sample query to find active exclusions for a given unit set would leverage the PUSE_START_DT and EXPIRY_DT columns:

  • SELECT person_id, puse_start_dt, expiry_dt FROM igs.igs_pe_unt_set_excl WHERE unit_set_cd = '&unit_set_code' AND SYSDATE BETWEEN puse_start_dt AND NVL(expiry_dt, SYSDATE+1);

Another critical pattern is joining this table to person and encumbrance tables to produce holistic student hold reports, clearly showing which academic programs are impacted by specific disciplinary or financial holds.

Related Objects

The IGS_PE_UNT_SET_EXCL table is centrally linked to two primary entities via foreign key constraints, forming a critical part of the Student System's data model.

  • IGS_PE_PERSENC_EFFCT: The foreign key from PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, and PEE_SEQUENCE_NUMBER references this table, which details the specific hold effects applied to a person. This relationship ensures every unit set exclusion is tied to a valid administrative action.
  • IGS_EN_UNIT_SET_ALL: The foreign key from UNIT_SET_CD references this table, which defines the master list of academic unit sets. This ensures exclusions are only recorded against valid, defined programs.

The table's primary key, IGS_PE_UNT_SET_EXCL_PK, is enforced by the unique index IGS_PE_UNT_SET_EXCL_U1.