Search Results pending_amount




Overview
Explore in AI Chat

Overview

IGFBV_PELL_ORIGINATIONS is a base view owned by the APPS schema in Oracle E-Business Suite, delivered under the IGF (Financial Aid) product module. It is a valid, read-only database object that serves as the foundation for the entity storing all RFMS (Recipient Financial Management System) data that must be transmitted to the COD (Common Origination and Disbursement) system. The view is therefore central to the federal Pell Grant origination and disbursement workflow within Oracle Student Financial Aid, providing the logical presentation layer from which COD submission records are extracted and formatted.

In both 12.1.1 and 12.2.2, the view retains the same definition and column structure. It exposes origination-level attributes such as verification status, enrollment status, cost of attendance, payment method, and anticipated disbursement dates, along with the PENDING_AMOUNT column referenced by the user's search. Because the view is defined WITH READ ONLY, it supports query and reporting access only and cannot be used as an update target.

Underlying Base Objects

The view is defined over two foundational tables joined on the BASE_ID column:

  • IGF_GR_RFMS_ALL — the primary RFMS staging and origination table holding Pell Grant accepted origination records (aliased RFMS).
  • IGF_AP_FA_BASE_REC_ALL — the base person record table (aliased FABASE), which supplies the PERSON_ID linkage.

The join FABASE.BASE_ID = RFMS.BASE_ID ties each RFMS origination row to the corresponding financial aid base record, enabling downstream integration to resolve the student identity. Several columns are expressed through lookup decode expressions (for example, _LA:RFMS.VER_STATUS_CODE:IGF_LOOKUPS_VIEW...), which resolve coded values into human-readable meanings at query time via the IGF_LOOKUPS_VIEW view and its associated lookup types (IGF_GR_VER_STAT_CD, IGF_GR_RFMS_ENROL_STAT, IGF_GR_ORIG_STATUS, and others).

Key Columns

  • ORIGINATION_ID — Primary identifier for the origination record.
  • TRANSACTION_NUMBER — COD transaction sequence number for the origination.
  • EFC / SECONDARY_EFC — Expected Family Contribution values, including primary and secondary.
  • PELL_AMOUNT / FT_PELL_AMOUNT — Awarded Pell Grant amount and full-time Pell amount.
  • PENDING_AMOUNT — The Pell amount pending transmission, acceptance, or disbursement; used to track unsettled origination balances.
  • COA_AMOUNT — Cost of attendance used in the award calculation.
  • ENROLLMENT_STATUS / ENROLLMENT_DT — Enrollment status and effective date.
  • EST_DISB_DT1 — Estimated disbursement date.
  • ORIG_ACTION_CODE / ORIG_STATUS_DT — Origination action and its status date.
  • TOTAL_PYMT_PRDS — Total payment periods for the academic period.
  • AWARD_ID / RFMB_ID / BASE_ID — Foreign keys linking to award, RFMS master, and base person records.
  • PERSON_ID — Person identifier resolved from the base table.

Common Use Cases and Queries

This view is commonly queried to extract pending Pell origination data for COD submission, reconcile amounts awaiting acceptance, and report on unresolved origination actions.

Pending amounts by origination:

SELECT ORIGINATION_ID, TRANSACTION_NUMBER, PELL_AWARD, PENDING_AMOUNT
FROM   APPS.IGFBV_PELL_ORIGINATIONS
WHERE  PENDING_AMOUNT > 0;

Originations by person and status:

SELECT PERSON_ID, ORIGINATION_ID, EFC, PELL_AWARD, PENDING_AMOUNT
FROM   APPS.IGFBV_PELL_ORIGINATIONS
WHERE  PERSON_ID = :p_person_id;

Because the view is read-only, it is appropriate for integration extraction, concurrent reporting, and reconciliation queries against the underlying RFMS staging data.