Search Results s_full_name




Overview
Explore in AI Chat

Overview

The view IGF_SL_PRK_LOAN_V belongs to the Oracle E-Business Suite module IGF – Financial Aid, a component historically used by higher-education institutions to administer student financial aid, including Title IV federal loan programs. The view presents Perkins Loan (PRK) information for a student within the financial aid system. The Perkins Loan program is a federally subsidized, need-based campus loan program, and this view consolidates the loan header, student biographical and demographic data, permanent home address details, and the accepted loan amount into a single denormalized result set.

The ETRM documentation classifies this object as Obsolete and states explicitly that it is not implemented in this database. This means that in Oracle EBS 12.1.1 and 12.2.2 environments where the object is absent, any query, report, interface, or concurrent program referencing IGF_SL_PRK_LOAN_V will fail with an ORA-00942 (table or view does not exist) error. Because the Financial Aid product family (IGF) was not carried forward as a supported module in the 12.1.1 and 12.2.2 application editions, this view exists primarily as historical ETRM documentation rather than as a live database object. The search term loan_amt_accepted maps directly to a column exposed by this view, which is why the object surfaces in the context of the user's query.

Underlying Base Objects

Although the ETRM metadata records no formally documented referenced base objects, the view text itself shows that IGF_SL_PRK_LOAN_V is defined over a join of several underlying IGF tables and views. The principal source objects are:

The joins are predominantly inner joins across award, fund, base record, person, and ISIR data, with outer joins to the ISIR (NVL on PAYMENT_ISIR_ID) and the address view.

Key Columns

Common Use Cases and Queries

In environments where the view is implemented, it supports Perkins Loan reporting, loan certification extracts, and reconciliation of accepted versus disbursed amounts. A typical query retrieves accepted Perkins Loan amounts per student:

  • SELECT LOAN_NUMBER, S_SSN, S_FULL_NAME, LOAN_AMT_ACCEPTED, LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE FROM IGF_SL_PRK_LOAN_V WHERE LOAN_AMT_ACCEPTED > 0;
  • Filtering by loan period for a given aid year: ... WHERE LOAN_PER_BEGIN_DATE BETWEEN :start_dt AND :end_dt;
  • Mailing/notification extracts using the permanent address columns and S_EMAIL_ADDR.

Because the object is documented as obsolete and not implemented in EBS 12.1.1/12.2.2, technical consultants should treat IGF_SL_PRK_LOAN_V as reference-only. Any current requirement around accepted Perkins Loan amounts would need to be sourced from surviving Financial Aid loan tables or a custom replacement view.