Results for “igf_fc_efc_frm_c”

17 results




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

Overview

The IGF.IGF_FC_EFC_FRM_C table is a configuration table within the Oracle E-Business Suite IGF — Financial Aid product. Its documented description, "Multiplication Factor - Formula C Table," identifies it as the storage location for the multiplication-factor parameters consumed by the Formula C calculation of the Expected Family Contribution (EFC). In the U.S. federal student aid methodology, the EFC is the amount a family is expected to contribute toward post-secondary education costs; Formula C applies a distinct set of assessment rates and offsets — for example, differential treatment of the marginal (asset conversion) rate applied to student assets versus the rates applied to the independent or dependent parent/student contribution components. This table holds the rate and amount constants that the need-analysis engine reads at run time, year by year, so that institutional, state, and federal packaging logic can be recomputed without code changes.

Data Vault classification derived heuristically from its foreign-key structure is standalone; this table neither participates in hub/link relationships nor serves as a satellite to another parent, which suggests it functions as a reference or parameter table anchored by award year. All rate/amount values are therefore valid only in the context of the award year recorded on the row.

Key Information Stored

The table contains 11 documented columns. The primary key, IGF_FC_EFC_FRM_C_PK, is defined on the single column S_AWARD_YEAR. Because this is the only unique index documented, it is also the sole business-key candidate; there is no separate system-generated surrogate identifier exposed in the metadata. Each row therefore represents one award year's Formula C parameter set.

The substantive factor columns are:

  • S_AWARD_YEAR — the award year the row's factors apply to; the primary key and the join key to every other award-year-scoped table.
  • EEA_MRD_2_WRK_RATE — the marginal assessment rate applied to the second work-related component.
  • EEA_MRD_2_WRK_AMT — the corresponding work amount threshold or offset for that rate.
  • EEA_MRD_1_WRK_RATE — the marginal assessment rate applied to the first work-related component.
  • EEA_MRD_1_WRK_AMT — the work amount paired with the first-rate component.
  • STUD_ASSET_CONV_RATE — the asset conversion rate applied to student assets, a Formula C–specific parameter.

The remaining columns are standard Oracle EBS audit (WHO) columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. These support accountability and change tracking and should be preserved in any ETL extract that intends to reconcile back to EBS.

Common Use Cases and Queries

The dominant use case is retrieval of the Formula C parameter set for a given award year during EFC calculation, award packaging, or reporting. A typical query is:

  • SELECT * FROM igf.igf_fc_efc_frm_c WHERE s_award_year = :award_year;
  • Cross-year comparison of rates: SELECT s_award_year, eea_mrd_1_wrk_rate, eea_mrd_2_wrk_rate, stud_asset_conv_rate FROM igf.igf_fc_efc_frm_c ORDER BY s_award_year;
  • Audit of recently maintained rows: SELECT * FROM igf.igf_fc_efc_frm_c WHERE last_update_date >= :since;
  • Detecting missing configuration: a left-outer join from an award-year list against this table to find years with no Formula C factors loaded.

Reporters typically use the table as a dimension of rates joined into need-analysis fact queries by S_AWARD_YEAR. Because the key is a single column, joins are inexpensive and the table is a good candidate for caching or a materialized snapshot in a reporting schema.

Related Objects

The Data Vault mining classifies this object as standalone, so no foreign keys were documented to external tables. Practical relationships nonetheless exist and are driven by the shared award-year key:

  • IGF_FC_EFC_FRM_A and IGF_FC_EFC_FRM_B — the corresponding Formula A and Formula B factor tables, joined on S_AWARD_YEAR, used to select the correct methodology.
  • Other IGF Formula C component tables (e.g., allowance, asset, and income parameter tables) keyed by S_AWARD_YEAR.
  • EFC calculation and need-analysis result tables in the IGF schema, joined by S_AWARD_YEAR when tracing an EFC value back to its source factors.
  • Award-year validation tables in the IGF or Financial Aid reference data, used to confirm that a factor row exists for every active processing year.

Because no API was documented for this object in the ETRM metadata, maintenance is normally performed through the Financial Aid setup forms or direct controlled DBA updates, with audit columns capturing the change.