Results for “igf_sl_plus_loan_details_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view IGF_SL_PLUS_LOAN_DETAILS_V belongs to the IGF — Financial Aid product family within Oracle E-Business Suite (documented as obsolete in ETRM 12.2.2). It exposes consolidated PLUS loan (Parent Loan for Undergraduate Students) detail records for financial aid borrowers and is intended to support reporting, reconciliation, and integration of federal PLUS loan disbursement and award data. The view does not store data; it is a reporting projection that joins loan, award, fund, calendar, borrower, and person records into a single denormalized result set.

Because it is documented as obsolete and "not implemented in this database" in the ETRM metadata, the object is typically encountered only in legacy 12.1.1 or 12.2.2 environments where the student financial aid module was seeded. Its principal role is to provide downstream extracts — for example, third-party loan servicing interfaces and financial aid audit reports — with a flat, human-readable PLUS loan record.

Underlying Base Objects

The view text is defined over the following base objects:

• IGF_SL_LOANS — core loan records (aliased LOANS).
• IGF_SL_LOR — loan/origination relationship holding the borrower person reference (aliased LOR).
• IGF_AW_AWARD — the award record driving the loan (aliased AWD).
• IGF_AW_FUND_MAST — fund master providing the fund code (aliased FMAST).
• IGF_AW_FUND_CAT — fund category supplying the federal fund code (aliased FCAT).
• IGF_AP_FA_BASE_REC — financial aid base record (aliased FABASE).
• IGS_CA_INST — calendar instance (aliased CI).
• IGS_PE_PERSON_BASE_V — person base view (aliased PERSON).
• IGS_LOOKUP_VALUES — lookup values for borrower determinant (aliased LKV, outer-joined on lookup type IGS_FI_BORW_DETRM).

A critical filter is FCAT.FED_FUND_CODE IN ('DLP','FLP'), which restricts the result set to Direct PLUS and Federal PLUS loans respectively, distinguishing this view from other loan detail views.

Key Columns

• ROW_ID / LOAN_ID / AWARD_ID / SEQ_NUM — primary identifiers linking back to the loan and award records.
• LOAN_NUMBER — the loan identifier as assigned during origination.
• LOAN_TYPE_NUM — concatenation of FUND_CODE and SEQ_NUM, providing the loan type indicator.
• LOAN_PER_BEGIN_DATE / LOAN_PER_END_DATE — loan period boundaries.
• LOAN_STATUS / LOAN_STATUS_DESC — raw status code plus decoded description via IGF_AW_GEN.LOOKUP_DESC against lookup type IGF_SL_LOAN_STATUS.
• LOAN_CHG_STATUS / LOAN_CHG_STATUS_DATE — change-of-status code and its decoded meaning.
• ACCEPTED_AMT — accepted award amount for the associated award.
• FED_FUND_CODE / FED_FUND_DESC — federal fund code (DLP/FLP) and its lookup description.
• PERSON_NUMBER / FULL_NAME / P_PERSON_ID — borrower identity attributes.
• ALTERNATE_CODE / START_DT / END_DT — academic calendar instance details.
• BORW_DETRM_CODE / BORROWER_DETRM_MEANING — borrower determinant code and decoded meaning.
• ACTIVE / ACTIVE_DATE / LEGACY_RECORD_FLAG — record state and migration indicators.
• EXTERNAL_LOAN_ID_TXT — external loan identifier used in servicing integrations.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE — standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include reconciliation of disbursed PLUS loans per borrower, extraction feeds to loan servicers, and audit reporting on accepted versus originated amounts. A representative query follows:

SELECT LOAN_NUMBER,
       LOAN_TYPE_NUM,
       LOAN_STATUS_DESC,
       ACCEPTED_AMT,
       FULL_NAME,
       PERSON_NUMBER,
       FED_FUND_CODE,
       EXTERNAL_LOAN_ID_TXT
FROM   IGF_SL_PLUS_LOAN_DETAILS_V
WHERE  LOAN_PER_BEGIN_DATE >= :p_from_date
AND    FED_FUND_CODE IN ('DLP','FLP')
AND    ACTIVE = 'Y';

Additional uses include joining to award and disbursement tables by AWARD_ID, producing borrower-level summaries via aggregation on PERSON_NUMBER, and filtering LEGACY_RECORD_FLAG to isolate pre-migration data. Since the object is obsolete, new development should reference the successor Financial Aid schema objects; existing queries should be reviewed before any upgrade to confirm continued availability.