Search Results igf_ap_isir_matched_all




Overview
Explore in AI Chat

Overview

The IGF_AP_ISIR_MATCHED_ALL table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGF (Financial Aid) module. Its primary function is to store the complete Institutional Student Information Record (ISIR) for students whose records have been successfully matched by the system. The ISIR is the official data file received from the U.S. Department of Education's Central Processing System (CPS) and contains the critical information used to calculate a student's financial aid eligibility. This table serves as the central point of truth for matched ISIR data, enabling downstream processing for needs analysis, Expected Family Contribution (EFC) calculation, and award packaging.

Key Information Stored

While the provided metadata does not list specific columns, the table's description and primary key structure define its core purpose. The table is anchored by the ISIR_ID column, which serves as the unique primary key (IGF_AP_ISIR_MATCHED_ALL_PK) for each matched ISIR record. A critical foreign key column is BASE_ID, which links the ISIR data to a specific student's financial aid application record in the IGF_AP_FA_BASE_REC_ALL table. The table's body holds the comprehensive, parsed data elements from the ISIR transaction, which typically includes student and parent demographic data, tax information, asset data, and the calculated EFC components before any institutional adjustments.

Common Use Cases and Queries

This table is central to financial aid operations. Common use cases include auditing the raw ISIR data for matched students, troubleshooting discrepancies in aid eligibility, and supporting regulatory reporting. A typical query would join this table to the base application record to retrieve a student's ISIR data for a specific aid year.

Sample SQL Pattern:
SELECT isir.*, base.person_id
FROM igf.igf_ap_isir_matched_all isir,
     igf.igf_ap_fa_base_rec_all base
WHERE isir.base_id = base.base_id
AND base.award_year = '2024-2025';

Data from this table is also essential for processes that recalculate EFC based on professional judgment (via IGF_AP_EFC_DET) and for integrating National Student Loan Data System (NSLDS) information.

Related Objects

The IGF_AP_ISIR_MATCHED_ALL table has defined relationships with several key Financial Aid tables, as documented in the ETRM metadata.

  • Referenced Table (Outbound Foreign Key):
    • IGF_AP_FA_BASE_REC_ALL: Linked via IGF_AP_ISIR_MATCHED_ALL.BASE_ID. This is the foundational relationship connecting an ISIR to a specific financial aid application.
  • Referencing Tables (Inbound Foreign Keys):
    • IGF_AP_EFC_DET: Linked via IGF_AP_EFC_DET.CONTEXT_ISIR_ID. This table stores detailed EFC components, often derived from or related to the base ISIR data.
    • IGF_AP_ISIR_CORR_ALL: Linked via IGF_AP_ISIR_CORR_ALL.ISIR_ID. This table likely holds correspondence or correction data associated with the original ISIR record.
    • IGF_AP_NSLDS_DATA_ALL: Linked via IGF_AP_NSLDS_DATA_ALL.ISIR_ID. This table stores NSLDS loan data that is associated with the student's ISIR record for overaward monitoring and aggregate loan calculations.