Results for “primary_efc12”

6 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGF_AP_EFC_DET table resides in the IGF schema and belongs to the IGF - Financial Aid product family within Oracle E-Business Suite 12.1.1 and 12.2.2. The table is classified as OBSOLETE in the Oracle ETRM (E-Business Suite Technical Reference Manual) documentation. Its name suggests it originally stored Expected Family Contribution (EFC) detail records associated with financial aid need-analysis processing for the Apply (AP) module.

Although functionally retired, the table remains physically present and VALID in the database, retaining its structure, constraints, and referential integrity. From a Data Vault modeling perspective, the metadata heuristic classifies this table as a link entity, since it resolves relationships among base records, ISIR matching data, and need-analysis method types rather than acting as an independent hub.

Key Information Stored

The table comprises 24 documented columns. Its most significant columns are:

The surrogate primary key is IGF_AP_EFC_DET_PK, defined over the composite business-key candidate (BASE_ID, METHOD_CODE, CONTEXT_ISIR_ID). This composite uniquely identifies an EFC detail row per base record, methodology, and matched ISIR context.

Common Use Cases and Queries

Because the table is marked OBSOLETE, current use cases are primarily historical, archival, or data-migration oriented. Typical patterns include:

  • Historic EFC reporting — Reconstructing EFC values for students processed under legacy need-analysis rules.
  • Data validation and migration — Confirming alignment between legacy EFC detail rows and current base records before archiving or purging.
  • Referential integrity auditing — Checking for orphaned rows against the three foreign key parents.

Representative query patterns include joining the table to IGF_AP_FA_BASE_REC_ALL on BASE_ID to retrieve the owning base record, joining to IGF_AP_NEED_MTH_TYP on METHOD_CODE to resolve methodology descriptions, and joining to IGF_AP_ISIR_MATCHED_ALL on CONTEXT_ISIR_ID to contextualize ISIR matching. Aggregate queries over PRIMARY_EFC1 through PRIMARY_EFC12 support period-by-period EFC trend reporting.

Related Objects

The most significant related objects, based on documented foreign key relationships, are:

  • IGF_AP_FA_BASE_REC_ALL — Joined via IGF_AP_EFC_DET.BASE_ID; the base financial aid record.
  • IGF_AP_ISIR_MATCHED_ALL — Joined via IGF_AP_EFC_DET.CONTEXT_ISIR_ID; matched ISIR context.
  • IGF_AP_NEED_MTH_TYP — Joined via IGF_AP_EFC_DET.METHOD_CODE; need-analysis methodology types.
  • IGF_AP_EFC_DET_PK — The composite unique index enforcing the primary key.

These three parent tables constitute the complete documented referential footprint of IGF_AP_EFC_DET, confirming its role as a linking detail table within the financial aid need-analysis pipeline.