Results for “origination_fee”

13 results




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

Overview

IGFBV_FFELP_AWD_DISBURSEMENTS is a read-only Oracle EBS base view owned by the APPS schema within the IGF – Financial Aid product. Its documented purpose is to serve as the base view for the entity that holds FFELP (Federal Family Education Loan Program) loan disbursements. In EBS 12.1.1 and 12.2.2, this view exposes award-level disbursement data drawn from the Student Loan (IGF_SL) and Financial Aid Award (IGF_AW) tables, and it is referenced by the ETRM Object Library under the object name IGFBV_FFELP_AWD_DISBURSEMENTS with a status of VALID.

The view is defined WITH READ ONLY, so it is intended strictly for query, reporting, and integration consumption rather than for direct DML. It presents the FFELP disbursement entity in a denormalized form that combines loan, fund, award, and academic base reference information, making it suitable for extracts, reporting, and downstream interfaces that need a consolidated FFELP disbursement record.

Underlying Base Objects

The view joins seven base tables using a defined set of equality predicates. The master driver is IGF_SL_AWD_DISB_LOC_ALL (aliased SDLC), which holds the award disbursement and loan disbursement amounts. It is joined to IGF_AW_AWARD_ALL (AWD) on AWARD_ID, to IGF_AW_AWD_DISB_ALL (DISB) on AWARD_ID and DISB_NUM, to IGF_AW_FUND_MAST_ALL (FMAST) on FUND_ID, and through FMAST to IGF_AW_FUND_CAT_ALL (FCAT) on FUND_CODE. The loan-related attributes come from IGF_SL_LOANS_ALL (LOANS) on AWARD_ID, and the academic base reference data comes from IGF_AP_FA_BASE_REC_ALL (FABASE) on BASE_ID. The fund category is constrained to federal fund codes 'FLP', 'FLS', 'FLU', and 'ALT', which is what restricts the view to FFELP disbursements. No separate base view or synonym dependencies are documented beyond these tables.

Key Columns

Common Use Cases and Queries

Typical uses include extracting FFELP disbursement amounts for reconciliation against lender files, producing net disbursement reporting for Title IV compliance, and feeding financial interfaces that require both gross and net amounts with loan and fund context.

Disbursement totals by loan:

  • SELECT LOAN_NUMBER, SUM(DISBURSEMENT_NET_AMT) NET_TOTAL FROM APPS.IGFBV_FFELP_AWD_DISBURSEMENTS GROUP BY LOAN_NUMBER;

Net disbursement detail with status:

  • SELECT LOAN_NUMBER, DISBURSEMENT_DATE, DISBURSEMENT_GROSS_AMT, DISBURSEMENT_NET_AMT, "DISBURSEMENT_STATUS" FROM APPS.IGFBV_FFELP_AWD_DISBURSEMENTS WHERE DISBURSEMENT_DATE BETWEEN :dt1 AND :dt2;

Because the view is WITH READ ONLY, all access must be through SELECT statements, and callers should reference the APPS schema directly or through an appropriate synonym or grants provisioned by the IGF module.