Results for “award_year”

50+ results




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

Overview

The view IGFFV_FFELP_AWD_DISBURSEMENTS belongs to the Oracle E-Business Suite IGF — Financial Aid product family, which is documented in ETRM as obsolete in Release 12.1.1 and 12.2.2. It is described as the "Full View for the Entity that holds FFELP Loan Disbursements." FFELP refers to the Federal Family Education Loan Program, a United States federal student loan program under which guaranty agencies and lenders originated and disbursed subsidized, unsubsidized, and consolidation loans. The view therefore presents a denormalized, read-only projection of loan disbursement records associated with financial aid awards, enriched with fund, loan, person, and calendar attributes.

Because this is a "full view," it exposes both the stored base columns and a set of derived lookup columns that translate internal codes into their display meanings. The lookup translation strings embedded in the view text (for example '_LA:DISB.TRANS_TYPE:IGF_LOOKUPS_VIEW:IGF_DB_TRANS_TYPE:MEANING') follow the standard IGF "lookup association" convention used by the Financial Aid forms and reporting layer. The ETRM metadata notes that the view is not implemented in this database, meaning no compiled instance of the object exists in the reference environment; the view text is provided for documentation purposes only.

Underlying Base Objects

Although the ETRM "Referenced base objects" field is empty, the view text documents a join across the following IGF and shared tables:

The view is declared WITH READ ONLY, confirming it is intended solely for query and reporting, not for DML.

Key Columns

Common Use Cases and Queries

Typical use is reconciliation and federal reporting of FFELP disbursements, including identification of late disbursements. A representative query follows:

SELECT LOAN_NUMBER, AWARD_ID, DISB_NUM, DISBURSEMENT_DATE, DISBURSEMENT_GROSS_AMT, DISBURSEMENT_NET, LATE_DISB_IND
FROM IGFFV_FFELP_AWD_DISBURSEMENTS
WHERE LATE_DISB_IND = 'Y'
ORDER BY DISBURSEMENT_DATE;

Other scenarios include fee reconciliation between origination and guarantee fees and amounts paid, fund-code level summaries, and person-level disbursement histories. Because the underlying IGF product is obsolete, these patterns are relevant only for legacy reporting or migration analysis.