Search Results igf_gr_mrr_all_u1

Overview

IGF.IGF_GR_MRR_ALL is a transactional table in the Oracle E-Business Suite Financial Aid module (IGF), part of the U.S. Department of Education Pell Grant processing framework. The table stores Multiple Reporting Records (MRR) that are uploaded from an external system — typically the Department of Education's Common Origination and Disbursement (COD) system — into Oracle EBS. Each row represents a single multiple reporting record that conveys origination or disbursement information between institutions for a given student. The object resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10 and carries FND design data registration under IGF.IGF_GR_MRR_ALL.

From a heuristic Data Vault modeling perspective, IGF_GR_MRR_ALL is classified as a standalone object — no foreign key dependencies were mined from its physical structure. It behaves most like a satellite-style record keyed by a surrogate identifier, with no documented parent hub or link tables in the physical schema. This classification is a modeling suggestion and does not imply referential constraints exist at the database level.

Key Information Stored

The table contains 46 documented columns. The most significant are listed below:

• MRR_ID — NUMBER(15), the surrogate primary key (IGF_GR_MRR_ALL_PK). It also anchors the unique index IGF_GR_MRR_ALL_U1, making it the sole documented business-key candidate.
• RECORD_TYPE — code indicating the reason the institution received the record.
• REQ_INST_PELL_ID — Pell identifier of the requesting attended campus.
• MRR_CODE1 / MRR_CODE2 — control codes specifying whether origination or disbursement information is requested, and whether the request is by selected student, institution, or all students.
• MR_STUD_ID and MR_INST_PELL_ID — student and institution identifiers for which multiple reporting records are requested.
• STUD_ORIG_SSN / ORIG_NAME_CD — the student's original SSN and name code from the origination record; these are critical business identifiers for matching.
• INST_PELL_ID, INST_NAME, INST_ADDR1/2, INST_CITY, INST_STATE, ZIP_CODE — full institutional identification and address details.
• SCHD_PELL_GRANT, ORIG_AWD_AMT, DISB_ACCEPTED_AMT, EFC — award, disbursement, and expected family contribution financial amounts.
• ENRL_DT, ORIG_CREATION_DT, TRAN_NUM, ELIGIBILITY_USED — enrollment and origination context.
• ORG_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID — Multi-Org and concurrent request context columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns (WHO columns).

Common Use Cases and Queries

IGF_GR_MRR_ALL is queried primarily for financial aid reconciliation, dispute resolution, and reporting on inter-institution Pell activity. Typical scenarios include retrieving all MRR records for a student's SSN, identifying records by requesting institution, and reconciling disbursement amounts.

Fetch a record by its surrogate key:

• SELECT * FROM IGF.IGF_GR_MRR_ALL WHERE MRR_ID = :p_mrr_id;

Retrieve records for a student by SSN:

• SELECT MRR_ID, RECORD_TYPE, INST_PELL_ID, SCHD_PELL_GRANT, DISB_ACCEPTED_AMT FROM IGF.IGF_GR_MRR_ALL WHERE STUD_ORIG_SSN = :p_ssn;

Aggregate accepted disbursements by operating unit for a period:

• SELECT ORG_ID, SUM(DISB_ACCEPTED_AMT) FROM IGF.IGF_GR_MRR_ALL WHERE CREATION_DATE BETWEEN :p_from AND :p_to GROUP BY ORG_ID;

Because the table is standalone, joins must be constructed against surrounding Pell entities by matching SSN, name code, or Pell identifier columns rather than by declared foreign keys.

Related Objects

The documented physical schema contains no foreign key relationships, so related objects are inferred from shared Pell business identifiers. The most significant are:

• IGF_GR_ORIG_ALL — origination records; join on STUD_ORIG_SSN and ORIG_NAME_CD.
• IGF_GR_DISB_ALL — disbursement records; join on SSN/Pell identifier and TRAN_NUM.
• IGF_GR_STUD_ALL — student-level Pell data; join on student SSN and name code.
• IGF_GR_INST_ALL — institution master; join on INST_PELL_ID or REQ_INST_PELL_ID.
• IGF_GR_PELL_ORIG_ALL — Pell award originations; join on STUD_ORIG_SSN and award amounts.
• AP_INVOICES_ALL / AP_INVOICE_LINES_ALL — downstream disbursement accounting where applicable.
• FND_CONCURRENT_REQUESTS — join on REQUEST_ID to trace the load process that populated the row.

As a standalone table, IGF_GR_MRR_ALL acts as a staging and reference source that is consumed by these downstream Pell objects rather than referencing them by constraint.