Search Results igf_fc_efc_alt_fac_pk

Overview

The IGF.IGF_FC_EFC_ALT_FAC table is a Financial Aid (IGF) configuration object within Oracle E-Business Suite 12.1.1 and 12.2.2. Its name is derived from "Expected Family Contribution (EFC) Alternative Factors", and it holds the multiplication factors applied to alternative income and tax-return data elements when deriving a student's Expected Family Contribution. In the Need Analysis process, institutional and federal methodologies convert reported income, asset, and tax metrics into a normalized EFC; the alternative-factor rows in this table supply the coefficients that drive those transformations for specific award years, dependency classifications, and alternative calculation codes.

Following the heuristic Data Vault classification mined from the foreign-key structure, this object presents as a standalone reference (lookup) entity. Because it carries no outgoing foreign keys documented in the ETRM metadata, it is best modeled as a standalone reference/configuration table rather than as a hub, link, or satellite. It is primarily referenced dimensionally by procedure and report logic rather than joined by enforced relational constraints.

Key Information Stored

The table is composed of 12 documented columns, structured around a composite business key. The most significant columns are:

• S_AWARD_YEAR — the award year to which the alternative factors apply; part of the primary key and the principal partitioning/selection attribute.
• DEPENDENT_STATUS — indicates whether the factor applies to a dependent or independent student calculation; part of the primary key.
• ALTERNATIVE_CODE — the alternative calculation method or formula identifier; part of the primary key.
• ALTERNATIVE_INCOME — the multiplication factor applied to alternative (non-taxable or estimated) income.
• TAX_RETURN_1040 — factor applied to income reported on Form 1040.
• TAX_RETURN_1040A — factor applied to income reported on Form 1040A.
• TAX_RETURN_1040EZ — factor applied to income reported on Form 1040EZ.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle WHO audit columns.

The Primary Key is IGF_FC_EFC_ALT_FAC_PK, defined over (S_AWARD_YEAR, DEPENDENT_STATUS, ALTERNATIVE_CODE). Because the ETRM metadata does not document a separate surrogate key column, this composite primary key also serves as the unique business-key candidate; IGF_FC_EFC_ALT_FAC_PK is the single unique index, guaranteeing one factor row per award year, dependency status, and alternative code.

Common Use Cases and Queries

Typical usage centers on configuring and validating EFC factor matrices, auditing changes between award years, and reproducing a student's need analysis. A representative lookup retrieves the factor set for a given year and status:

• SELECT alternative_code, alternative_income, tax_return_1040, tax_return_1040a, tax_return_1040ez FROM igf.igf_fc_efc_alt_fac WHERE s_award_year = :p_year AND dependent_status = :p_status ORDER BY alternative_code;
• Year-over-year comparison: join two filtered instances on the S_AWARD_YEAR, DEPENDENT_STATUS, and ALTERNATIVE_CODE columns to surface factor changes.
• Data-quality checks: detect missing or duplicate rows against the composite key, and confirm that factor values fall within expected numeric bounds for the methodology.
• Audit reporting: query LAST_UPDATED_BY and LAST_UPDATE_DATE to identify recent maintenance activity.

Related Objects

Given the standalone classification, the ETRM metadata documents no foreign-key dependencies for this table. The most significant related objects are therefore the sibling IGF Financial Aid configuration and calculation entities that share the same award-year and dependency-status dimensions, including:

• Need Analysis / EFC calculation tables and procedures in the IGF schema that consume the factor values.
• Financial Aid award-year and dependent-status reference tables that supply the compatible business-key values.
• Institution and student ISIR data tables whose reported income and tax-return fields are matched to ALT_* factors.

Because no FK constraints are documented, joins to these objects are performed logically on common award-year and dependency-status attributes rather than through enforced primary-key/foreign-key relationships.