Search Results igf_aw_db_cod_dtls_v

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

• AWARD_ID — Foreign key to the financial aid award record; the primary anchor for correlating disbursements with awards and students.
• DOCUMENT_ID_TXT — The COD document identifier, stored as text, used to reference the disbursement record in COD external communications.
• DISB_NUM and DISB_SEQ_NUM — The disbursement number and its sequence within the award, together forming the natural key for a specific disbursement instance.
• DISB_ACCEPTED_AMT — The disbursement amount accepted by COD.
• ORIG_FEE_AMT — Origination fee applied to the disbursement.
• DISB_NET_AMT — The net disbursement amount, net of fees such as the origination fee. This column is the object of the user's search and is the most commonly referenced monetary figure for reconciliation, cash posting, and COD response processing.
• DISB_DATE — Date the disbursement is scheduled or recorded.
• DISB_REL_FLAG, FIRST_DISB_FLAG, DISB_CONF_FLAG — Status indicators for release, first-disbursement designation, and COD confirmation.
• INTEREST_REBATE_AMT — Interest rebate amount associated with the disbursement.
• PYMNT_PER_START_DATE — Start of the payment period covered by the disbursement.
• REP_ENTITY_ID_TXT and ATD_ENTITY_ID_TXT — Reporting entity and additional entity identifiers used in COD transmission.
• NOTE_MESSAGE — Free-text note attached to the disbursement record.
• Standard WHO and concurrent columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — supporting audit and concurrent request traceability.

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.