Search Results igf_sl_lender_brc_v

Overview

IGF_SL_LENDER_BRC_V is a reporting view within the Oracle E-Business Suite (EBS) Financial Aid module (IGF), a component of the broader Student Systems (IGS) product family. The Financial Aid module is documented as obsolete in ETRM metadata for EBS 12.1.1 and 12.2.2, meaning it is no longer actively maintained or shipped in current installations. The view is not implemented in the reference database and carries no documented owner or base object registration.

The view presents lender business record data associated with non-Title IV lending organizations. It combines rows from the lender business record table with party-level organisational details drawn from an institution organisation base view. Its purpose is to expose lender records joined with the party number and party name of the owning organisation, facilitating reporting on lender identity and status. Such a view would typically be consumed by concurrent programs, inbound interface processing, or ad hoc extraction logic within the Financial Aid landscape.

Underlying Base Objects

The view is defined over two documented objects referenced directly in its SQL text:

• IGF_SL_LENDER_BRC — the primary base table holding lender non-ED business record data. The view aliases this as LNDB and references its ROWID along with all principal business columns.
• IGS_OR_INST_ORG_BASE_V — an institution organisation base view aliased as ORG, which supplies PARTY_NUMBER and PARTY_NAME.

The join condition is LNDB.PARTY_ID = ORG.PARTY_ID(+), an outer join from the lender business record to the organisation base view. This preserves lender rows lacking a matching organisation party record, returning null for the party number and party name columns in such cases. The documented metadata lists no other referenced base objects.

Key Columns

The view exposes the following columns:

• ROW_ID — the ROWID of the underlying IGF_SL_LENDER_BRC row, useful for row identification and update targeting.
• LENDER_ID — identifier of the lender.
• LEND_NON_ED_BRC_ID — identifier for the non-Educational lender business record.
• DESCRIPTION — descriptive text for the lender business record.
• PARTY_ID — the trading party identifier linking the lender record to the organisation party.
• ENABLED — status flag indicating whether the record is active.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns tracking creation and modification.
• PARTY_NUMBER, PARTY_NAME — organisation party number and name from the joined base view.
• ORG_UNIT_CD, ORG_UNIT_CD_DESC — organisation unit code and description, documented as additional view columns.

Common Use Cases and Queries

Because the module is obsolete, use cases centre on historical data retrieval, migration, and audit reconciliation. A typical query lists enabled lenders with their organisation names:

• SELECT LENDER_ID, LEND_NON_ED_BRC_ID, DESCRIPTION, PARTY_NUMBER, PARTY_NAME FROM IGF_SL_LENDER_BRC_V WHERE ENABLED = 'Y';
• Identifying lender records with no matching organisation party: SELECT LENDER_ID, LEND_NON_ED_BRC_ID FROM IGF_SL_LENDER_BRC_V WHERE PARTY_ID IS NOT NULL AND PARTY_NUMBER IS NULL;
• Audit extraction filtering by modification date: SELECT LENDER_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGF_SL_LENDER_BRC_V WHERE LAST_UPDATE_DATE > SYSDATE - 30;
• Migrating lender reference data using ROW_ID for line-level traceability.

Given the obsolete status and absence of implementation in the documented database, administrators should verify object existence before dependency, as the view may not be present in all environments.