Search Results igf_aw_awd_disb_v




Overview
Explore in AI Chat

Overview

The IGF_AW_AWD_DISB_V view is a reporting and integration object within the IGF – Financial Aid product of Oracle E-Business Suite (available in both 12.1.1 and 12.2.2). Owned by the APPS schema, it exposes line-level detail for every disbursement associated with an award. A disbursement represents the actual release (or intended release) of financial aid funds to a student, and this view consolidates the scheduling, monetary, status, and lifecycle attributes that surround that release.

The view does not simply project columns from a single base table. It joins the award disbursement record to the academic calendar instance that defines the disbursement period and to a separate calendar instance for the loan/late-disbursement period. It also dereferences several coded columns into human-readable meanings through calls to IGF_AW_GEN.LOOKUP_DESC. This design makes the view a self-contained presentation layer: consumers receive fully decoded status, transaction type, eligibility, hold-release, and fund-status values without needing to resolve lookup codes themselves.

Because it is a database view registered in ETRM with status VALID, it is safe to reference in custom reports, extracts, and interfaces across both the 12.1.1 and 12.2.2 application versions. It is particularly relevant to users who searched for the igf_sl_cl_disb_status lookup type, since that lookup is embedded directly in the view to translate the DISB_STATUS code into a meaningful description.

Underlying Base Objects

The documented ETRM metadata for this object records no explicitly listed base tables; the view definition is supplied through the reflected view text. From that text, the principal underlying objects are:

The view therefore behaves as a denormalized read model over the disbursement transaction, its period calendars, and the IGF lookup framework.

Key Columns

Common Use Cases and Queries

Typical scenarios include award-disbursement tracking, funds-disbursed reporting, and feeds to downstream payment or student systems. A straightforward disbursement-status report joins the view to the award header:

SELECT d.award_id, d.disb_num, d.disb_status,
       d.disb_net_amt, d.disb_date
FROM   igf_aw_awd_disb_v d
WHERE  d.disb_status = :p_status
ORDER BY d.award_id, d.disb_num;

To reconcile paid versus accepted funds within a period, filter on the calendar instance:

SELECT d.tp_cal_type, d.alternate_code,
       SUM(d.disb_paid_amt), SUM(d.disb_accepted_amt)
FROM   igf_aw_awd_disb_v d
WHERE  d.tp_cal_type = :cal_type
GROUP BY d.tp_cal_type, d.alternate_code;

Because IGF_SL_CL_DISB_STATUS is already resolved in the view, reporting tools and extracts can display the status meaning directly without a separate lookup query, and modules such as billing or third-party interfaces can filter on SHOW_ON_BILL and FUND_STATUS to decide which disbursements to surface.