Search Results disbursement_reference_number




Overview
Explore in AI Chat

Overview

APPS.IGFBV_PELL_YTD_DISBURSEMENTS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data IGF.IGFBV_PELL_YTD_DISBURSEMENTS in the Financial Aid (IGF) product family. The view exposes the year-to-date (YTD) disbursement data maintained for Title IV Pell Grant awards within the Oracle Student Financial Aid and Pell processing modules. Its documented status is VALID.

As a BIS view rather than a transactional entity, it presents a denormalized, read-optimized projection of YTD disbursement records suitable for operational reporting, reconciliation, and downstream integration. Institution-level personnel and integration developers query it to confirm what disbursement amounts have been accepted for a given student, award year, and payment period, and to reconcile those amounts against COD (Common Origination and Disbursement) submissions.

Underlying Base Objects

The documented dependency for this view is APPS.IGF_GR_YTD_DISB_ALL, an APPS-owned base object that stores the underlying year-to-date disbursement records. The view is not referenced by any other database object, confirming its role as a terminal reporting layer rather than a component of further dependency chains. Because it is defined over a single base object with no documented joins, the view is effectively a filtered/reshaped projection of IGF_GR_YTD_DISB_ALL and inherits its granter, with no additional data transformation beyond column exposure and naming.

Key Columns

Common Use Cases and Queries

Typical uses include auditing disbursement batches, reconciling accepted YTD amounts against COD, and isolating negative (debit/credit) adjustments. To retrieve all disbursement records for a specific batch:

SELECT INST_CROSS_REF_CODE,
       DISBURSEMENT_REFERENCE_NUMBER,
       DISBURSEMENT_ACCPTED_AMOUNT,
       DEBIT_CREDIT_FLAG,
       DISBURSEMENT_DATE,
       PAYMENT_PERD_START_DATE,
       ORIGINATION_ID,
       YTDDS_ID
FROM   APPS.IGFBV_PELL_YTD_DISBURSEMENTS
WHERE  DISBURSEMENT_BATCH_ID = :batch_id
ORDER  BY DISBURSEMENT_DATE;

To summarize accepted amounts per batch:

SELECT DISBURSEMENT_BATCH_ID,
       SUM(DISBURSEMENT_ACCPTED_AMOUNT) total_accepted
FROM   APPS.IGFBV_PELL_YTD_DISBURSEMENTS
GROUP  BY DISBURSEMENT_BATCH_ID;

Because the view is a BIS object, it is intended for query access only; no DML should be directed against it.