Search Results inst_cross_ref_code




Overview
Explore in AI Chat

Overview

IGFFV_PELL_YTD_DISBURSEMENTS is an Oracle E-Business Suite business intelligence system view owned by the APPS schema and registered under FND Design Data as IGF.IGFFV_PELL_YTD_DISBURSEMENTS. It is documented as a full view for the entity that holds year-to-date disbursement information, presented in a form suitable for reporting and integration rather than transactional update. In the context of Oracle EBS 12.1.1 and 12.2.2, this view belongs to the Financial Aid / Student Systems product family (IGF modules), which supports Pell Grant processing and Title IV disbursement tracking. The view exposes the disbursement activity accumulated within a given award year so that institutions can reconcile, report, and monitor federal student aid disbursements against origination records.

The view is especially relevant to the column INST_CROSS_REF_CODE, which appears as the leading column in the view definition. This field is described as carrying cross-reference information useful to an institution for internally identifying student records. Because the view is business-intelligence oriented, it is intended for read-only query access, typically from reporting tools, extracts, or downstream integrations rather than from online transaction forms.

Underlying Base Objects

According to the documented dependency information, APPS.IGFFV_PELL_YTD_DISBURSEMENTS references the base object APPS.IGF_GR_YTD_DISB_ALL. No further base objects are documented, and the view itself is not referenced by any other database object, confirming its position as a terminal, reporting-facing object. The _ALL suffix on the base object indicates that the underlying storage is not partitioned by operating unit in the same way as many subledger tables; the view therefore presents a consolidated record set without the multi-org filtering typical of operating-unit-specific views. Because only one base object is documented, the view is understood to be a comparatively thin projection over IGF_GR_YTD_DISB_ALL, reshaping year-to-date disbursement records into a stable, denormalized presentation layer.

Key Columns

  • INST_CROSS_REF_CODE (VARCHAR2, 30) — Institution-defined cross-reference identifier used internally to associate the disbursement record with a student or institutional record.
  • _LA:ACTION_CODE (CHAR, 65) — Lookup tag indicating the action to be taken; the _LA: prefix denotes a lookup-tagged attribute surfaced for descriptive flexfield or lookup resolution.
  • DISBURSEMENT_REFERENCE_NUMBER (VARCHAR2, 30) — Identifier of the disbursement.
  • DISBURSEMENT_ACCEPTED_AMOUNT (NUMBER, 12) — Accepted disbursement amount for the student.
  • DEBIT_CREDIT_FLAG (VARCHAR2) — Indicates whether the disbursement amount is positive or negative.
  • DISBURSEMENT_DATE (DATE) — Date the disbursement is made to the student.
  • PAYMENT_PERD_START_DATE (DATE) — Begin date of the payment period.
  • DISBURSEMENT_BATCH_ID (VARCHAR2, 30) — Institution-generated identifier for a batch of disbursement records.
  • ORIGINATION_ID (VARCHAR2, 30) — Unique code for each origination.
  • YTDDS_ID (NUMBER) — Identifier for each year-to-date origination record.
  • WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, providing standard audit lineage.

Common Use Cases and Queries

The primary use case is year-to-date Pell disbursement reconciliation. Institutions match disbursement activity against origination records by ORIGINATION_ID and YTDDS_ID, and use INST_CROSS_REF_CODE to bridge to their own student identifiers when reporting outside EBS. Batch monitoring uses DISBURSEMENT_BATCH_ID, while financial reconciliation uses DISBURSEMENT_ACCPTED_AMOUNT together with DEBIT_CREDIT_FLAG to derive net totals.

A representative query restricting to a single institution cross-reference follows:

  • SELECT YTDDS_ID, ORIGINATION_ID, DISBURSEMENT_REFERENCE_NUMBER, DISBURSEMENT_ACCPTED_AMOUNT, DEBIT_CREDIT_FLAG, DISBURSEMENT_DATE FROM APPS.IGFFV_PELL_YTD_DISBURSEMENTS WHERE INST_CROSS_REF_CODE = :p_cross_ref;

A second pattern aggregates net disbursed amounts by payment period for reporting:

  • SELECT PAYMENT_PERD_START_DATE, SUM(DECODE(DEBIT_CREDIT_FLAG,'C',-1,1) * DISBURSEMENT_ACCPTED_AMOUNT) NET_AMT FROM APPS.IGFFV_PELL_YTD_DISBURSEMENTS GROUP BY PAYMENT_PERD_START_DATE ORDER BY 1;

Both patterns treat the view strictly as a read-only source, consistent with its status as a business intelligence system view.