Search Results igs_pe_pers_encumb




Overview
Explore in AI Chat

Overview

The IGS_PE_PERS_ENCUMB table is a core data object within the now-obsolete Oracle Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for recording administrative or financial holds, known as encumbrances, placed on an applicant or student. These encumbrances act as restrictions that can prevent a student from performing critical academic activities, such as enrolling in classes, receiving transcripts, or graduating, until the underlying issue is resolved. The table's design captures the type of hold, its effective period, and its association with a specific academic calendar instance, providing a structured audit trail of student restrictions.

Key Information Stored

The table's structure is designed to uniquely identify and describe an active encumbrance. The primary key is a composite of PERSON_ID, ENCUMBRANCE_TYPE, and START_DT, ensuring a student cannot have the same type of encumbrance effective from the same date more than once. Key columns include PERSON_ID, which links to the student or applicant record; ENCUMBRANCE_TYPE, a foreign key to IGS_FI_ENCMB_TYPE_ALL defining the nature of the hold (e.g., library fine, tuition arrears); and START_DT, marking when the encumbrance takes effect. Important supporting columns are END_DT (for when the hold is lifted), CAL_TYPE and SEQUENCE_NUMBER (linking to the academic calendar term in IGS_CA_INST_ALL), and SPO_COURSE_CD/SPO_SEQUENCE_NUMBER for associating the hold with a specific student program attempt.

Common Use Cases and Queries

The primary use case is managing student eligibility for academic processes. A common operational report would list all active encumbrances for students in a given term to inform registration or graduation clearance. A typical query would join to person and encumbrance type tables for descriptive information. For example, to find students blocked from course enrollment due to financial holds, one might query for encumbrances where the type indicates a fee payment issue and the END_DT is null or in the future, and the term matches the current enrollment period. While direct data manipulation via custom SQL is discouraged in favor of official APIs, reporting and data extraction from this table were critical for student services, bursar, and registrar offices to identify and resolve student holds efficiently.

Related Objects

  • IGS_FI_ENCMB_TYPE_ALL: Provides the valid codes and descriptions for the ENCUMBRANCE_TYPE column.
  • IGS_PE_PERSENC_EFFCT: A child table that likely records the specific academic activities (effects) blocked by a given encumbrance record in IGS_PE_PERS_ENCUMB.
  • IGS_PR_STDNT_PR_OU_ALL: The student program attempt table, to which the encumbrance can be specifically linked via foreign key columns.
  • IGS_CA_INST_ALL: The calendar instance table, defining the academic term during which the encumbrance is active.
  • IGS_AZ_STUDENTS: References this table, indicating its use in the context of student advising holds.