Search Results igs_fi_encmb_type_all




Overview
Explore in AI Chat

Overview

The table IGS_FI_ENCMB_TYPE_ALL is a core data dictionary table within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary role is to define and store the institution-specific types of encumbrances or holds that can be applied to a person, typically a student. An encumbrance is a restriction placed on a student's account that may prevent them from performing certain actions, such as registering for classes or receiving transcripts, until the underlying issue is resolved. The table serves as the master source for all user-defined encumbrance categories, enabling the systematic application and management of holds across the student lifecycle. It is important to note that the metadata explicitly classifies the IGS - Student System as "Obsolete," indicating this table is part of a legacy module.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's structure is centered around defining the characteristics of an encumbrance type. The primary key column, ENCUMBRANCE_TYPE, is the unique code identifying each type of hold (e.g., 'UNPAID_FEES', 'ACAD_PROBATION'). Based on standard EBS design patterns for "ALL" tables and the table's purpose, it is highly likely to also contain columns such as a description field (e.g., ENCUMBRANCE_DESC), an effective date range (START_DATE, END_DATE), an ORG_ID for multi-organization support, and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing. The table's description confirms it stores types for both financial (unpaid fees) and academic (failed progression check) encumbrances.

Common Use Cases and Queries

The primary use case is the lookup and validation of encumbrance types when applying a hold to a student's record or when running reports on student restrictions. Administrators would reference this table to maintain the list of active hold types. A common reporting query would join this table to the person-level encumbrance table to generate a list of all students under a specific type of hold. For example:

  • Listing All Active Encumbrance Types: SELECT encumbrance_type, description FROM igs_fi_encmb_type_all WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE) ORDER BY 1;
  • Finding Students with a Financial Hold: SELECT p.person_id, p.encumbrance_type, t.description FROM igs_pe_pers_encumb p, igs_fi_encmb_type_all t WHERE p.encumbrance_type = t.encumbrance_type AND t.encumbrance_type = 'UNPAID_FEES';

Related Objects

The table IGS_FI_ENCMB_TYPE_ALL is a referenced parent table in several key transactional and setup tables within the Student System, as documented by its foreign key relationships. These relationships ensure data integrity by enforcing that encumbrances applied throughout the system must be of a type defined in this master table.

  • IGS_FI_ENC_DFLT_EFT: Links via ENCUMBRANCE_TYPE to define default Electronic Funds Transfer settings for a specific encumbrance type.
  • IGS_FI_HOLD_PLAN: Links via HOLD_TYPE to associate an encumbrance type with a financial hold plan.
  • IGS_FI_PERSON_HOLDS: Links via HOLD_TYPE to apply a specific encumbrance type to a person's financial account.
  • IGS_PE_HOLD_REL_OVR: Links via HOLD_TYPE to define rule overrides for releasing a specific type of hold.
  • IGS_PE_PERS_ENCUMB: The central transactional table; links via ENCUMBRANCE_TYPE to record the actual application of an encumbrance type to a person.
  • IGS_PR_OU_TYPE_ALL: Links via ENCUMBRANCE_TYPE to define which encumbrance types are applicable to specific progression outcome types.