Search Results inst_cross_ref_code




Overview
Explore in AI Chat

Overview

The view IGFBV_PELL_YTD_DISBURSEMENTS is a base view within the Oracle E-Business Suite IGF – Financial Aid module, a product line that is documented as Obsolete in Oracle EBS 12.1.1 and 12.2.2. Its stated purpose is to present the entity holding year-to-date (YTD) disbursement data, providing a read-only projection of the underlying YTD disbursement records for reporting and inquiry purposes. The view exposes instructional cross-reference codes, disbursement reference numbers, accepted disbursement amounts, debit/credit indicators, and associated date and audit columns, making it suitable for Pell Grant disbursement reconciliation and financial aid disbursement analysis.

Because the underlying module is obsolete, the view is not implemented in the current database. The ETRM metadata explicitly records “Not implemented in this database,” meaning the view definition exists only as documented reference material and does not generate a physical object in a supported environment.

Underlying Base Objects

The view text selects exclusively from a single base table, IGF_GR_YTD_DISB_ALL, aliased as YTDDS, and is defined with the WITH READ ONLY clause. No additional base objects are documented in the ETRM metadata; the referenced base object list is empty beyond the one table identified in the view text.

The naming convention of the base table follows the IGF Grants (GR) object family, with the _ALL suffix indicating a multi-organization or reporting-enabled table. The view is named with the IGFBV prefix, denoting a base view (as opposed to a security or summary view), and its relationship to the base table is a direct, non-joined projection: every column in the view maps to a column in IGF_GR_YTD_DISB_ALL. Because the view is read only and definitionally bound to a single table, it introduces no aggregation or transformation logic beyond the _LA lookup substitution described below.

Key Columns

The view exposes the following principal columns:

Common Use Cases and Queries

Typical use cases include YTD disbursement reporting, Pell Grant disbursement reconciliation, and analysis of debit/credit activity for accepted disbursements by institution and batch. A representative query filtering on the debit/credit flag is:

  • SELECT inst_cross_ref_code, disbursement_reference_number, disbursement_accpted_amount, debit_credit_flag, disbursement_date FROM igfbv_pell_ytd_disbursements WHERE debit_credit_flag = 'C';
  • Aggregation of accepted amounts by payment period start date for a given origination identifier.
  • Joining to the lookup meaning returned by the _LA action code column for action reporting.

Because the object is obsolete and not implemented, these queries are illustrative of the documented structure rather than executable in current EBS 12.1.1 or 12.2.2 installations.