Search Results disbursement_remaining_amount




Overview
Explore in AI Chat

Overview

The view IGFFV_STUDENT_FWS_AWAD_DETAILS is a full (non-incremental) reporting view within the Oracle E-Business Suite financial aid module (IGF – Financial Aid), which is documented as obsolete in ETRM 12.2.2. Its stated purpose is to present the entity that holds Student Work Study Award Details, specifically awards funded from the Federal Work Study (FWS) program. The view consolidates disbursement, award, fund, calendar, and party-identifying information into a single denormalized row per disbursement, making it suitable for federal reporting, reconciliation, and downstream integration extracts where pre-joined student award data is preferable to direct queries against the underlying normalized tables.

The view is defined with the WITH READ ONLY clause, confirming its intended role as a reporting construct rather than a data entry or transactional interface. The metadata indicates the view is not implemented in the reference database, meaning availability depends on the specific environment and module licensing.

Underlying Base Objects

Although ETRM lists no referenced base objects for this view, the embedded view text reveals a seven-table join across the IGF and IGS schemas:

The join logic requires conformance between disbursement load calendar, award base calendar, and award fund, ensuring only valid FWS disbursements are returned.

Key Columns

The view exposes derived and descriptive columns. Notably, AUTHORIZATION_DATE (mapped from DISB.AUTH_DATE in the view text) records the date on which the disbursement was authorized, and AUTHORIZATION_ID (DISB.AUTH_ID) identifies the authorizing transaction. Other significant columns include:

Common Use Cases and Queries

Typical uses include federal FWS reconciliation, monitoring authorization and disbursement status, and producing student-level award extracts. Example query targeting the searched term:

SELECT PERSON_NUMBER,
       FIRST_NAME,
       LAST_NAME,
       AWARD_YEAR,
       FUND_CODE,
       DISBURSEMENT_ACCEPTED_AMOUNT,
       DISBURSEMENT_EARNED_TILL_DATE,
       TOTAL_PERCENT_EARNED_LIMIT,
       AUTHORIZATION_DATE,
       AUTHORIZATION_ID
  FROM IGFFV_STUDENT_FWS_AWAD_DETAILS
 WHERE AUTHORIZATION_DATE IS NOT NULL
   AND AWARD_YEAR = :p_award_year
 ORDER BY AUTHORIZATION_DATE, PERSON_NUMBER;

A second pattern aggregates authorized totals by fund for reconciliation:

SELECT FUND_CODE, FUND_DESCRIPTION,
       COUNT(*) AS AUTHORIZED_DISBURSEMENTS,
       SUM(DISBURSEMENT_ACCEPTED_AMOUNT) AS TOTAL_ACCEPTED
  FROM IGFFV_STUDENT_FWS_AWAD_DETAILS
 WHERE AUTHORIZATION_DATE BETWEEN :p_from AND :p_to
 GROUP BY FUND_CODE, FUND_DESCRIPTION;

Because the object is flagged obsolete and not implemented in the reference environment, consumers should validate its presence before use and consider migration to the current financial aid data model where applicable.