Search Results igf_sl_p_default_status

Overview

APPS.IGF_SL_LOR_V is a reporting and integration view within the Oracle E-Business Suite Financial Aid (IGF) module, historically associated with the Student Loan (SL) functional area. In the context of Oracle EBS 12.1.1 and 12.2.2, this view consolidates data spanning loan origination, promissory note management, disbursement recipient detail, guarantee and lender status, and fund accounting reference information. It presents a denormalized, read-only projection that joins loan origination records to loan award, fund, and recipient data, exposing the combined result under a single relational interface. The view is intended for use by reporting tools, concurrent programs, interfaces, and downstream integrations that require a flattened perspective of the loan origination lifecycle without having to reconstruct the join logic against base tables manually.

The naming convention (IGF_SL_LOR_V) confirms it is a view ("_V") in the IGF Student Loan (SL) family, and the column list demonstrates that it is primarily keyed on the loan origination row (LOR.ROW_ID, LOR.ORIGINATION_ID). It is most commonly queried when users investigate loan origination status, promissory note status, and guarantor or lender approval outcomes.

Underlying Base Objects

The ETRM metadata records the owner as APPS and lists no separately documented base objects, but the view text itself names the aliased sources that constitute the definition. These aliases resolve to base tables in the IGF and related financial aid schema:

• LOR — the loan origination record table (IGF_SL_LOR_ALL or equivalent), providing the primary key and the majority of origination, promissory note, guarantee, lender, and disclosure columns.
• LAR — the loan award record table, supplying LOAN_ID, SEQ_NUM, and LOAN_NUMBER.
• AWDV — an award view, contributing AWARD_ID and FUND_ID.
• BASE — contributing PERSON_ID for the borrower.
• FMAST — the fund master table, supplying CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and FUND_CODE.
• CI — the calendar/period instance providing START_DT, END_DT, and ALTERNATE_CODE.
• FCAT — the fund category table, contributing FUND_SOURCE, FUND_TYPE, SYS_FUND_TYPE, and FED_FUND_CODE.
• RECIP — the recipient table, providing LENDER_ID, GUARANTOR_ID, RECIPIENT_ID, RECIPIENT_TYPE, and non-ED BRC identifiers.

The concatenation FMAST.FUND_CODE||TO_CHAR(LAR.SEQ_NUM) yields an identifier distinguishing individual loan awards within a fund. The call to IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PNOTE_STATUS', LOR.PNOTE_STATUS) resolves the promissory note status code to its descriptive value inline.

Key Columns

Several columns are of particular operational importance:

• ROW_ID, ORIGINATION_ID — stable identifiers for the loan origination record.
• LOAN_ID, LOAN_NUMBER, SEQ_NUM — link to the award/loan and its sequence within the fund.
• PERSON_ID, AWARD_ID, FUND_ID — the borrower, award, and fund context.
• PNOTE_STATUS, PNOTE_STATUS_DATE, PNOTE_ID, PNOTE_ACCEPT_AMT, PNOTE_ACCEPT_DATE, PNOTE_MPN_IND — promissory note lifecycle, including MPN (Master Promissory Note) processing.
• ORIG_STATUS_FLAG, ORIG_BATCH_ID, ORIG_BATCH_DATE, ORIG_ACK_DATE — origination batch and acknowledgement tracking.
• GUARANTEE_AMT, GUARANTEE_DATE, GUARNT_STATUS_CODE, GUARNT_STATUS_DATE — guarantee status and amounts.
• LENDER_ID, GUARANTOR_ID, LEND_STATUS_CODE, LEND_APPRV_DENIED_CODE — lender and guarantor approval outcomes.
• CL_LOAN_TYPE, CL_REC_STATUS, ALT_PROG_TYPE_CODE — CommonLine and program-type identifiers for federal loan processing.
• SCH_CERT_DATE, GRADE_LEVEL_CODE, ENROLLMENT_CODE, ANTICIP_COMPL_DATE — school certification and enrollment attributes.

Common Use Cases and Queries

The view is typically queried for reconciliation of loan origination batches, promissory note tracking, and guarantor/lender status reporting. A typical query selects the borrower, fund, promissory note status, and guarantee state:

• SELECT origination_id, person_id, fund_code, loan_number, pnote_status, pnote_status_date, guarnt_status_code FROM igf_sl_lor_v WHERE orig_status_flag = 'P';
• SELECT fund_source, fund_type, COUNT(*) FROM igf_sl_lor_v GROUP BY fund_source, fund_type;
• SELECT loan_number, lender_id, lend_status_code, lend_status_date FROM igf_sl_lor_v WHERE lend_status_code IS NOT NULL;

Note that the search term "igf_sl_p_default_status" does not correspond to a column in this view; PNOTE_STATUS and its lookup IGF_SL_PNOTE_STATUS are the closest documented status fields. Users seeking a default promissory note status should query PNOTE_STATUS or inspect the IGF_SL_PNOTE_STATUS lookup directly.