Search Results ytdds_id




Overview
Explore in AI Chat

Overview

The view IGFFV_PELL_YTD_DISBURSEMENTS is a full-view object defined within the Oracle E-Business Suite Financial Aid module (IGF). Its documented purpose is to expose the entity that holds year-to-date (YTD) disbursement data, presenting a denormalized, read-only projection over the underlying YTD disbursement records. The view is classified as obsolete within the ETRM documentation, and the metadata explicitly states that it is "Not implemented in this database." This status is significant: while the view definition remains available as reference material, it is not instantiated or supported in the current 12.1.1 / 12.2.2 environment, and consumers should not assume its availability at runtime.

The object carries the designation "Full View," indicating that it surfaces the complete column set of the base entity rather than a restricted subset. In the context of financial aid processing and third-party Pell Grant reporting, such views historically served as stable integration surfaces, allowing downstream reporting tools, extracts, and custom extensions to read disbursement data without binding directly to the transactional table structure.

Underlying Base Objects

The view text confirms that IGFFV_PELL_YTD_DISBURSEMENTS is defined over a single base object: IGF_GR_YTD_DISBURSEMENTS_ALL, aliased as YTDDS. All columns in the SELECT list are drawn from this table. The query is declared WITH READ ONLY, enforcing non-modifiable access semantics; no DML is possible through it.

Notably, the ETRM "Documented view metadata" section records no referenced base objects, and the owner field is blank. This omission reflects the view's obsolete and unimplemented status rather than a true absence of a defining table; the view text itself provides the authoritative relationship. The naming convention is consistent with EBS Financial Aid views, where the _ALL suffix on the base table signals a multi-organization or partitioned data structure.

Key Columns

The view exposes the full YTD disbursement record set. Primary and business-critical columns include:

Common Use Cases and Queries

Because the view is read-only and unimplemented in the current 12.1.1 / 12.2.2 database, its historical use cases are primarily reconciliation and reporting against the base table when the view existed. A representative query retrieving YTD disbursement activity by batch would take the following form:

  • SELECT ytdds_id, disbursement_reference_number, disbursement_accpted_amount, debit_credit_flag, disbursement_date, disbursement_batch_id FROM igffv_pell_ytd_disbursements WHERE disbursement_batch_id = :p_batch ORDER BY disbursement_date;

For a YTD amount total by origination, the following aggregation applies:

  • SELECT origination_id, SUM(disbursement_accpted_amount) ytd_accepted FROM igffv_pell_ytd_disbursements GROUP BY origination_id;

Administrators validating the object's status in 12.1.1 or 12.2.2 may query ALL_VIEWS or DBA_VIEWS for the view name to confirm precedence. Given the obsolete classification, the recommended approach is to query IGF_GR_YTD_DISBURSEMENTS_ALL directly, applying equivalent column projections and read-only access to achieve the same reporting outcome.