Results for “igf_sl_lender”

50+ results




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

Overview

IGF_SL_LENDER is a reference (setup) table in the Oracle E-Business Suite Financial Aid module (IGF), owned by the IGF schema. It stores the master list of lender codes and their descriptions used throughout the student loan processing lifecycle. Within Oracle EBS 12.1.1 and 12.2.2, this table functions as the authoritative registry from which downstream loan origination, disbursement, and reconciliation processes derive valid lender identifiers. Records in IGF_SL_LENDER are maintained as part of Financial Aid setup and are referenced by a broad set of transactional and setup tables across the IGF schema.

From a Data Vault modeling perspective, the mined foreign-key structure suggests that IGF_SL_LENDER is hub-leaning. Its role as a durable, slowly changing business entity keyed on LENDER_ID, with many dependent tables pointing back to it, is characteristic of a hub that anchors lender-related links and satellites. This classification is a heuristic observation based on the FK topology rather than a declared architectural attribute.

Key Information Stored

The table contains 10 documented columns. The most consequential are:

  • LENDER_ID — The surrogate primary key (IGF_SL_LENDER_PK) that uniquely identifies each lender record and serves as the join target for all dependent tables.
  • PARTY_ID — A unique business-key candidate enforced by the IGF_SL_LENDER_U1 unique index. This links the lender to a trading partner or party record, enabling integration with party-based data models.
  • DESCRIPTION — The human-readable lender name or code description displayed in forms and reports.
  • DUNS_LENDER_ID — The lender's Data Universal Numbering System identifier, used for external identification and common loan-industry reporting.
  • ENABLED — A status flag controlling whether the lender is available for selection in loan processing.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit and concurrency columns managed by the WHO columns framework.

The surrogate key (LENDER_ID) is distinct from the business-key candidate (PARTY_ID); both must be treated as meaningful identifiers.

Common Use Cases and Queries

Typical scenarios include lender validation during loan setup, reporting of active lenders, and joining lender details onto disbursement or reconciliation data. A common pattern retrieves enabled lenders:

SELECT LENDER_ID, DESCRIPTION, DUNS_LENDER_ID FROM IGF.IGF_SL_LENDER WHERE ENABLED = 'Y';

To resolve a lender by party:

SELECT LENDER_ID, DESCRIPTION FROM IGF.IGF_SL_LENDER WHERE PARTY_ID = :party_id;

Reporting queries frequently join IGF_SL_LENDER to disbursement or recipient tables to attach lender names to loan activity, for example joining IGF_SL_CL_RECIPIENT.LENDER_ID = IGF_SL_LENDER.LENDER_ID. The ENABLED flag is routinely filtered to exclude inactive lenders from selection lists.

Related Objects

Numerous IGF objects reference IGF_SL_LENDER through LENDER_ID foreign keys. The most significant include:

These relationships confirm IGF_SL_LENDER's central position as the lender hub within the Financial Aid data model.