Search Results igs_pe_persenc_effct




Overview
Explore in AI Chat

Overview

The IGS_PE_PERSENC_EFFCT table is a core data entity within the Oracle E-Business Suite's now-obsolete Student System (IGS) module. It serves as the central repository for recording the specific administrative effects or sanctions imposed on a student as a consequence of an active encumbrance. An encumbrance is a formal restriction or hold placed on a student's record, often due to disciplinary, financial, or academic reasons. This table details the concrete manifestations of those restrictions, such as exclusions from specific courses, suppression of academic transcripts, or limitations on funding eligibility. Its primary role is to enforce and track the operational impact of encumbrances on a student's academic journey within the system.

Key Information Stored

The table's structure is designed to uniquely identify an effect within the context of a specific person and encumbrance. Its composite primary key is critical for this linkage. Key columns include the PERSON_ID, ENCUMBRANCE_TYPE, and PEN_START_DT, which together reference the parent encumbrance record in IGS_PE_PERS_ENCUMB. The S_ENCMB_EFFECT_TYPE defines the category of the effect (e.g., 'COURSE_EXCLUSION', 'TRANSCRIPT_SUPPRESSION'), linking to the IGS_EN_ENCMB_EFCTTYP table. The PEE_START_DT and SEQUENCE_NUMBER provide further granularity to manage multiple effects of the same type. Additional columns, such as RESTRICTED_ATTENDANCE_TYPE, store effect-specific parameters, linking to tables like IGS_EN_ATD_TYPE_ALL to define which attendance modes are restricted.

Common Use Cases and Queries

A primary use case is generating reports to audit active student sanctions or to validate business rules during academic processes like course enrollment or transcript generation. For instance, a process checking if a student can enroll in a course would query this table for active 'COURSE_EXCLUSION' effects. A common SQL pattern involves joining to the person and encumbrance tables to get a full context.

  • Sample Query: To find all active course exclusion effects for a student: SELECT * FROM IGS_PE_PERSENC_EFFCT pee JOIN IGS_PE_PERS_ENCUMB pen ON pee.person_id = pen.person_id AND pee.encumbrance_type = pen.encumbrance_type AND pee.pen_start_dt = pen.start_dt WHERE pee.person_id = :stu_id AND pee.s_encmb_effect_type = 'COURSE_EXCLUSION' AND SYSDATE BETWEEN pen.start_dt AND NVL(pen.expiry_dt, SYSDATE+1);
  • Administrative staff use this data to manage holds, while system batch jobs reference it to automatically enforce restrictions in related modules.

Related Objects

IGS_PE_PERSENC_EFFCT maintains extensive foreign key relationships, acting as a parent table for several specific exclusion subtypes and as a child to master definition tables. The documented relationships are:

These child tables store additional attributes specific to each effect type, creating a normalized model where IGS_PE_PERSENC_EFFCT holds the common header information.