Search Results igs_fi_enc_dflt_eft_u1

Overview

The IGS_FI_ENC_DFLT_EFT table is a core configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. It serves a critical role in the financial aid and student accounting modules by defining the default system-level effects associated with institution-defined encumbrance (or hold) types. An encumbrance type is a user-defined hold that can be placed on a student's record, preventing actions like registration or transcript release. This table maps each custom encumbrance type to one or more predefined system effect types (e.g., prevent enrollment, prevent graduation), thereby determining the specific functional restrictions the hold will enforce. It acts as the master repository for these default relationships, ensuring consistent application of business rules across the student lifecycle.

Key Information Stored

The table stores the mapping between an institution's hold types and the system effects they trigger. The primary columns are:

• ENCUMBRANCE_TYPE (VARCHAR2(10)): The code for an institution-defined hold type. This is a key linking to the master definition of the hold.
• S_ENCMB_EFFECT_TYPE (VARCHAR2(10)): A code representing a system-defined hold effect type. This column is central to the user's search context. Each encumbrance type must be linked to one or more effect types from a controlled list, and effects are grouped by level (e.g., enrollment-level, graduation-level).
• COMMENTS (VARCHAR2(2000)): A descriptive field for administrative notes regarding the specific default effect mapping.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns tracking the creation and last update of each record.

The unique constraint (IGS_FI_ENC_DFLT_EFT_U1) on the combination of ENCUMBRANCE_TYPE and S_ENCMB_EFFECT_TYPE ensures that a specific effect type cannot be assigned as a default to the same hold type more than once.

Common Use Cases and Queries

This table is primarily used for setup, reporting, and troubleshooting within Student Financials. A common administrative task is to review or modify the default effects for all institutional hold types. The following query pattern, derived from the ETRM documentation, is fundamental for extracting this mapping:

SELECT ENCUMBRANCE_TYPE, S_ENCMB_EFFECT_TYPE, COMMENTS FROM IGS.IGS_FI_ENC_DFLT_EFT ORDER BY ENCUMBRANCE_TYPE, S_ENCMB_EFFECT_TYPE;

To investigate why a particular hold type is enforcing a specific restriction, one would join this table to the master hold type definition. Conversely, to identify all hold types that apply a specific system effect (e.g., 'ENROLL_BLOCK'), a query filtering on the S_ENCMB_EFFECT_TYPE column would be used. This data is critical for generating compliance reports that document the business rules governing student holds and for validating setup during implementation or upgrade projects.

Related Objects

Based on the provided dependency information, the IGS_FI_ENC_DFLT_EFT table is referenced by objects within the APPS schema. While the specific foreign key relationships are not detailed in the excerpt, logical and functional relationships are evident. The ENCUMBRANCE_TYPE column would typically have a foreign key relationship to a master table defining institutional encumbrance types (e.g., a table like IGS_FI_ENCUMBRANCE_TYPES). The S_ENCMB_EFFECT_TYPE column's values are drawn from a system-defined lookup, such as a view based on FND_LOOKUP_VALUES. The table's design suggests it is a junction table resolving a many-to-many relationship between hold types and their default system effects, making it a key reference point for any process or form that applies or evaluates holds against student records.