Search Results context_isir_id




Overview
Explore in AI Chat

Overview

The IGF_AP_EFC_DET table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Grants and Funds (IGF) module's Award Processing (AP) functionality. It serves as a detailed repository for calculated Effective Family Contribution (EFC) figures, which are central to determining a student's financial need for aid. The table stores cumulative EFC values computed over different time periods, typically corresponding to academic terms or months of enrollment, based on a specific need analysis methodology and a student's financial data from an ISIR (Institutional Student Information Record). Its status is marked as OBSOLETE in the provided metadata, indicating it may have been superseded by a newer structure in later releases or patches, though it remains valid in the database.

Key Information Stored

The table's primary purpose is to store time-phased EFC calculations. Its key columns are defined by a composite primary key (IGF_AP_EFC_DET_PK) and a series of numeric EFC columns. The identifying columns are METHOD_CODE (the need analysis formula used), BASE_ID (linking to the core student financial aid record), and CONTEXT_ISIR_ID (the specific ISIR data set used for the calculation). The core data is held in the PRIMARY_EFC1 through PRIMARY_EFC12 columns, which store the cumulative effective family contribution for one through twelve months, respectively. A notable data anomaly in the provided metadata is that the comment for PRIMARY_EFC10 incorrectly states "Nine months" instead of "Ten months." The table also includes a full set of standard EBS WHO (Who columns) and concurrent program WHO columns for auditing.

Common Use Cases and Queries

This table supports critical financial aid operations, primarily reporting and award packaging. Analysts use it to review how a student's EFC is distributed across an academic year, which influences the timing and amount of disbursements. A common query would retrieve the EFC schedule for a specific student and ISIR context to validate packaging logic. For example: SELECT method_code, primary_efc1, primary_efc2, primary_efc3, primary_efc4, primary_efc5, primary_efc6, primary_efc7, primary_efc8, primary_efc9, primary_efc10, primary_efc11, primary_efc12 FROM igf.igf_ap_efc_det WHERE base_id = :1 AND context_isir_id = :2; Another use case involves aggregate reporting to compare EFC distributions across student populations or methodologies, often joining to the base student aid table (likely IGF_AP_FA_BASE) for demographic filters. The table's OBSOLETE status suggests that new development should reference its replacement, but legacy reports and interfaces may still query it directly.

Related Objects

The IGF_AP_EFC_DET table is intrinsically linked to other core IGF award processing tables. Its BASE_ID column almost certainly references the primary key of IGF_AP_FA_BASE (or a similar base financial aid record table), which stores the student's overarching aid application. The CONTEXT_ISIR_ID links to ISIR data, likely stored in a table such as IGF_AP_ISIR_INTERFACE or IGF_AP_ISIR_HDR. The table's primary key is enforced by the unique index IGF_AP_EFC_DET_PK. Given its function, it is also a likely source for views or APIs that deliver calculated EFC data to award packaging engines, need analysis reports, and downstream systems. The presence of concurrent program WHO columns (PROGRAM_ID, etc.) indicates it can be populated or updated by batch processes.