Search Results batch_id_txt

Overview

IGF_AW_DB_CHG_DTLS_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite, registered in FND Design Data as IGF.IGF_AW_DB_CHG_DTLS_V. It belongs to the Oracle Student Financial Aid / Awards (IGF) product family and exposes award disbursement change details in a denormalized, form-friendly shape. The view is explicitly documented as a "supplementary view used to simplify forms coding," which means it exists primarily to support the IGF Awards disbursement maintenance forms rather than to serve as a public integration interface.

From a reporting standpoint, the view presents one row per award disbursement change transaction, combining identifiers (award, disbursement number and sequence), monetary amounts, status and activity codes with their decoded descriptions, and a set of period and batch attributes. Because Oracle classifies the object as Oracle Internal Use Only, direct querying outside of standard Oracle Applications programs is neither supported nor recommended, and the column list may change substantially between minor or major releases. The search term "pymnt_prd_start_date" resolves directly to the PYMNT_PRD_START_DATE column, a DATE column described as the payment period start date — the point in time from which a given disbursement's payment period is counted.

Underlying Base Objects

The ETRM metadata for this 12.2.2 entry documents no referenced base objects, so the view's dependency list is not published at this level. In practice, a view of this name in the IGF schema is defined over the award disbursement change/detail tables (the IGF_AW_DB_* family), joined to lookup or reference tables that supply the decoded values appearing in the *_DESC columns, and it also surfaces standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY and the associated audit fields) from the underlying transactional rows. Because the dependency information is not documented here, the safest operational assumption is that the view is layered over one or more internal IGF disbursement tables and is intended to be consumed as a single logical row source rather than reverse-engineered. Any querying should be validated against the current instance's USER_DEPENDENCIES and the view's actual DDL.

Key Columns

• AWARD_ID — the internal award identifier; the primary join key back to the award header.
• DISB_NUM / DISB_SEQ_NUM — disbursement number and its sequence within the award, together identifying the disbursement line.
• PYMNT_PRD_START_DATE — payment period start date; the searched column, used to determine when the payment period for the disbursement begins.
• DISB_ACCEPTED_AMT, ORIG_FEE_AMT, DISB_NET_AMT, INTEREST_REBATE_AMT — the accepted, origination fee, net and interest rebate amounts for the disbursement.
• DISB_DATE, ACK_DATE, BOOKING_DATE, DISB_STATUS_DATE — the disbursement date and related acknowledgement, booking and status-change dates.
• DISB_ACTIVITY / DISB_ACTIVITY_DESC, DISB_STATUS / DISB_STATUS_DESC — coded values paired with their decoded descriptions for display.
• DISB_REL_FLAG, FIRST_DISB_FLAG, DISB_CONF_FLAG — indicator flags for release, first disbursement and confirmation.
• BATCH_ID_TXT, BOOKING_ID_TXT, NOTE_MESSAGE, ROW_ID — batch and booking identifiers, a free-text note, and the row identifier.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY — standard Who audit columns.

Common Use Cases and Queries

Typical uses are form support for disbursement changes and investigative reporting on award disbursement activity, payment periods and status transitions. A representative query retrieving disbursements with their payment period start date is:

SELECT award_id, disb_num, disb_seq_num, disb_date, pymnt_prd_start_date, disb_status, disb_status_desc, disb_net_amt FROM apps.igf_aw_db_chg_dtls_v WHERE pymnt_prd_start_date >= :p_from_date AND pymnt_prd_start_date < :p_to_date ORDER BY award_id, disb_num, disb_seq_num;

A second pattern filters on disbursement state and release flag for reconciliation or troubleshooting:

SELECT award_id, disb_num, disb_seq_num, disb_activity_desc, disb_rel_flag, first_disb_flag, disb_conf_flag FROM apps.igf_aw_db_chg_dtls_v WHERE disb_status = :p_status AND disb_rel_flag = 'Y';

Because the view is unsupported for direct data access, any such queries should be treated as diagnostic only, executed against a copy where possible, and revalidated after patching or upgrade, since the column set can change between releases.