Results for “igs_fi_enc_dflt_eft”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_FI_ENC_DFLT_EFT is a configuration table within the Oracle E-Business Suite IGS (Student System) module. It describes the default effects that are applied to an associated encumbrance type. In practical terms, the table stores the mapping between an encumbrance type defined in the financial aid or student financials encumbrance framework and the effect type that should be applied by default when that encumbrance is processed.

This object belongs to the IGS product, which Oracle classifies as obsolete in release 12.1.1 and 12.2.2. The ETRM metadata explicitly records "Not implemented in this database," meaning the table is not instantiated in the delivered Oracle EBS schema and should be regarded as documentation-only or legacy reference information rather than a live repository object.

From a Data Vault modeling perspective, the metadata's heuristic classification is link. This reflects the table's structural role: it resolves a many-to-many association between an encumbrance type and an encumbrance effect type. Adopting that suggestion, IGS_FI_ENC_DFLT_EFT functions as a link entity, with the two foreign key columns acting as the composite business key.

Key Information Stored

The documented physical schema contains eight columns. The most significant are the following:

• ENCUMBRANCE_TYPE — Identifies the encumbrance type to which a default effect applies. It is a foreign key to IGS_FI_ENCMB_TYPE_ALL and forms part of the composite primary key.
• S_ENCMB_EFFECT_TYPE — Identifies the encumbrance effect type applied by default. It is a foreign key to IGS_EN_ENCMB_EFCTTYP and forms the second component of the composite primary key.
• COMMENTS — Free-form descriptive text documenting the default effect or the rationale for the mapping.
• CREATED_BY, CREATION_DATE — Standard WHO audit columns recording the creating user and creation timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent modifying user, update timestamp, and login session.

The primary key is defined as IGS_FI_ENC_DFLT_EFT_PK over (ENCUMBRANCE_TYPE, S_ENCMB_EFFECT_TYPE). A unique index, IGS_FI_ENC_DFLT_EFT_U1, covers the same two columns, confirming them as the business-key candidate. No separate surrogate key column is documented; the composite natural key serves as the identifier.

Common Use Cases and Queries

The table supports configuration validation and reporting on encumbrance default behaviors. Typical queries resolve the descriptive names behind the numeric foreign keys:

• Listing all default effects for a given encumbrance type.
• Confirming that a specific encumbrance type / effect type pairing exists before an encumbrance is created.
• Auditing recent configuration changes using LAST_UPDATE_DATE and LAST_UPDATED_BY.

A representative join pattern follows:

• SELECT e.encumbrance_type, t.description, e.s_encmb_effect_type, f.description FROM igs_fi_enc_dflt_eft e, igs_fi_encmb_type_all t, igs_en_encmb_efcttyp f WHERE e.encumbrance_type = t.encumbrance_type AND e.s_encmb_effect_type = f.s_encmb_effect_type;

Because the object is not implemented in the delivered database, these queries serve documented reference purposes and may require custom creation in legacy or upgraded environments.

Related Objects

• IGS_FI_ENCMB_TYPE_ALL — Referenced by ENCUMBRANCE_TYPE; the parent encumbrance-type definition table.
• IGS_EN_ENCMB_EFCTTYP — Referenced by S_ENCMB_EFFECT_TYPE; the encumbrance effect-type definition table.
• IGS_FI_ENC_DFLT_EFT_PK — The primary key constraint over (ENCUMBRANCE_TYPE, S_ENCMB_EFFECT_TYPE).
• IGS_FI_ENC_DFLT_EFT_U1 — The unique index enforcing the composite business key.

These relationships establish the table as a dependent configuration link within the IGS encumbrance sub-model, joining the encumbrance-type and effect-type entities that it bridges.