Search Results igf_sl_s_default_status

Overview

APPS.IGF_SL_LOR_V is a reporting and integration view within the Oracle E-Business Suite Financial Aid module (IGF), which supports the administration of student loans and related Title IV aid. The view name reflects its role: it exposes Loan Origination Records (LOR) joined to loan, award, fund, and recipient attributes. In release 12.1.1 and 12.2.2, this view provides a denormalized read surface used by concurrent programs, reports, and downstream interfaces that require a consolidated picture of a loan origination record alongside its award and fund context.

The user search term "igf_sl_s_default_status" indicates interest in default status semantics within student loan processing. While that specific identifier is not part of the view's projected column list, the view does carry several status-bearing columns — including ORIG_STATUS_FLAG, PNOTE_STATUS, GUARNT_STATUS_CODE, LEND_STATUS_CODE, and CL_REC_STATUS — which together describe the lifecycle position of a loan origination record.

Underlying Base Objects

The view text references several base objects through aliases. Documented ETRM metadata lists no explicitly referenced base objects, but the SELECT statement identifies them by alias:

• LOR — the loan origination record table (IGF_SL_LOR), supplying origination, promissory note, guarantee, lender, and serial loan attributes.
• LAR — the loan award record, contributing LOAN_ID, SEQ_NUM, and LOAN_NUMBER.
• AWDV — an award view supplying AWARD_ID and FUND_ID.
• BASE — a person/recipient source supplying PERSON_ID.
• FMAST — the fund master, providing CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and FUND_CODE.
• CI — a calendar instance supplying START_DT, END_DT, and ALTERNATE_CODE.
• FCAT — fund category, yielding FUND_SOURCE, FUND_TYPE, SYS_FUND_TYPE, and FED_FUND_CODE.
• RECIP — recipient data providing LENDER_ID, GUARANTOR_ID, RECIPIENT_ID, and related borrower/recipient identifiers.

The view also invokes IGF_AW_GEN.LOOKUP_DESC to decode PNOTE_STATUS against the IGF_SL_PNOTE_STATUS lookup type, embedding a descriptive value directly in the projection.

Key Columns

• ROW_ID, ORIGINATION_ID, LOAN_ID, AWARD_ID, PERSON_ID, FUND_ID — primary identifiers linking the origination record to its loan, award, person, and fund.
• ORIG_STATUS_FLAG, ORIG_BATCH_ID, ORIG_BATCH_DATE, ORIG_ACK_DATE — origination workflow state and batch/acknowledgement tracking.
• PNOTE_STATUS, PNOTE_STATUS_DATE, PNOTE_ID, PNOTE_ACCEPT_AMT, PNOTE_ACCEPT_DATE, PNOTE_MPN_IND — promissory note lifecycle, including master promissory note indication.
• GUARANTEE_AMT, GUARANTEE_DATE, GUARNT_STATUS_CODE, GUARNT_STATUS_DATE, GUARNT_AMT_REDN_CODE — guarantee processing detail.
• LEND_APPRV_DENIED_CODE, LEND_STATUS_CODE, LEND_STATUS_DATE, LENDER_ID, LAST_RESORT_LENDER — lender approval and status attributes.
• FUND_CODE, FUND_SOURCE, FUND_TYPE, SYS_FUND_TYPE, FED_FUND_CODE — fund classification for reporting and federal reporting alignment.
• CL_LOAN_TYPE, CL_REC_STATUS, ALT_PROG_TYPE_CODE, SERVICE_TYPE_CODE — CommonLine/serial loan processing context.

Common Use Cases and Queries

The view is typically queried to report origination throughput, promissory note status, and guarantee outcomes by fund and academic period. Example:

• Origination status report: SELECT ORIGINATION_ID, LOAN_NUMBER, FUND_CODE, ORIG_STATUS_FLAG, PNOTE_STATUS FROM APPS.IGF_SL_LOR_V WHERE ORIG_BATCH_DATE >= :p_start_date;
• Promissory note tracking: SELECT PERSON_ID, AWARD_ID, PNOTE_MPN_IND, PNOTE_ACCEPT_AMT, PNOTE_ACCEPT_DATE FROM APPS.IGF_SL_LOR_V WHERE PNOTE_STATUS = :status;
• Guarantee reconciliation: SELECT LENDER_ID, GUARANTOR_ID, GUARANTEE_AMT, GUARNT_STATUS_CODE FROM APPS.IGF_SL_LOR_V WHERE GUARNT_STATUS_DATE BETWEEN :from AND :to;

Because the view consolidates loan, award, fund, and recipient context, it is well suited to extracts feeding federal reporting and to custom BI Publisher reports, avoiding the need to re-join the underlying IGF_SL_LOR and award tables manually.