Search Results lend_brc_description

Overview

IGF_SL_CL_RECIPIENT_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, associated with the Financial Aid / Student Loan (IGF) module — historically delivered as part of the Oracle Student System / Financial Aid subsystem. The view presents a denormalized, human-readable projection of recipient relationship records held in IGF_SL_CL_RECIPIENT, enriching each row with descriptive text for the lender, the lender branch, the guarantor, and the recipient. It serves as a curated access layer that shields reports, concurrent programs, and downstream integrations from the need to perform their own joins across the underlying lender, guarantor, and recipient entities.

The view is particularly relevant to users searching on the derived column lend_description, which exposes the descriptive name of the lender associated with each recipient relationship. Rather than exposing only numeric identifiers, the view surfaces the lender description alongside corresponding branch, guarantor, and recipient descriptions, making it well suited to output that must be intelligible to end users.

Underlying Base Objects

Based on the documented view text, IGF_SL_CL_RECIPIENT_V is defined over the following objects:

• IGF_SL_CL_RECIPIENT (aliased rcpt) — the driving table, holding the recipient relationship rows.
• IGF_SL_LENDER (aliased lnd) — joined on rcpt.lender_id = lnd.lender_id, supplying lnd.description as LEND_DESCRIPTION.
• IGF_SL_LENDER_BRC (aliased lndb) — an outer-joined branch table, matched on lender_id and on the NVL-normalized lend_non_ed_brc_id, supplying LEND_BRC_DESCRIPTION.
• IGF_SL_GUARANTOR (aliased guarn) — joined on rcpt.guarantor_id = guarn.guarantor_id, supplying GUARN_DESCRIPTION.
• IGF_SL_RECIPIENT_ALL_V (aliased rcpv) — a recipient view joined on recipient_id, recipient_type, and the NVL-normalized recip_non_ed_brc_id, supplying RECIP_DESCRIPTION and RECIP_BRC_DESCRIPTION.

The use of NVL with a wildcard ('*') in the branch joins allows rows without a specific branch identifier to fall through to the branch-less record, while the outer join on the lender branch table permits recipient rows that have no matching branch.

Key Columns

• ROW_ID — the ROWID of the underlying IGF_SL_CL_RECIPIENT row, useful for row-level addressing.
• RCPT_ID — primary key of the recipient relationship record.
• LENDER_ID / LEND_DESCRIPTION — lender identifier and its description; LEND_DESCRIPTION is the derived lender name.
• LEND_NON_ED_BRC_ID / LEND_BRC_DESCRIPTION — non-ED lender branch identifier and description.
• GUARANTOR_ID / GUARN_DESCRIPTION — guarantor identifier and description.
• RECIPIENT_ID / RECIP_DESCRIPTION / RECIPIENT_TYPE — recipient identity and classification.
• RECIP_NON_ED_BRC_ID / RECIP_BRC_DESCRIPTION — recipient branch information.
• DUNS_LENDER_ID, DUNS_GUARNT_ID, DUNS_RCPT_ID — placeholders returned as NULL, likely reserved for DUNS-number integration.
• ENABLED, PREFERRED_FLAG, RELATIONSHIP_CD, RELATIONSHIP_CD_DESC — status, preference, and relationship attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical usage includes recipient relationship reports that must display descriptive names rather than internal identifiers, and integration extracts that feed downstream lending or servicing systems. A representative query listing enabled recipient relationships for a specific lender follows:

• SELECT rcpt_id, lender_id, lend_description, guarantor_id, guarn_description, recipient_id, recip_description
• FROM apps.igf_sl_cl_recipient_v
• WHERE lender_id = :p_lender_id AND enabled = 'Y';

Analysts may also filter or group by recip_description or lend_brc_description to produce branch-level breakdowns, and use relationship_cd_desc to categorize recipients by relationship type. Because the view encapsulates the multi-table join logic, reports remain stable even as branch and recipient view definitions evolve.