Search Results clprl_id




Overview
Explore in AI Chat

Overview

The table IGF_SL_CL_PREF_LENDERS is a setup and assignment table within the obsolete Oracle E-Business Suite Financial Aid module (IGF). Its specific role is to manage the assignment of preferred lenders for the Federal Family Education Loan Program (FFELP), a U.S. federal student loan program that was discontinued in 2010. The table functions as a central repository linking institutional financial aid recipients (students) with specific lender organizations designated as "preferred" by the educational institution. This setup data would have been critical for automating and guiding the loan origination process within the system for FFELP loans.

Key Information Stored

While the full column list is not provided in the excerpt, the documented primary and foreign keys reveal the core data structure. The primary key, CLPRL_ID, is a unique identifier for each preferred lender assignment record. The table stores the identifier (PERSON_ID) for the aid recipient, which is linked to the Trading Community Architecture's HZ_PARTIES table to access the full party details. It also stores a RELATIONSHIP_CD, linked to the IGF_SL_CL_RECIPIENT table, which defines the specific context or relationship under which this lender preference is applicable for that recipient. Additional columns, not detailed in the metadata, would typically include effective dates, lender sequence or priority, and creation/modification audit information.

Common Use Cases and Queries

As this table pertains to an obsolete loan program, its operational use in current implementations is minimal. Historically, its primary use case was to determine and list the preferred lender(s) for a given student during the packaging of FFELP loans. A typical query would join student and lender information. For reporting or validation, a query might check assignments for a specific lender or recipient.

Sample Query Pattern:
SELECT hzp.party_name AS student_name,
hzl.party_name AS lender_name,
pref.relationship_cd, pref.clprl_id
FROM igf_sl_cl_pref_lenders pref,
hz_parties hzp,
hz_parties hzl
WHERE pref.person_id = hzp.party_id
AND pref.lender_party_id = hzl.party_id -- (inferred common column)
AND pref.person_id = :stu_party_id;

Related Objects

The table maintains defined relationships with several key EBS objects, as per the provided metadata:

  • Primary Key: IGF_SL_CL_PREF_LENDERS_PK on column CLPRL_ID.
  • Foreign Keys (Outgoing):
    • References HZ_PARTIES via the PERSON_ID column to identify the financial aid recipient (student).
    • References IGF_SL_CL_RECIPIENT via the RELATIONSHIP_CD column to define the recipient relationship context.
  • Foreign Key (Incoming):
    • Referenced by IGF_AP_TD_ITEM_INST_ALL via its CLPRL_ID column. This indicates that transactional award or disbursement item detail records stored the preferred lender assignment ID that was used for that specific transaction, creating an audit trail from setup to execution.