Search Results institution_zip_code




Overview
Explore in AI Chat

Overview

IGFFV_PELL_MULT_REPORT_RECORDS is an APPS-owned, VALID database view within the IGF (Financial Aid) product family in Oracle EBS 12.1.1 and 12.2.2. The documented description states that it is the "Full View for the Entity that holds the information about multiple reporting records which are uploaded from an external system." In practical terms, the view exposes the complete set of columns associated with the Multiple Reporting Record (MRR) entity that institutions receive and process as part of U.S. Department of Education Title IV Pell Grant reporting.

The view functions as a read-only reporting and integration access point. Because it is defined WITH READ ONLY, it cannot be used for DML; all inserts, updates, and deletions must occur against the underlying base entity. This design supports the common EBS pattern of separating transactional tables from reporting views, and it allows integrators and report developers to query MRR data without touching the physical table directly.

Underlying Base Objects

The ETRM metadata identifies a single source object: IGF_GR_MRR_ALL, referenced with the alias GMRR. The view definition is a straightforward projection of columns from this table, with no joins, unions, or filter predicates present in the documented view text. Consequently, every row returned by the view corresponds to one row in IGF_GR_MRR_ALL, and the view adds no transformation logic other than column aliasing and the read-only constraint.

Although the documented metadata lists no referenced base objects under the 12.2.2 structure section, the view text explicitly cites IGF_GR_MRR_ALL, which is the authoritative source. Because the base object is an _ALL table in the IGF schema, it typically participates in multi-org or foreign-system data loading patterns common to Financial Aid integrations, though this characteristic derives from the table rather than from the view itself.

Key Columns

The view exposes thirty-nine documented columns. Notable groupings include:

The column SCHD_PELL_GRANT (scheduled Pell grant) is directly relevant to the user's search term schd_pell_grant, which matches the view column SCHD_PELL_GRANT.

Common Use Cases and Queries

Typical use cases include auditing uploaded MRR files, reconciling scheduled versus disbursed Pell amounts, and driving downstream Financial Aid reporting. A basic query selecting all records for a Pell identifier is:

SELECT mrr_id, multi_rep_student_id, stud_last_name, schd_pell_grant, orig_awd_amount
FROM apps.igffv_pell_mult_report_records
WHERE institution_pell_id = :p_pell_id;

To isolate records where the scheduled Pell grant differs from the original award amount:

SELECT mrr_id, schd_pell_grant, orig_awd_amount, disb_accepted_amount
FROM apps.igffv_pell_mult_report_records
WHERE schd_pell_grant <> orig_awd_amount;

Because the view is read-only and selects directly from IGF_GR_MRR_ALL, queries should be constrained by indexed columns such as MRR_ID or STUDENT_ORIGINAL_SSN wherever possible. Note that the view's column names as returned to SQL*Plus or a reporting tool correspond to the underlying table columns (for example, MRR_CODE1, STUD_ORIG_SSN), while the ETRM documentation lists alternate display labels; developers should verify actual column identifiers against the view text before writing SQL.