Search Results igfbv_perkins_loans

Overview

IGFBV_PERKINS_LOANS is a read-only base view within the Oracle E-Business Suite Financial Aid (IGF) module, historically used to expose Perkins Loan records for reporting, inquiry, and integration purposes. Perkins Loans represent a federally subsidized, need-based student loan program administered by participating institutions, and this view was designed to present a consolidated, funding-source-filtered projection of loan data tied to a specific award and fund category. The view identifies Perkins Loans specifically by filtering on the federal fund code 'PRK' through the fund category table, ensuring that only loans associated with Perkins funding are returned. The metadata expressly labels the IGF - Financial Aid module as Obsolete, and the implementation note states the view is "Not implemented in this database." Consequently, in Oracle EBS 12.1.1 and 12.2.2 environments, this object should be regarded as a legacy artifact from earlier Financial Aid releases and is unlikely to exist as a valid database object in current installations. The ETRM record shows no documented owner and no documented referenced base objects, reinforcing its orphaned status. Where it does exist, its role is strictly read-only, serving as a stable reporting interface over the underlying loan, award, and fund master tables without exposing write-back capability to consumers.

Underlying Base Objects

The view text documents that IGFBV_PERKINS_LOANS is defined over four core Financial Aid tables, joined as follows:

• IGF_SL_LOANS_ALL (aliased LOANS) — the primary loan record source, joined to awards via AWARD_ID.
• IGF_AP_FA_BASE_REC_ALL (aliased FABASE) — the base applicant record, joined to awards via BASE_ID.
• IGF_AW_AWARD_ALL (aliased AWD) — the award records, providing accepted amount and linking base and loan data.
• IGF_AW_FUND_MAST_ALL (aliased FMAST) — the fund master, joined to awards on FUND_ID.
• IGF_AW_FUND_CAT_ALL (aliased FCAT) — the fund category, joined to the fund master via FUND_CODE and constrained by FED_FUND_CODE = 'PRK'.

The join chain requires that an award links to a loan, a base record, a fund, and a fund category whose federal fund code equals 'PRK'. This design isolates Perkins Loans from other federal loan programs at query time. The ETRM metadata documents no owner or base objects, so the JOIN relationships above are derived solely from the view text excerpt.

Key Columns

The view exposes loan, award, calendar, and audit attributes:

• LOAN_NUMBER — the institutional identifier for the loan.
• LOAN_PERIOD_BEGIN_DATE / LOAN_PERIOD_END_DATE — the loan's active period boundaries.
• "_LA:LOAN_RECORD_STATUS" — a lookup-encoded status column referencing IGF_SL_LOAN_STATUS meanings via IGF_LOOKUPS_VIEW.
• LOAN_ORIGINATION_STATUS_DATE — the date the loan status was set or originated.
• LOAN_IS_ACTIVE / LOAN_IS_ACTIVE_DATE — activity indicator and its effective date.
• AWARD_CALENDAR_TYPE / AWARD_YEAR_SEQUENCE_NUMBER — the award's academic calendar and year.
• LOAN_AMOUNT — the accepted award amount applicable to the loan.
• BASE_ID / PERSON_ID / INETRNAL_LOAN_ID — keys identifying the base record, person, and internal loan.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns.

Common Use Cases and Queries

Where the view is still available, it supports reporting on Perkins Loan populations, including active loans, disbursement periods, and fund-source verification.

SELECT LOAN_NUMBER, PERSON_ID, LOAN_AMOUNT, LOAN_IS_ACTIVE, AWARD_CALENDAR_TYPE FROM IGFBV_PERKINS_LOANS WHERE LOAN_IS_ACTIVE = 'Y';

SELECT AWARD_CALENDAR_TYPE, AWARD_YEAR_SEQUENCE_NUMBER, COUNT(*), SUM(LOAN_AMOUNT) FROM IGFBV_PERKINS_LOANS GROUP BY AWARD_CALENDAR_TYPE, AWARD_YEAR_SEQUENCE_NUMBER;

Typical scenarios include reconciliation of Perkins awards against fund category records, extracting loan status transitions for compliance reporting, and integration feeds to downstream financial aid systems. Because modules are obsolete in 12.1.1 and 12.2.2, validation against the base tables is advised before relying on this view.