Search Results igf_fc_efc_frm_a_pk

Overview

IGF_FC_EFC_FRM_A is an Oracle E-Business Suite configuration table owned by the IGF schema, the database account associated with the Financial Aid product family (Oracle Student Financial Aid / Financial Aid Processor). The table name and the ETRM description — "Multiplication Factor - Formula A Table" — indicate that it stores the numeric factors and allowances applied during the Expected Family Contribution (EFC) calculation used in needs-analysis processing for student financial aid awards. In EBS 12.1.1 and 12.2.2 the table is delivered as a VALID, standalone object with no foreign-key dependencies to other application tables.

Structurally, IGF_FC_EFC_FRM_A is award-year driven: the primary key IGF_FC_EFC_FRM_A_PK is defined on the single column S_AWARD_YEAR, so each row represents one complete set of Formula A factors for a given award year. The ETRM metadata classifies the object heuristically as a Data Vault satellite candidate, since it holds descriptive, non-relational attribute data keyed by a natural business key rather than participating in hub/link relationships. Because the heuristic is mined from FK structure and no FKs exist, this classification should be treated as a modeling suggestion rather than a documented fact.

Key Information Stored

The table contains 16 documented columns. The most significant are the financial-aid calculation factors and the standard EBS audit/WHO columns:

• S_AWARD_YEAR — the solely unique business key and primary key. It identifies the aid year (for example, 2011 or 2012) to which the Formula A factors apply.
• EMPL_EXP_ALLOWANCE_RATE1 / EMPL_EXP_ALLOWANCE_AMOUNT1 — the percentage rate and dollar amount allowance applied to employment expense in the Formula A needs calculation.
• EMPL_EXP_ALLOWANCE_RATE2 / EMPL_EXP_ALLOWANCE_AMOUNT2 — a second-tier employment expense rate and amount, providing an additional allowance band.
• PARENT_ASSET_CONV_RATE — the conversion rate applied when assessing parental assets for the EFC contribution.
• STUD_INC_PROT_ALLOWANCE — the income protection allowance applied to student income.
• STUD_AVAILABLE_INCOME — the computed or configured amount of student income considered available for the EFC.
• STUD_ASSET_ASSESSMENT_RATE — the percentage rate at which student assets are assessed toward the contribution.
• INCOME_PROTECTION_DIFF_9 — a differential income-protection factor used in the Formula A assessment sequence.
• A5_DEFAULT_AGE — the default age assumption used in the Formula A calculation logic.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS "WHO" audit columns recording row creation and modification.

Only S_AWARD_YEAR is documented as a unique index and business-key candidate; the calculation factors are non-unique attribute data qualifying each award year.

Common Use Cases and Queries

The table is consulted whenever the Financial Aid engine derives an EFC under Formula A. Typical reporting and support scenarios include verifying the factors used for a specific aid year, comparing factor changes between years, and auditing who last maintained the configuration. Representative SQL patterns:

• Retrieve factors for one award year: SELECT * FROM igf.igf_fc_efc_frm_a WHERE s_award_year = :year;
• List all configured years in ascending order: SELECT s_award_year, parent_asset_conv_rate, stud_asset_assessment_rate FROM igf.igf_fc_efc_frm_a ORDER BY s_award_year;
• Audit recent maintenance: SELECT s_award_year, last_updated_by, last_update_date FROM igf.igf_fc_efc_frm_a ORDER BY last_update_date DESC;
• Year-over-year rate comparison using a self-join or analytic LAG() on the rate columns.

Results are commonly consumed by financial-aid packaging reports, EFC verification extracts, and year-end reconciliation queries.

Related Objects

The ETRM relationship data classifies IGF_FC_EFC_FRM_A as standalone, meaning no foreign keys were documented to or from other tables. In practice, related objects are those that share the IGF Financial Aid namespace and read this configuration during needs analysis:

• IGF_FC_EFC_FRM_A_PK — the primary key index on S_AWARD_YEAR, used for direct access by award year.
• The companion Formula tables in the IGF schema (e.g., other IGF_FC_EFC_FRM_* variants) that hold multiplication factors for alternative formulas.
• IGF needs-analysis and EFC calculation objects that consume the factor values when processing an applicant's contribution.
• IGF award-year / fund setup tables used to validate the S_AWARD_YEAR value.
• Standard EBS concurrent programs and Financial Aid reports that read the factors at run time.

Because the documented relationship data is limited to a primary key on S_AWARD_YEAR, joins to this table should be driven by award year rather than by surrogate identifier.