Search Results igs_fi_enc_dflt_eft

Overview

The IGS_FI_ENC_DFLT_EFT table is a core data structure within the Oracle E-Business Suite's now-obsolete Student System (IGS). Its primary function is to define the standard financial or administrative consequences, known as "effects," that are automatically associated with a specific type of student encumbrance. An encumbrance is a hold or restriction placed on a student's record, often related to financial obligations or administrative requirements. This table serves as a configuration or setup entity, establishing the default linkage between an encumbrance type and its intended outcomes, thereby enforcing institutional policy within the student lifecycle management modules. It is critical to note that the provided metadata explicitly states this object is "Not implemented in this database," indicating it may be a reference or legacy structure in the documented environment.

Key Information Stored

The table stores a simple but critical mapping. Its structure is defined by a composite primary key, meaning each unique record is identified by the combination of two columns. The first key column, ENCUMBRANCE_TYPE, stores the code or identifier for a specific category of hold, as defined in the IGS_FI_ENCMB_TYPE_ALL table. The second key column, S_ENCMB_EFFECT_TYPE, stores the code for the type of effect or action that the encumbrance imposes, such as preventing registration or transcript release, which is validated against the IGS_EN_ENCMB_EFCTTYP table. Together, these columns form a definitive rule stating that for a given encumbrance type, a specific default effect is to be applied.

Common Use Cases and Queries

The primary use case for this table is administrative setup and inquiry. System administrators would query or maintain this table to define or audit the business rules governing student encumbrances. A common reporting need would be to generate a list of all default effects configured in the system. A typical query would join to the referenced tables to retrieve descriptive names instead of codes.

Sample Query:
SELECT eft.encumbrance_type,
typ.encumbrance_type_name,
eft.s_encmb_effect_type,
eff.encumbrance_effect_type_name
FROM igs_fi_enc_dflt_eft eft,
igs_fi_encmb_type_all typ,
igs_en_encmb_efcttyp eff
WHERE eft.encumbrance_type = typ.encumbrance_type
AND eft.s_encmb_effect_type = eff.encumbrance_effect_type
ORDER BY 1, 3;

Related Objects

The IGS_FI_ENC_DFLT_EFT table maintains defined foreign key relationships with two other setup tables in the Student System, ensuring data integrity.

• IGS_FI_ENCMB_TYPE_ALL: This relationship validates the ENCUMBRANCE_TYPE column. Each encumbrance type code in IGS_FI_ENC_DFLT_EFT must exist as a valid type in the IGS_FI_ENCMB_TYPE_ALL table.
• IGS_EN_ENCMB_EFCTTYP: This relationship validates the S_ENCMB_EFFECT_TYPE column. Each effect type code must correspond to a predefined effect in the IGS_EN_ENCMB_EFCTTYP lookup table.

These relationships ensure that default encumbrance effects can only be configured for valid, existing encumbrance and effect types.