Search Results disb_date




Overview
Explore in AI Chat

Overview

IGF_AW_DB_COD_DTLS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered under the IGF (Financial Aid) product family. It exposes disbursement-level detail for COD (Common Origination and Disbursement) records processed through the financial aid award cycle. In practice, the view presents a denormalized, read-friendly projection of the disbursement COD detail table, allowing reporting tools, concurrent programs, and integration extracts to retrieve key COD disbursement attributes without navigating the full set of administrative and WHO columns maintained on the underlying entity.

The object is documented as VALID in both ETRM 12.1.1 and 12.2.2 references, meaning its definition is stable across those releases. It is a simple SELECT-from-single-table view with no aggregation, joins, or filtering logic, which makes it safe for direct query use in custom reports and for external systems that need to consume COD disbursement data in a flat structure. Because the view includes ROWID as its first column, it preserves row identification capability for the base table, though consumers should generally key on AWARD_ID, DISB_NUM, and DISB_SEQ_NUM rather than ROWID.

Underlying Base Objects

The view is defined over a single base object: IGF_AW_DB_COD_DTLS, also owned by APPS. The ETRM metadata does not document any additional referenced base objects, and the view text confirms that all columns are drawn from that one disbursement COD detail table. There are no joins to auxiliary financial aid tables, no lookup resolutions, and no outer joins hiding optional relationships.

Because the definition is a straight projection, row counts and row keys in IGF_AW_DB_COD_DTLS_V match the base table exactly. Inserts, updates, and deletions are performed against IGF_AW_DB_COD_DTLS; the view is a read vehicle and should not be treated as an integrity boundary or an alternative DML target. Any performance characteristics observed when querying the view — including index usage and predicate pushdown — are inherited directly from the base table and the indexes defined on it.

Key Columns

Common Use Cases and Queries

Typical uses include COD reconciliation reporting, net disbursement analysis, and extracts feeding downstream accounting or external COD interfaces. A representative query aggregating net disbursement by award is shown below.

SELECT award_id,
SUM(disb_net_amt) total_net_disb
FROM igf_aw_db_cod_dtls_v
GROUP BY award_id;

To isolate confirmed disbursements within a date range:

SELECT document_id_txt, disb_num, disb_seq_num, disb_net_amt, disb_date
FROM igf_aw_db_cod_dtls_v
WHERE disb_conf_flag = 'Y'
AND disb_date BETWEEN :start_date AND :end_date;

To compare accepted versus net amounts and surface fee impact:

SELECT disb_num, disb_seq_num, disb_accepted_amt, orig_fee_amt, disb_net_amt,
disb_accepted_amt - disb_net_amt fee_impact
FROM igf_aw_db_cod_dtls_v
WHERE award_id = :award_id;

Because the view is a direct projection, filtering by AWARD_ID is strongly recommended and benefits from the indexes on the base table. Reporting joins to award or person tables should be performed against AWARD_ID after extracting from this view.