Search Results igf_gr_mrr_all




Overview
Explore in AI Chat

Overview

IGF_GR_MRR_ALL is a Financial Aid module table in the IGF schema that stores Multiple Reporting Records (MRR) uploaded from an external system, typically the U.S. Department of Education's COD (Common Origination and Disbursement) system. Each row represents a reporting record associated with a student's Pell Grant activity, capturing origination, disbursement, enrollment, and eligibility details used to reconcile federal aid data within Oracle E-Business Suite. The table is a foundational staging and reference object for downstream Financial Aid processing and reconciliation reporting.

The ETRM metadata lists IGF_GR_MRR_ALL as a valid table with 46 physical columns and a primary key constraint (IGF_GR_MRR_ALL_PK) on MRR_ID. A heuristic Data Vault classification mined from the foreign key structure identifies this object as standalone, meaning it is not modeled as a dependent child of a parent hub. In Data Vault terms, this suggests treating MRR_ID as a hub-like business key with associated descriptive attributes forming a satellite, rather than as a link between entities.

Key Information Stored

The surrogate primary key is MRR_ID, which is also the sole documented unique index candidate (IGF_GR_MRR_ALL_U1), making it the definitive business key. The most significant descriptive columns include:

Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and multi-org/request columns (ORG_ID, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE) are present and support concurrency, audit, and concurrent program traceability.

Common Use Cases and Queries

Typical scenarios include reconciling external Pell Grant reporting records against internal award data, reviewing disbursement acceptance, and auditing eligibility flags. A common query retrieves records for a specific student or institution:

  • SELECT mrr_id, mr_stud_id, inst_pell_id, orig_awd_amt, disb_accepted_amt FROM igf.igf_gr_mrr_all WHERE inst_pell_id = :p_inst_pell_id;
  • SELECT * FROM igf.igf_gr_mrr_all WHERE mrr_id = :p_mrr_id;
  • Reporting on award versus accepted amounts grouped by record type: SELECT record_type, SUM(orig_awd_amt), SUM(disb_accepted_amt) FROM igf.igf_gr_mrr_all GROUP BY record_type;

These queries support financial aid reconciliation reports, exception dashboards, and audit trails. Because the table is populated by upload processes, queries often filter by ORIG_CREATION_DT or REQUEST_ID to isolate a specific upload batch.

Related Objects

The ETRM metadata documents IGF_GR_MRR_ALL as standalone, so no direct foreign key relationships are recorded to parent or child tables. Related objects that reference or depend on it in practice include:

  • IGF_GR_MRR_ALL_PK — the primary key constraint enforcing uniqueness on MRR_ID.
  • IGF_GR_MRR_ALL_U1 — the unique index on MRR_ID, used for business-key lookups.
  • IGF_GR_MR_ALL / IGF_GR_MRR_HIST — related Multiple Reporting and historical record tables in the IGF schema.
  • IGF_GR_PELL_AWD — Pell award records reconciled against MRR data via student and institution identifiers.
  • IGF_GR_DISB — disbursement records matched on Pell and student identifiers.
  • IGF_GR_STUD — student master data joined on MR_STUD_ID.
  • IGF_GR_INST — institution master data joined on INST_PELL_ID.

Because no formal FK constraints are documented, joins to these tables should be performed on the logical business identifiers (MR_STUD_ID, INST_PELL_ID, MRR_ID) rather than relying on enforced referential integrity.