Search Results authorization_date




Overview
Explore in AI Chat

Overview

IGFBV_AWARD_DISBURSEMENTS is a base view owned by the APPS schema in the Oracle E-Business Suite Financial Aid (IGF) module. It is the entity view that exposes one row for each disbursement associated with a financial aid award, drawing together award-level, disbursement-level, calendar, academic period, and party identification data into a single reporting surface. Its purpose is to serve as a foundation for forms, concurrent programs, OAF pages, and integration extracts within the Financial Aid product, presenting disbursement records in a denormalized, human-readable shape.

The view is documented as VALID in ETRM for 12.2.2 and applies equally to 12.1.1 environments using the same Financial Aid schema. It should not be confused with the underlying transactional table IGF_AW_AWD_DISB_ALL, though it maps almost column-for-column from that table and adds joined descriptive attributes. This view is important for reporting on student disbursements because it joins disbursement records to student identity (HZ_PARTIES), award context, and calendar instances without requiring the report author to reconstruct the joins manually.

Underlying Base Objects

The view's FROM clause is composed of five base objects:

The view is defined WITH READ ONLY, ensuring consumers cannot issue DML against it. Lookup-displayed columns are modeled through '_LA:' pseudo-columns, which instruct the Forms/OAF layer to resolve coded values from IGF_LOOKUPS_VIEW or IGS_LOOKUP_VALUES using the appropriate lookup type.

Key Columns

Common Use Cases and Queries

Typical uses include disbursement registers, reconciliation extracts, authorization tracking, and student self-service displays. Because authorization_date is not a column on this view, a query filtering by authorization date must join out to the authorization source (for example IGF_AW_AWD_AUTH or the corresponding authorization base record) using AUTH_ID. A typical disbursement register might select:

SELECT AWARD_ID, DISB_NUM, PERSON_ID, PARTY_NUMBER, PARTY_NAME, DISB_DATE, DISB_NET_AMT, DISB_STATUS, AUTH_ID FROM APPS.IGFBV_AWARD_DISBURSEMENTS WHERE DISB_DATE BETWEEN :p_start AND :p_end;

To locate authorizations by date, the pattern is:

SELECT d.AWARD_ID, d.DISB_NUM, d.AUTH_ID, a.AUTHORIZATION_DATE FROM APPS.IGFBV_AWARD_DISBURSEMENTS d, <authorization_table> a WHERE d.AUTH_ID = a.AUTH_ID AND a.AUTHORIZATION_DATE = :p_auth_date;

The exact authorization table must be confirmed against the deployed IGF schema, since the view documentation exposes AUTH_ID but not the parent authorization table or its date column. Analysts should confirm the mapped column before relying on it.