Results for “igf_ap_efc_alt_fact”

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

Overview

The IGF_AP_EFC_ALT_FACT table resides in the IGF schema, which belongs to the Oracle E-Business Suite Financial Aid module (IGF). In the ETRM documentation for EBS 12.1.1 and 12.2.2, this object is explicitly flagged as OBSOLETE. It was originally designed to persist alternative Expected Family Contribution (EFC) calculation results for the federal financial aid needs-analysis process, allowing institutions to compare alternate dependency statuses, tax return types, and income assumptions against the primary EFC determination stored elsewhere in the IGF data model.

Despite its obsolete status, the table remains physically valid in many 12.1.1 and 12.2.2 environments because no destructive DDL has been applied. From a Data Vault modeling perspective, the FK structure suggests this object behaves as a link table: its primary key is composed entirely of business keys (ALTERNATIVE, DEPEND_STAT, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, METHOD_CODE) that reference calendar instances and need-analysis method types, rather than a single generated surrogate key. This classification is a heuristic recommendation, not a documented Oracle design assertion.

Key Information Stored

The table contains 14 documented columns. The most significant are:

• ALTERNATIVE — Identifier distinguishing each alternative EFC scenario; part of the composite primary key.
• DEPEND_STAT — Dependency status (dependent vs. independent) applied in the alternative calculation; also part of the PK. This is the column most frequently searched under the term "depend_stat."
• CI_CAL_TYPE and CI_SEQUENCE_NUMBER — Calendar type and sequence number identifying the aid year / academic period context; both are PK components and foreign keys to IGS_CA_INST_ALL.
• METHOD_CODE — The need-analysis methodology applied; PK component and FK to IGF_AP_NEED_MTH_TYP.
• ALT_INC — Alternative income amount used in the EFC re-computation.
• TAX_RET_1040, TAX_RET_1040A, TAX_RET_1040EZ — Flags or values reflecting the tax return form variant used as input.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.

The unique index IGF_AP_EFC_ALT_FACT_PK defines the business-key candidates as the five PK columns; no separate single-column surrogate key is documented.

Common Use Cases and Queries

Because the object is obsolete, its primary modern use is historical reporting, data migration validation, and reconciliation of legacy EFC snapshots against current need-analysis records. A typical diagnostic query retrieving alternative EFC scenarios for a given dependency status and aid year:

• SELECT alternative, depend_stat, method_code, alt_inc, tax_ret_1040 FROM igf.igf_ap_efc_alt_fact WHERE depend_stat = 'I' AND ci_cal_type = :cal_type AND ci_sequence_number = :seq;
• Joining to the calendar instance to resolve the aid year label: ... FROM igf.igf_ap_efc_alt_fact f, igs.igs_ca_inst_all c WHERE f.ci_cal_type = c.cal_type AND f.ci_sequence_number = c.sequence_number;
• Aggregating counts of alternatives per methodology: SELECT method_code, COUNT(*) FROM igf.igf_ap_efc_alt_fact GROUP BY method_code;

These patterns support audits, year-over-year EFC comparison extracts, and verification that legacy alternative scenarios migrated cleanly.

Related Objects

• IGS_CA_INST_ALL — Referenced via CI_CAL_TYPE and CI_SEQUENCE_NUMBER; supplies the calendar instance (aid year) context.
• IGF_AP_NEED_MTH_TYP — Referenced via METHOD_CODE; defines the need-analysis methodology.
• IGF_AP_EFC_ALT_FACT_PK — The unique index enforcing the composite business key.
• Other IGF_AP_* EFC and needs-analysis fact tables that share the same calendar and methodology FK conventions, commonly joined in financial aid reporting extracts.

Because the table is marked OBSOLETE, dependency checks before dropping or archiving it should account for these FK relationships.