Search Results borw_detrm

Overview

The Oracle EBS view APPS.IGF_SL_PLUS_LOAN_DETAILS_V is a supplementary database view owned by the APPS schema and catalogued under FND Design Data IGF.IGF_SL_PLUS_LOAN_DETAILS_V. It exposes loan-level detail for PLUS (Parent Loan for Undergraduate Students) loans managed within the Financial Aid module of Oracle E-Business Suite, specifically the Student Loan processing functionality in the IGF (Financial Aid) product family. As documented in the ETRM metadata, this is a supplementary view intended to simplify Oracle Forms coding; Oracle explicitly warns that the view may change dramatically in subsequent minor or major releases and does not recommend that customers query or alter data through it.

The view is status VALID in both 12.1.1 and 12.2.2. Its presence in the APPS schema means it participates in standard EBS data security and joins cleanly to other Financial Aid objects such as awards, persons, and calendar instances. Because the view combines loan attributes, borrower determination information, and award year context in a single row, it is frequently leveraged indirectly by the PLUS loan forms rather than by end-users writing ad hoc SQL.

Underlying Base Objects

The primary base object referenced by the view is IGF_SL_LOANS_ALL, evidenced by the ROW_ID column definition, which is documented as the "Row ID of the IGF_SL_LOANS_ALL table." The view therefore inherits the loan transaction grain of that table and projects a denormalized set of descriptive fields alongside the core identifiers.

The ETRM excerpt does not enumerate additional base objects; the loan type meaning, loan status description, and borrower determination meaning are evidently resolved through lookups or joins that are not itemized in the supplied metadata. The documented dependency list for this article shows no referenced base objects, so the precise join set should be confirmed against the view DDL in the target environment before relying on any derived column.

Key Columns

• ROW_ID — ROWID of the underlying IGF_SL_LOANS_ALL row, useful for key-preserved updates in forms.
• LOAN_ID / AWARD_ID / SEQ_NUM — Primary loan, award, and sequence identifiers.
• LOAN_NUMBER and LOAN_TYPE_NUM_TXT — Loan number; loan type number formed by concatenating fund code with loan sequence number.
• LOAN_PER_BEGIN_DATE / LOAN_PER_END_DATE — Loan period boundaries.
• LOAN_STATUS, LOAN_STATUS_DESC, LOAN_STATUS_DATE — Current loan status code, its description, and the status date.
• LOAN_CHG_STATUS, LOAN_CHG_STATUS_DESC, LOAN_CHG_STATUS_DATE — Change status code, description, and date.
• ACTIVE / ACTIVE_DATE — Active indicator and activation date.
• BORW_DETRM_CODE and BORW_DETRM — Borrower determination code for the payee for an excess credit amount, and its decoded meaning (up to 80 characters).
• P_PERSON_ID / STUDENT_ID / P_PERSON_NUMBER — Borrower person ID, student person ID, and person number.
• LOAN_ACCEPTED_AMT, LOAN_TYPE_CODE, LOAN_TYPE_MEANING — Accepted amount and loan type classification.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER, CI_ALTERNATE_CODE, CI_START_DT, CI_END_DT — Award year calendar context.
• LEGACY_RECORD_FLAG — Indicates records migrated from a legacy system.

Common Use Cases and Queries

A recurring requirement is determining the borrower determination for an excess credit payee on a PLUS loan. The following query retrieves that information for active loans:

SELECT loan_id,
       loan_number,
       borw_detrm_code,
       borw_detrm,
       loan_status_desc,
       loan_accepted_amt
  FROM apps.igf_sl_plus_loan_details_v
 WHERE active = 'Y'
   AND p_person_id = :person_id;

Other typical uses include extracting PLUS loan populations by award year for reconciliation, joining to PER_ALL_PEOPLE_F via P_PERSON_ID for borrower reporting, and filtering on LEGACY_RECORD_FLAG when auditing migrated loan data. Because Oracle discourages direct querying of supplementary views, production integrations should prefer the certified base tables or public APIs, treating this view as a convenience layer for forms and diagnostics only.