Search Results origination_awd_amount

Overview

The view IGFBV_PELL_MULT_REPORT_RECORDS is a reporting and integration object within the Oracle E-Business Suite IGF — Financial Aid module. In the ETRM metadata provided, the module is flagged as obsolete, and the view itself is documented as "Not implemented in this database," meaning it may exist in some historical or reference environments but is not active in the current instance.

Functionally, this view serves as the base view for the entity that stores multiple reporting records uploaded from an external system. In the context of U.S. federal student aid processing, these records correspond to Pell Grant Multiple Reporting Records (MRR), which institutions exchange with the Department of Education (ED) to reconcile Pell disbursements across schools where a student is enrolled. The view presents a denormalized, read-only projection of the underlying MRR data, making it suitable for downstream reporting, extraction, and interface reconciliation. Because it is defined with the WITH READ ONLY clause, it cannot be used for DML operations and is intended solely for query and reporting access.

Underlying Base Objects

The documented view text reveals that IGFBV_PELL_MULT_REPORT_RECORDS is defined over a single base object: IGF_GR_MRR_ALL (aliased as GMRR). The view performs no joins, unions, or aggregations; it is a straightforward column projection from the base table.

• IGF_GR_MRR_ALL — The primary table holding Multiple Reporting Record data uploaded from the external system.
• No other referenced objects — ETRM metadata explicitly documents no additional base objects or dependencies.
• Read-only projection — The WITH READ ONLY clause enforces non-updatable behavior, consistent with a reporting view role.

Although the metadata lists referenced base objects as "none documented" at the view level, the view SQL unambiguously ties the view to IGF_GR_MRR_ALL. Note that the SQL column aliases (e.g., MRR_CODE1, MR_STUD_ID) differ from the documented column names (e.g., MULTI_REP_REC_CODE1, MULTI_REP_STUDENT_ID), suggesting a renaming convention applied at the reporting layer for clarity.

Key Columns

The view exposes a wide set of columns describing institutional, student, origination, and disbursement details for each MRR record. Notable columns include:

• RECORD_TYPE — Classifies the type of multiple reporting record.
• MULTI_REP_REC_CODE1 / MULTI_REP_REC_CODE2 — MRR codes used for reconciliation against ED records.
• MULTI_REP_STUDENT_ID — The student identifier associated with the MRR.
• MULTI_REP_INSTITN_PELL_ID — Institution Pell ID associated with the multiple reporting record.
• INSTITUTION_PELL_ID / INSTITUTION_NAME — The reporting institution's Pell identifier and name.
• REQ_INST_PELL_ID — The requested/required institution Pell ID. This column aligns with the user's search term req_inst_pell_id and is central to identifying the institution Pell identifier required for MRR matching.
• INST_PELL_ID (from GMRR.INST_PELL_ID) — The institution Pell ID as stored on the base record.
• SCHD_PELL_GRANT / ORIGINATION_AWD_AMOUNT / DISB_ACCEPTED_AMOUNT — Award and disbursement amounts used for reconciliation.
• TRANSACTION_NUMBER — Transaction identifier for the originating award.
• EFC — Expected Family Contribution, a need-analysis value.
• STUD_LAST_NAME / STUD_FIRST_NAME / STUD_MIDDLE_NAME / STUDENT_DT_OF_BIRTH — Student demographic data.
• MRR_ID — Primary identifier for the MRR record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns.

Common Use Cases and Queries

This view is typically queried to support Pell MRR reconciliation reporting, ED interface troubleshooting, and institutional auditing. Since it is read-only and non-implemented in the current database, queries should be validated against available environments.

Typical query by institution Pell ID:

SELECT MRR_ID, RECORD_TYPE, MULTI_REP_STUDENT_ID, REQ_INST_PELL_ID, INSTITUTION_PELL_ID, ORIGINATION_AWD_AMOUNT, DISB_ACCEPTED_AMOUNT FROM IGFBV_PELL_MULT_REPORT_RECORDS WHERE REQ_INST_PELL_ID = :p_inst_pell_id;

Query for student-level MRR drill-down:

SELECT MRR_ID, MULTI_REP_STUDENT_ID, STUD_LAST_NAME, STUD_FIRST_NAME, RECORD_TYPE, TRANSACTION_NUMBER FROM IGFBV_PELL_MULT_REPORT_RECORDS WHERE MULTI_REP_STUDENT_ID = :p_student_id;

Reconciliation of award versus accepted amounts:

SELECT MRR_ID, ORIGINATION_AWD_AMOUNT, DISB_ACCEPTED_AMOUNT, (ORIGINATION_AWD_AMOUNT - DISB_ACCEPTED_AMOUNT) AS VAR_AMT FROM IGFBV_PELL_MULT_REPORT_RECORDS WHERE RECORD_TYPE = :p_record_type;

These patterns support financial aid offices in detecting discrepancies between originated awards and accepted disbursements, and in resolving MRR conflicts flagged by the Department of Education.