Search Results accpt_pymt_prd_start_date

Overview

IGFBV_PELL_DISBURSEMENTS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as IGF.IGFBV_PELL_DISBURSEMENTS. It is part of the Financial Aid module (IGF), which supports the administration of Title IV federal student aid, including the William D. Ford Federal Direct Loan and Pell Grant programs. The view exposes disbursement-level records associated with Pell Grant awards, presenting each disbursement together with its accepted amount, acknowledgement status, payment period dates, and Federal Reporting and Management System (RFMS) identifiers.

Because it is defined as a BIS view (a "base view for the entity"), its role is primarily read-oriented: it supplies a denormalized, reporting-friendly projection of Pell disbursement data for use in operational reporting, extracts, and integrations with external systems such as the Common Origination and Disbursement (COD) system and downstream financial aid data marts. In EBS 12.1.1 and 12.2.2 the view remains VALID and is typically referenced by concurrent program extracts and Oracle Business Intelligence / Discoverer reporting layers rather than being updated directly by end users.

Underlying Base Objects

The ETRM metadata documents the view as a Business Intelligence System view but does not enumerate the referenced base tables in the excerpt provided; the documented referenced base objects list is empty. In practice, views in the IGF schema of this naming convention (IGFBV_%) are defined over the corresponding IGF base tables that store disbursement and disbursement-acceptance transactions, joined to lookup and person tables. The presence of columns such as DISBURSEMENT_REFERENCE_NUMBER, DISBURSEMENT_DATE, DISBURSEMENT_AMOUNT, and DISBURSEMENT_STATUS_DATE indicates a core disbursement entity, while the "ACCPT_" prefixed columns (ACCPT_DISBURSEMENT_DATE, DISBURSEMENT_ACCPT_AMOUNT, ACCPT_PYMT_PRD_START_DATE) reflect the acceptance or acknowledgement record associated with that disbursement. WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and PERSON_ID confirm a standard Oracle base-table lineage.

Because the view joins disbursement and acceptance data in a single row image, a single logical Pell disbursement can carry both the originally reported values and the student-accepted values, which is why the acceptance date fields are separated from the corresponding disbursement date fields.

Key Columns

• DISBURSEMENT_REFERENCE_NUMBER — the disbursement identifier used in COD/RFMS communication.
• DISBURSEMENT_DATE / ACCPT_DISBURSEMENT_DATE — the date the disbursement was made versus the date it was accepted.
• DISBURSEMENT_AMOUNT / DISBURSEMENT_ACCPT_AMOUNT — the reported and accepted disbursement amounts, each accompanied by a debit/credit flag.
• _LA:DISBUR_ACK_ACT_STATUS — a lookup tag conveying the acknowledgement processing status of the disbursement.
• DISBURSEMENT_STATUS_DATE — the date on which the disbursement status last changed.
• PAYMENT_PERD_START_DATE and ACCPT_PYMT_PRD_START_DATE — the begin date of the payment period and, importantly for the searched term, the accepted begin date of the payment period (accpt_pymt_prd_start_date). This distinction matters because a student's acceptance may shift or confirm the payment period start used in subsequent reporting and reconciliation.
• DISBURSEMENT_YTD_AMOUNT — total disbursed to the student for the award year.
• EDIT_CODE — error code returned from the government.
• RFMB_ID, RFMD_ID, ORIGINATION_ID — RFMS/COD batch and disbursement identifiers.
• ED_USE_FLAGS — Electronic Data Exchange usage indicator.
• PERSON_ID and WHO columns — student identity and audit information.

Common Use Cases and Queries

The most frequent use is reconciliation of Pell disbursements against accepted amounts and payment period dates. accpt_pymt_prd_start_date is typically used to align accepted disbursements to the correct payment period when producing COD reporting extracts or resolving period-mapping discrepancies.

SELECT disbursement_reference_number
     , person_id
     , disbursement_amount
     , disbursement_accpt_amount
     , disbursement_date
     , accpt_disbursement_date
     , payment_perd_start_date
     , accpt_pymt_prd_start_date
  FROM apps.igfbv_pell_disbursements
 WHERE accpt_pymt_prd_start_date >= :p_from_date
   AND accpt_pymt_prd_start_date <  :p_to_date
 ORDER BY person_id, accpt_pymt_prd_start_date;

Other common scenarios include identifying disbursements whose accepted payment period start differs from the originally reported value, extracting EDIT_CODE rows for error resolution, and feeding RFMS identifiers into federal reporting batches. Because the view is read-only and defined over base IGF tables, queries should be scoped by person and award year to limit the result set.