Search Results statement_end_date




Overview
Explore in AI Chat

Overview

APPS.IGFFV_DL_YTD_SUMMARY is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Financial Aid module, owned by the APPS schema and registered under FND Design Data object IGF.IGFFV_DL_YTD_SUMMARY. It exposes a full view of the entity that holds Year-to-Date Direct Loan Summary information, presenting aggregated disbursement figures reported to the U.S. Department of Education for the Federal Direct Loan program. The view is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and is flagged as a "Full View" BI system view rather than an application-facing transactional object. In practice, it functions as a reporting and reconciliation layer over Direct Loan disbursement summaries, allowing institutions to extract booked and unbooked gross, fee, interest rebate, and net amounts grouped by school, region, state, record type, and statement period. The STATEMENT_END_DATE column, which the user searched for, is the reporting date that anchors each YTD summary record and is central to period-based reconciliation and Common Origination and Disbursement (COD) reporting.

Underlying Base Objects

The ETRM metadata for this object documents no referenced base objects, which is consistent with Business Intelligence System views in Oracle EBS that are frequently defined over internal staging or summary tables not published in the standard dependency extract. What is firmly documented is the view's FND design data registration (IGF.IGFFV_DL_YTD_SUMMARY) and its status as a valid BIS view. Its column set — including YEAR_TO_DATE_DISB_SUMMARY_ID, BATCH_ID, and standardized WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) — indicates it is defined over a persistent Direct Loan year-to-date disbursement summary base table in the IGF schema. The presence of WHO columns confirms the underlying entity is a standard Oracle EBS table with audit tracking, while BATCH_ID links records to the batch load or COD submission process that populated them.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling COD YTD gross and net disbursement totals, validating booked versus unbooked balances by statement period, and auditing batch-level reporting. The STATEMENT_END_DATE column supports period-driven extracts. For example, to retrieve the latest YTD summary by school:

SELECT school_code, statement_end_date, booked_gross_amount, booked_net_amount, unbooked_net_amount
FROM apps.igffv_dl_ytd_summary
WHERE record_type = 'YTD'
AND statement_end_date BETWEEN :p_start_date AND :p_end_date
ORDER BY school_code, statement_end_date;

A second common pattern aggregates booked net amounts across schools for a single statement period to support regulatory filing checks:

SELECT school_code, SUM(booked_net_amount) booked_net
FROM apps.igffv_dl_ytd_summary
WHERE statement_end_date = :p_statement_end_date
GROUP BY school_code;

Because the view is a BIS reporting object, queries should remain read-only and account for the possibility of large volumes by filtering on STATEMENT_END_DATE, SCHOOL_CODE, or BATCH_ID.