Search Results igf_sl_lor_v




Overview
Explore in AI Chat

Overview

IGF_SL_LOR_V is a validity-verified database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGF (Financial Aid) product family and associated with the Student Loan processing module. In the EBS 12.1.1 and 12.2.2 releases, the view serves as a consolidated reporting and integration layer for loan origination records, exposing the relationship between a borrower's loan origination activity, the underlying award, the fund setup, and the lender or guarantor recipient information. The view is not a base table and therefore holds no data of its own; it is a read-only projection constructed to simplify queries against the highly normalized loan origination records used by financial aid administrators, third-party servicers, and the Common Origination and Disbursement (COD) integration processes. Because the view joins the loan origination record (LOR) to award, fund master, calendar, and recipient data in a single row, it is particularly useful where downstream reporting requires a denormalized picture of a loan's status across its lifecycle.

Underlying Base Objects

The documented view text reveals that IGF_SL_LOR_V is defined over several base objects rather than a single table. The primary driver is the loan origination record table referenced by the alias LOR, which supplies origination-specific attributes such as origination status, batch details, promissory note status, guarantee amounts, and lender approval codes. The alias LAR refers to the loan award record, contributing the loan identifier and loan number, while AWDV supplies the award identifier, person identifier, and fund identifier. Fund setup attributes are drawn from the alias FMAST (fund master), including the calendar type, sequence number, and fund code, with calendar dates sourced from CI. The alias FCAT provides fund category details such as fund source, fund type, system fund type, and federal fund code, and RECIP supplies lender, guarantor, and recipient identifiers. The view also invokes the IGF_AW_GEN.LOOKUP_DESC function to translate the promissory note status code into a descriptive value.

Key Columns

The view exposes a wide set of columns spanning loan, award, fund, and servicing domains. Identification columns include ROW_ID, ORIGINATION_ID, LOAN_ID, AWARD_ID, PERSON_ID, and FUND_ID. Fund and calendar context columns include CI_CAL_TYPE, CI_SEQUENCE_NUMBER, START_DT, END_DT, ALTERNATE_CODE, FUND_CODE, FUND_SOURCE, FUND_TYPE, SYS_FUND_TYPE, and FED_FUND_CODE. Promissory note and origination status columns include ORIG_STATUS_FLAG, ORIG_BATCH_ID, ORIG_BATCH_DATE, PNOTE_STATUS, PNOTE_STATUS_DATE, PNOTE_ID, PNOTE_ACCEPT_AMT, and PNOTE_MPN_IND. Guarantee and lender columns include GUARANTEE_AMT, GUARANTEE_DATE, GUARNT_STATUS_CODE, LEND_STATUS_CODE, and LEND_APPRV_DENIED_CODE. Recipient columns include LENDER_ID, GUARANTOR_ID, RECIPIENT_ID, and RECIPIENT_TYPE. Additional fields cover grade level, enrollment status, interest rate, and aggregate outstanding balances.

Common Use Cases and Queries

Typical uses include reconciliation of loan origination batches, monitoring of promissory note acceptance, and extraction of loan data for COD or servicer interfaces. A representative query to review active origination records for a given fund is shown below.

  • SELECT ORIGINATION_ID, LOAN_NUMBER, PERSON_ID, FUND_CODE, ORIG_STATUS_FLAG, PNOTE_STATUS FROM IGF_SL_LOR_V WHERE FUND_CODE = :fund_code;
  • SELECT AWARD_ID, LOAN_ID, GUARANTEE_AMT, GUARANTEE_DATE, LEND_STATUS_CODE FROM IGF_SL_LOR_V WHERE ORIG_BATCH_ID = :batch_id;
  • SELECT PERSON_ID, FUND_CODE, PNOTE_ACCEPT_AMT, PNOTE_ACCEPT_DATE FROM IGF_SL_LOR_V WHERE PNOTE_STATUS = 'ACCEPTED';

Because the view encapsulates multi-table joins, it reduces development effort for ad hoc reporting, but queries should be filtered by indexed columns such as FUND_CODE, ORIGINATION_ID, or PERSON_ID to avoid full scans.