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
- DISBURSEMENT_NET_AMT – the net loan disbursement amount, sourced from SDLC.DISB_NET_AMT; this is the column most frequently searched and the primary figure for cash reconciliation and student payment reporting.
- DISBURSEMENT_GROSS_AMT – the gross disbursement amount before fee deductions, sourced from SDLC.DISB_GROSS_AMT.
- ORIGINATION_FEE and GUARANTEE_FEE – the fees assessed on the disbursement, mapped from SDLC.FEE_1 and SDLC.FEE_2.
- ORIGINATION_FEE_PAID and GUARANTEE_FEE_PAID – the fee amounts actually paid, from SDLC.FEE_PAID_1 and SDLC.FEE_PAID_2.
- DISBURSEMENT_DATE – the effective date of the disbursement.
- TRANSACTION_TYPE, FUND_STATUS, DISBURSEMENT_STATUS, HOLD_RELEASE_INDICATOR, FUND_DISTRIBUTION_TYPE, PREVIOUS_REPORTED_IND – lookup-translated descriptive columns resolved through IGF_LOOKUPS_VIEW against the corresponding IGF lookup types.
- DISBURSEMENT_STATUS_DATE, LATE_DISBURSEMENT_INDICATOR, CHEQUE_NUMBER, LOAN_NUMBER – disbursement tracking attributes from IGF_AW_AWD_DISB_ALL and IGF_SL_LOANS_ALL.
- AWARD_CALENDAR_TYPE and AWARD_YEAR_S – academic calendar context from IGF_AP_FA_BASE_REC_ALL.
- FUND_CODE and DESCRIPTION – fund identification from IGF_AW_FUND_MAST_ALL.
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.
-
Base view for the entity that holds FFELP Loan Disbursements
APPS.IGFBV_FFELP_AWD_DISBURSEMENTS·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_AWD_DISB_ALL·Explore IGF module →
-
Full View for the Entity that holds FFELP Loan Disbursements
APPS.IGFFV_FFELP_AWD_DISBURSEMENTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Base view for the entity that holds Direct Loan Award Disbursements
APPS.IGFBV_DL_AWARD_DISBURSEMENTS·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_AWD_DISB_ALL·Explore IGF module →
-
Full View for the Entity that holds Direct Loan Award Disbursements
APPS.IGFFV_DL_AWARD_DISBURSEMENTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that holds FFELP Loan Disbursements
Not implemented in this database·Explore IGF module →
-
Full View for the Entity that holds Direct Loan Award Disbursements
Not implemented in this database·Explore IGF module →
-
Base view for the entity that holds FFELP Loan Disbursements
Not implemented in this database·Explore IGF module →
-
Base view for the entity that holds Direct Loan Award Disbursements
Not implemented in this database·Explore IGF module →
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program