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:
- IGF_SL_LENDER_BRC — references IGF_SL_LENDER.LENDER_ID, holding lender-borrower related configuration.
- IGF_SL_CL_RECIPIENT — links recipients to their lender via LENDER_ID.
- IGF_SL_LOR_ALL — loan origination records referencing the lender.
- IGF_SL_LOR_LOC_ALL and IGF_SL_LOR_LOC_HISTORY — lender origination location data and its history.
- IGF_SL_CL_SETUP_ALL and IGF_SL_CL_RESP_R1_ALL — loan setup and responsibility configuration referencing lenders.
- IGF_DB_CL_DISB_RESP_ALL — disbursement responsibility records joined by LENDER_ID.
These relationships confirm IGF_SL_LENDER's central position as the lender hub within the Financial Aid data model.
-
Contains lender codes and descriptions
-
SYNONYM: APPS.IGF_SL_LENDER 12.1.1
-
TABLE: IGF.IGF_SL_LENDER 12.1.1
-
Table: IGF_SL_LENDER 12.2.2
Contains lender codes and descriptions
Not implemented in this database·Explore IGF module →
-
View: IGF_SL_RECIPIENT_ALL_V 12.1.1
APPS.IGF_SL_RECIPIENT_ALL_V·↳ IGF_SL_GUARANTOR·↳ IGF_SL_LENDER·↳ IGF_SL_LENDER_BRC·Explore IGF module →
-
View: IGF_SL_LENDER_V 12.1.1
APPS.IGF_SL_LENDER_V·↳ IGF_SL_LENDER·↳ IGS_OR_INST_ORG_BASE_V·Explore IGF module →
-
View: IGF_SL_CL_RECIPIENT_V 12.1.1
APPS.IGF_SL_CL_RECIPIENT_V·↳ IGF_SL_CL_RECIPIENT·↳ IGF_SL_GUARANTOR·↳ IGF_SL_LENDER·Explore IGF module →
-
VIEW: APPS.IGF_SL_LENDER_V 12.1.1
-
Table: IGF_SL_LENDER_BRC 12.2.2
Contains lender non-ED branch codes and descriptions
Not implemented in this database·Explore IGF module →
-
View: IGF_SL_LENDER_V 12.2.2
Not implemented in this database·Explore IGF module →
-
Table: IGF_SL_CL_RECIPIENT 12.2.2
Maintains the relationships between the lenders, guarantors, and recipients
Not implemented in this database·Explore IGF module →
-
View: IGF_SL_RECIPIENT_ALL_V 12.2.2
Not implemented in this database·Explore IGF module →
-
View: IGF_SL_CL_RECIPIENT_V 12.2.2
Not implemented in this database·Explore IGF module →
-
Contains lender non-ED branch codes and descriptions
-
VIEW: APPS.IGF_SL_LENDER_V 12.1.1
-
Maintains the relationships between the lenders, guarantors, and recipients
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
PACKAGE: APPS.IGF_SL_CL_ORIG 12.1.1
-
12.1.1 DBA Data 12.1.1
-
Maintains the setup or default information for CommonLine, or FFELP, loans
-
Stores all the records received through the disbursement roster file
-
Maintains the CommonLine response from external processor
-
Contains origination details of loan application records
-
Loans History Table. This table stores the information that is sent out to external agencies for processing
-
Contains all the loan data for each loan at the time of origination/origination changes were sent. This always reflects the data currently in the Loan Origination Center.
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program