Search Results borw_lender_id




Overview
Explore in AI Chat

Overview

IGF_SL_LOR_DTLS_V is a reporting view historically shipped within the Oracle E-Business Suite Financial Aid (IGF) module. In the 12.1.1 and 12.2.2 releases it is classified as obsolete, and the ETRM repository documents no active implementation of the object in a current database. The view was designed to expose loan origination and disbursement detail — specifically the relationship between a student loan award and its corresponding loan origination record — in a single flattened row for downstream reporting and integration consumption.

Functionally, IGF_SL_LOR_DTLS_V joins award-level loan data to loan origination data, presenting borrower determination, promissory note life cycle, credit decision, and loan period attributes side by side. Because the underlying Federal Family Education Loan (FFEL) processing has been retired from the product line, the view persists only as a legacy artifact; any EBS instance upgraded from an earlier release may still carry the compiled definition even though no runtime process references it.

Underlying Base Objects

The ETRM metadata records no referenced base objects for this view, which is consistent with its obsolete status — the underlying tables were removed from the shipped schema before the 12.2.2 documentation baseline was captured. The embedded view text, however, shows the view was defined over at least two source relations:

  • An award view (aliased AWDV), supplying BASE_ID, AWARD_ID, STUDENT_ID, FUND_ID, calendar and fund attributes, and offered/accepted amounts.
  • A loan origination record table (aliased LOR), supplying ORIGINATION_ID, school certification date, origination batch and acknowledgement data, credit decision fields, promissory note attributes, and serial loan codes.
  • A loan award record table (aliased LAR), supplying LOAN_ID, LOAN_NUMBER, loan period dates, loan status history, ACTIVE flags, borrower determination code, and the join key to LAR.ROW_ID.
  • A lookup view (aliased LKV), joined to translate BORW_DETRM_CODE into a descriptive MEANING.

The view therefore sits one level above the transactional loan tables, materializing a denormalized picture that would otherwise require at least a four-way join.

Key Columns

Common Use Cases and Queries

Because the view is documented as obsolete and not implemented, it should not be used in new development. Historical reporting extracts that reference it — typically for FFEL origination reconciliations, promissory note tracking, and borrower determination audits — may still be encountered during upgrades or data migrations.

A representative query pattern is shown below; it assumes the view exists in the target schema.

  • Loan detail by student: SELECT STUDENT_ID, LOAN_TYPE, LOAN_AMT_ACCEPTED, LOAN_STATUS FROM IGF_SL_LOR_DTLS_V WHERE STUDENT_ID = :student_id AND ACTIVE = 'Y';
  • Origination reconciliation: SELECT LOAN_NUMBER, ORIGINATION_ID, ORIG_BATCH_ID, ORIG_ACK_DATE FROM IGF_SL_LOR_DTLS_V WHERE ORIG_BATCH_DATE BETWEEN :start_date AND :end_date ORDER BY ORIG_BATCH_DATE;
  • Borrower determination audit: SELECT LOAN_ID, BORW_DETRM_CODE, BORW_DETRM, CREDIT_DECISION_DATE FROM IGF_SL_LOR_DTLS_V WHERE BORW_DETRM_CODE IS NOT NULL;
  • Promissory note status: SELECT LOAN_NUMBER, PNOTE_STATUS, PNOTE_ACCEPT_AMT, PNOTE_ACCEPT_DATE, PNOTE_MPN_IND FROM IGF_SL_LOR_DTLS_V WHERE PNOTE_STATUS IS NOT NULL;

For 12.1.1 and 12.2.2 environments, the recommended practice is to confirm whether the object is still deployed before depending on it, and to translate any legacy queries against IGF_SL_LOR_DTLS_V into equivalent joins on the surviving loan award, origination, and lookup tables, or into the replacement Financial Aid data model provided by current releases.