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:
- IGF_SL_AWD_DISB_LOC_ALL (alias SDLC) — the Student Loan Award Disbursement Location entity, which supplies gross and net disbursement amounts, fee fields, and the disbursement number.
- IGF_AW_AWARD_ALL (AWD) — award header, joined on AWARD_ID.
- IGF_AW_AWD_DISB_ALL (DISB) — award disbursement, joined on AWARD_ID and DISB_NUM, supplying disbursement status, dates, cheque number, and the late disbursement indicator.
- IGF_AW_FUND_MAST_ALL (FMAST) and IGF_AW_FUND_CAT_ALL (FCAT) — fund master and fund category, restricted to federal fund codes FLP, FLS, FLU, and ALT.
- IGF_SL_LOANS_ALL (LOANS) — loan records joined on AWARD_ID.
- IGF_AP_FA_BASE_REC_ALL (FABASE) — the Financial Aid base record, providing calendar type and sequence.
- IGS_CA_INST_ALL (CA) — calendar instance, joined on calendar type and sequence number.
- HZ_PARTIES (HZ) — party/person name and party number, joined on PERSON_ID.
The view is declared WITH READ ONLY, confirming it is intended solely for query and reporting, not for DML.
Key Columns
- DISBURSEMENT_GROSS_AMT / DISBURSEMENT_NET (DISB_GROSS_AMT, DISB_NET_AMT) — gross and net disbursed amounts.
- ORIGINATION_FEE / GUARANTEE_FEE (FEE_1, FEE_2) and the corresponding paid amounts (FEE_PAID_1, FEE_PAID_2).
- DISBURSEMENT_DATE (DISB_DATE) and DISB_STATUS_DATE — the disbursement and status dates.
- LATE_DISB_IND — the late disbursement indicator, a flag denoting whether the disbursement occurred after the permitted disbursement period.
- CHEQUE_NUMBER, LOAN_NUMBER, LOAN_ID, AWARD_ID, DISB_NUM — identifiers for the payment instrument, loan, award, and disbursement.
- CI_CAL_TYPE / CI_SEQUENCE_NUMBER, ALTERNATE_CODE, FUND_CODE / DESCRIPTION — calendar and fund context.
- PARTY_NUMBER and person name columns — student identity attributes.
- Derived lookup columns for TRANS_TYPE, FUND_STATUS, DISB_STATUS, HOLD_REL_IND, FUND_DIST_MTHD, and PREV_REPORTED_IND.
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.
-
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 Stores all the actual disbursement transactions and adjustments made to these, after they have been posted to the student finance interface table. For planned disbursements, this view will not have any records.
APPS.IGFBV_DISBURSEMENT_ADJUSTMENTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
This table will maintain all of the required information to hold a correspondence request for preview, and later distribution.
-
View: IGFFV_STUDENT_COA 12.1.1
Full View for Entity that holds the cost of attendance amount, Pell amount, alternative Pell amount for each item, student in an award year
APPS.IGFFV_STUDENT_COA·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_COA_ITEMS·Explore IGF module →
-
View to implement the master block in 'Review Unmacted Records' form.
APPS.IGF_AP_RW_UNMATCH_REC_V·↳ IGF_AP_REVIEW_DET_V·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AP_APPL_SETUP_V 12.1.1
APPS.IGF_AP_APPL_SETUP_V·↳ IGF_AP_APPL_SETUP·↳ IGS_CA_INST·Explore IGF module →
-
Full View for the Entity that stores the item instance information
APPS.IGFFV_TRACK_STUDENT_TODO_ITEMS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AP_TD_ITEM_INST_ALL·Explore IGF module →
-
View: IGFFV_DL_REJECTS 12.1.1
Full View for the Entity that holds Financial Aid Direct Loan Rejects
APPS.IGFFV_DL_REJECTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that holds the System Award Year Mapping details
APPS.IGFFV_BATCH_YEAR_SETUPS·↳ IGF_AP_BATCH_AW_MAP_ALL·↳ IGS_CA_INST_ALL·Explore IGF module →
-
Full View for the Entity that holds Direct Stafford Loan Promissory Notes
APPS.IGFFV_DL_STAFFORD_PROM_NOTES·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_FUND_MAST_ALL·↳ IGF_SL_DL_PNOTE_S_P_ALL·Explore IGF module →
-
View: IGFFV_PERKINS_LOANS 12.1.1
Full View for the Entity that holds Perkins Loans
APPS.IGFFV_PERKINS_LOANS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Contains the values for all the user-defined questions
APPS.IGFFV_STU_INST_APPLICATIONS·↳ HZ_PARTIES·↳ IGF_AP_APPL_SETUP_ALL·↳ IGF_AP_FA_BASE_REC_ALL·Explore IGF module →
-
Full View for the Entity that holds the information about the Application Review Groups
APPS.IGFFV_PELL_DISBURSEMENTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Contains the details about the student for federal needs.
APPS.IGFBV_FEDERAL_NEED_DETAILS·↳ HZ_PARTIES·↳ IGF_AP_EFC_CALC·↳ IGF_AP_FA_BASE_REC_ALL·Explore IGF module →
-
Contains the details about the student for federal needs.
APPS.IGFFV_FEDERAL_NEED_DETAILS·↳ HZ_PARTIES·↳ IGF_AP_EFC_CALC·↳ IGF_AP_FA_BASE_REC_ALL·Explore IGF module →
-
Full View for the Entity that holds Direct Loan Promissory Note Activities
APPS.IGFFV_DL_PNOTE_STATUS_HISTORY·↳ HZ_PARTIES·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_FUND_MAST_ALL·Explore IGF module →
-
Base View for the Entity that holds the verification values for all user-defined ISIR fields
APPS.IGFBV_VERIFICATION_WORKSHEETS·↳ HZ_PARTIES·↳ IGF_AP_BATCH_AW_MAP_ALL·↳ IGF_AP_FA_BASE_REC_ALL·Explore IGF module →
-
View: IGFBV_STUDENT_COA 12.1.1
Base View for Entity that holds the cost of attendance amount, Pell amount, alternative Pell amount for each item, student in an award year
APPS.IGFBV_STUDENT_COA·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_COA_ITEMS·Explore IGF module →
-
Full View for the Entity that holds Student Work Authorizations
APPS.IGFFV_STUDENT_AUTHORIZATIONS·↳ HZ_PARTIES·↳ IGF_AW_FUND_MAST_ALL·↳ IGF_SE_AUTH·Explore IGF module →
-
Full View for the Entity that stores amount split setup for a given cost of attendance item
APPS.IGFFV_STUDENT_COA_TERM_DETAILS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_COA_ITM_TERMS·Explore IGF module →
-
View: IGFFV_ISIR_CORRECTIONS 12.1.1
Maintains ISIR correction records
APPS.IGFFV_ISIR_CORRECTIONS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AP_ISIR_CORR_ALL·Explore IGF module →
-
Base View for the Entity that stores amount split setup for a given cost of attendance item
APPS.IGFBV_STUDENT_COA_TERM_DETAILS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_COA_ITM_TERMS·Explore IGF module →
-
Full View for the Entity that holds the information about the verification values for all user-defined ISIR fields
APPS.IGFFV_VERIFICATION_WORKSHEETS·↳ HZ_PARTIES·↳ IGF_AP_BATCH_AW_MAP_ALL·↳ IGF_AP_FA_BASE_REC_ALL·Explore IGF module →
-
Full View for the Entity that holds Direct Loan Promissory Note Manifests
APPS.IGFFV_DL_PROM_NOTE_MANIFESTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that holds Student Payroll Details
APPS.IGFFV_STUDENT_PAYROLL_DETAILS·↳ HZ_PARTIES·↳ IGF_AW_FUND_MAST_ALL·↳ IGF_SE_PAYMENT·Explore IGF module →
-
Base View for the Entity that stores the item instance information
APPS.IGFBV_TRACK_STUDENT_TODO_ITEMS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AP_TD_ITEM_INST_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 →
-
View: IGF_AP_TD_ITEM_MST_V 12.1.1
APPS.IGF_AP_TD_ITEM_MST_V·↳ IGF_AP_APPL_SETUP·↳ IGF_AP_TD_ITEM_MST·↳ IGF_LOOKUPS_VIEW·Explore IGF module →
-
View: IGFFV_DL_YTD_DETAILS 12.1.1
Full View for the Entity that holds Year to Date Direct Loan Details
APPS.IGFFV_DL_YTD_DETAILS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGFFV_FFELP_REJECTS 12.1.1
Full View for the Entity that holds Financial Aid FFELP Rejects
APPS.IGFFV_FFELP_REJECTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that holds Student Work Study Award Details
APPS.IGFFV_STUDENT_FWS_AWAD_DETAILS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGFFV_STUDENT_AWARDS 12.1.1
Full View for the Entity that holds the information about the Awards given to students
APPS.IGFFV_STUDENT_AWARDS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGF_SL_DISB_LTR_V 12.1.1
Stores persons loan details used for correspondence
APPS.IGF_SL_DISB_LTR_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGF_AP_APPL_SETUPDTL_V 12.1.1
APPS.IGF_AP_APPL_SETUPDTL_V·↳ IGF_AP_APPL_SETUP_ALL·↳ IGF_AW_AWD_LD_CAL_V·↳ IGF_AW_GEN·Explore IGF module →
-
Base View for the Entity that holds the information of each disbursement.
APPS.IGFBV_AWARD_DISBURSEMENTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that Stores all the actual disbursement transactions and adjustments made to these, after they have been posted to the student finance interface table. For planned disbursements, this view will not have any records.
APPS.IGFFV_DISBURSEMENT_ADJUSTMENTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that Stores all the RFMS data that needs to be sent to the COD system.
APPS.IGFFV_PELL_ORIGINATIONS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGF_AW_PER_LIST_V 12.1.1
Stores person details used for correspondence
APPS.IGF_AW_PER_LIST_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that holds the complete Profile record of the students
APPS.IGFFV_PROFILE_INFORMATION·↳ HZ_PARTIES·↳ IGF_AP_CSS_FNAR_ALL·↳ IGF_AP_CSS_PROFILE_ALL·Explore IGF module →
-
View: IGF_AP_MIS_ITMS_LTR_V 12.1.1
This view is used to return the missing items (missing documents) which are required for Financial Aid processing
APPS.IGF_AP_MIS_ITMS_LTR_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AP_ST_CORR_TEXT·Explore IGF module →
-
View: IGF_AW_AWD_LTR_V 12.1.1
This view selects relevant data for the Award Notification Letter to be sent to a Student
APPS.IGF_AW_AWD_LTR_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWD_LTR_TMP·Explore IGF module →
-
Full View for the Entity that holds the summarized information of all the financial aid processes for a student for an academic year
APPS.IGFFV_STUDENT_BASE_RECORDS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGS_CA_INST_ALL·Explore IGF module →
-
Full View for the Entity that holds Direct Plus Loan Promissory Notes
APPS.IGFFV_DL_PLUS_PROM_NOTES·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_FUND_MAST_ALL·↳ IGF_SL_DL_PNOTE_P_P_ALL·Explore IGF module →
-
Full View for the Entity that holds the information of each disbursement.
APPS.IGFFV_AWARD_DISBURSEMENTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Originations
APPS.IGFFV_DIRECT_LOAN_ORIGINATIONS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGFFV_FUNDS 12.1.1
Full View for the Entity that holds the all the details and the properties for each fund
APPS.IGFFV_FUNDS·↳ HZ_PARTIES·↳ IGF_AW_FUND_CAT_ALL·↳ IGF_AW_FUND_MAST_ALL·Explore IGF module →
-
View: IGFFV_ISIRS 12.1.1
Full View for the Entity that holds the complete ISIR record of the students
APPS.IGFFV_ISIRS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AP_ISIR_MATCHED_ALL·Explore IGF module →
-
Full View for the Entity that holds Financial Aid FFELP Loan Originations
APPS.IGFFV_FFELP_LOAN_ORIGINATIONS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGFFV_NSLDS 12.1.1
Full View for the Entity that holds the NSLDS data of a financial aid student
APPS.IGFFV_NSLDS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AP_ISIR_MATCHED_ALL·Explore IGF module →
-
View to implement the master block in 'Review Unmacted Records' form.
Not implemented in this database·Explore IGF module →