Results for “disbursement_accpt_amount”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGFBV_PELL_DISBURSEMENTS is a base database view within the Oracle E-Business Suite IGF (Financial Aid) product family. In the 12.1.1 and 12.2.2 release context, the IGF module supported the administration of federal student financial aid, and this view exposes Pell Grant disbursement records that originate from the financial aid processing tables. The view presents one row per disbursement transaction, joining disbursement detail with origination and student base-record information.

The ETRM metadata classifies this object as obsolete and records that it is "not implemented in this database." This means the view may exist in a historical or pre-migration schema but is not present in a running 12.2.2 instance. Its primary role was reporting and integration: presenting a denormalized, read-only projection of Pell disbursement data for financial aid staff, downstream reporting, and interface extraction. The view text terminates with WITH READ ONLY, confirming its intended use as a query-only construct rather than an updateable entity.

Users searching on "disbursement_amount" typically arrive here because the view exposes the column DISBURSEMENT_AMOUNT, the primary monetary measure for Pell disbursements.

Underlying Base Objects

The documented view text defines IGFBV_PELL_DISBURSEMENTS over three base tables, all in the IGF schema:

• IGF_GR_RFMS_DISB_ALL RFMD — the disbursement detail table. It is the driving table and supplies the reference number, dates, amounts, debit/credit flag, status, edit code, and audit columns.
• IGF_GR_RFMS_ALL RFMS — the origination record table, joined on ORIGINATION_ID.
• IGF_AP_FA_BASE_REC_ALL FABASE — the financial aid base record table, joined to RFMS on BASE_ID, supplying PERSON_ID.

The join path is therefore FABASE → RFMS → RFMD via BASE_ID and ORIGINATION_ID, producing a disbursement-level result set enriched with the student's person identifier. The ETRM "referenced base objects" field is empty, but the embedded view SQL is authoritative and lists all three tables and their aliases. Because these are _ALL tables, the view is not partitioned by business group; consumer queries should filter on the appropriate operating unit or person context as required.

Key Columns

The column set can be grouped by function:

• DISBURSEMENT_REFERENCE_NUMBER — the disbursement reference (RFMD.DISB_REF_NUM), a natural identifier for a payment.
• DISBURSEMENT_AMOUNT — the disbursed monetary value (RFMD.DISB_AMT); the principal measure behind the "disbursement_amount" search.
• DISBURSEMENT_DATE and DISBURSEMENT_STATUS_DATE — the disbursement effective date and its status date.
• DEBIT_CREDIT_FLAG — indicates whether the amount is a debit or credit; the companion ACCPT_DEBIT_CREDIT_FLAG serves the same role for the accepted amount.
• DISBURSEMENT_ACCPT_AMOUNT and ACCPT_DISBURSEMENT_DATE — the accepted (confirmed) amount and its date.
• DISBURSEMENT_YTD_AMOUNT — the year-to-date disbursement total for the student.
• PAYMENT_PERD_START_DATE and ACCPT_PYMT_PRD_START_DATE — payment period start dates for the disbursement and its accepted counterpart.
• "_LA:DISBUR_ACK_ACT_STATUS" — a descriptive flexfield/LOV-backed column resolved through IGF_LOOKUPS_VIEW against IGF_GR_ORIG_STATUS, returning the acknowledgment activity status meaning.
• ORIGINATION_ID, RFMB_ID, RFMD_ID, EDIT_CODE, ED_USE_FLAGS — originating loan/award identifiers, the base record link, and federal edit/use flags.
• PERSON_ID — the student identifier from FABASE.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include reconciling Pell disbursements by student and payment period, reporting year-to-date totals, and extracting accepted versus originated amounts for interfaces. A representative query is:

• SELECT disbursement_reference_number, disbursement_date, disbursement_amount, disbursement_ytd_amount, person_id FROM igfbv_pell_disbursements WHERE person_id = :p_person AND disbursement_date BETWEEN :p_from AND :p_to;
• SELECT person_id, SUM(disbursement_amount) FROM igfbv_pell_disbursements GROUP BY person_id; — aggregation for totals.
• SELECT d.disbursement_amount, d."_LA:DISBUR_ACK_ACT_STATUS" FROM igfbv_pell_disbursements d WHERE d.debit_credit_flag = 'C'; — filtering credits with the LOV-resolved status.

Note that on a 12.2.2 instance where the metadata reports the view as not implemented, queries will fail with an invalid identifier; consumers must confirm object availability before relying on it.