Search Results igf_ap_efc_frml_a_pk

Overview

The table IGF_AP_EFC_FRML_A is a historical audit table within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary function was to store versioned records (audit rows) related to Expected Family Contribution (EFC) formulas. The table's designation as "OBSOLETE" in the official ETRM documentation indicates that the underlying logic or data model it supported has been deprecated or significantly redesigned in the referenced EBS releases (12.1.1 and 12.2.2). Consequently, while the table may physically exist in the database for historical data retention, it is no longer actively maintained or used by core application processes. Its role was intrinsically linked to tracking changes in the configuration of need analysis methodologies over time.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies a specific audit record for a formula configuration. The key columns are CI_SEQUENCE_NUMBER and CI_CAL_TYPE, which together identify an academic calendar instance (term), and METHOD_CODE, which identifies the specific need analysis methodology. While the full column list is not detailed in the provided metadata, audit tables in EBS typically include standard columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and a VERSION_NUMBER or similar to track the sequence of changes. The core business data originally stored would have pertained to the parameters or rules defining the EFC calculation formula for a given methodology and academic period.

Common Use Cases and Queries

Given the obsolete status of this table, there are no active application use cases. Its utility is now confined to potentially auditing historical data changes for compliance or archival reporting. Any queries would be for investigative purposes only. A sample pattern to retrieve the audit history for a specific need methodology and calendar would be:

• SELECT * FROM igf.igf_ap_efc_frml_a WHERE method_code = '&METHOD' AND ci_cal_type = '&CAL_TYPE' AND ci_sequence_number = &SEQ_NUM ORDER BY <version_column>;

Reporting directly against this table is not recommended for operational processes. Customizations or integrations should be designed using the current, active tables within the Financial Aid module.

Related Objects

The documented foreign key relationships explicitly define this table's dependencies within the EBS data model. These relationships are critical for understanding the context of the stored data, even in its obsolete state.

• IGS_CA_INST_ALL: The table references this calendar instance table via the columns CI_CAL_TYPE and CI_SEQUENCE_NUMBER. This links each formula record to a specific academic term (e.g., Fall 2024).
• IGF_AP_NEED_MTH_TYP: The table references this need method type table via the METHOD_CODE column. This links the formula to a defined need analysis methodology (e.g., Federal Methodology, Institutional Methodology).

The primary key constraint IGF_AP_EFC_FRML_A_PK enforces uniqueness on the combination of these three foreign key columns for each audit row.