Search Results igf_sl_dl_chg_fld_v

Overview

IGF_SL_DL_CHG_FLD_V is a reporting and integration view within the Oracle E-Business Suite Financial Aid (IGF) module. Its description in the ETRM metadata identifies it as presenting "Direct Loan change fields details." The view exposes configuration metadata that governs how Direct Loan change records are structured and interpreted, mapping internal change-field definitions to their user-facing lookup descriptions.

The object belongs to the IGF - Financial Aid product, which is flagged as Obsolete in the ETRM documentation. In release 12.1.1 and 12.2.2 the view is documented but "Not implemented in this database," meaning the underlying definition exists in the metadata repository while the compiled database object may not be present in a given environment. This distinction is important during impact analysis, upgrades, or when reconciling custom integrations against delivered objects. The view is read-only in nature: it joins configuration tables and surfaces descriptive attributes rather than supporting transactional inserts or updates. Its principal role is diagnostic and reference-oriented, allowing developers and functional analysts to confirm which Direct Loan fields are tracked for change, their code values, and whether those fields are enabled.

Underlying Base Objects

The view is defined over two documented sources. The first is the base table IGF_SL_DL_CHG_FLD, aliased CCHG, which stores the Direct Loan version, loan category, change code, field name, and field length definitions. The second is IGF_LOOKUPS_VIEW, aliased FNDS, an Oracle lookups view that supplies the translated meaning and enabled flag for each field. The join condition links CCHG.FLD_NAME to FNDS.LOOKUP_CODE and restricts FNDS.LOOKUP_TYPE to 'IGF_SL_LOAN_FIELDS'.

The view text is a straight inner join, so any change-field definition whose FLD_NAME does not resolve to an enabled or defined lookup of type IGF_SL_LOAN_FIELDS will not appear in the result set. The ETRM record notes no additional referenced base objects beyond these two. Because there is no documented FK to a version or category reference table in the view text, DL_VERSION and LOAN_CATG values are carried directly from the change-field table without further enrichment.

Key Columns

• DL_VERSION — Direct Loan version identifier associated with the change-field definition.
• LOAN_CATG — Loan category under which the change field applies.
• CHG_CODE — The change code, the primary search term associated with this view. It categorizes the type of Direct Loan change being defined.
• FLD_NAME — The internal field name; also the join key to the lookup table.
• FLD_LENGTH — Declared length of the field, useful for parsing or layout validation.
• DESCRIPTION — Lookup meaning (FNDS.MEANING), the user-facing label for the field.
• ENABLED — Lookup enabled flag (FNDS.ENABLED_FLAG), indicating whether the field is active.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard EBS who-columns for the change-field row.

Common Use Cases and Queries

Typical scenarios include auditing which change fields are enabled for a given loan category, validating field lengths before building an interface, and tracing a change code back to its descriptive meaning for reporting labels.

List all enabled change fields:

• SELECT CHG_CODE, FLD_NAME, DESCRIPTION, FLD_LENGTH FROM IGF_SL_DL_CHG_FLD_V WHERE ENABLED = 'Y';

Filter by a specific change code or version:

• SELECT DL_VERSION, LOAN_CATG, CHG_CODE, FLD_NAME FROM IGF_SL_DL_CHG_FLD_V WHERE CHG_CODE = :p_chg_code;
• SELECT DL_VERSION, CHG_CODE, FLD_NAME FROM IGF_SL_DL_CHG_FLD_V WHERE DL_VERSION = :p_version;

Because the product is obsolete and the object may not be implemented, queries should be guarded by checks against ALL_VIEWS or a try/catch pattern in integration code. Where the view is absent, equivalent logic can be reproduced by querying IGF_SL_DL_CHG_FLD joined to the lookups source on LOOKUP_TYPE = 'IGF_SL_LOAN_FIELDS'.