Results for “igf_fc_efc_frm_b”

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

Overview

IGF_FC_EFC_FRM_B is a configuration table within the Oracle E-Business Suite Financial Aid module (IGF), documented in ETRM 12.1.1 with an "Obsolete" product designation. Its title, "Multiplication Factor - Formula B Table," indicates that it stores the multiplicative coefficients and income protection allowance thresholds used by the Expected Family Contribution (EFC) calculation engine when the Formula B methodology is applied. Formula B corresponds to the federal need-analysis formula reserved for independent students, and the table therefore holds the year-specific constants that drive that computation.

The object is owned by the IGF schema and contains 15 documented columns. Its structure is characteristic of a reference or setup table rather than a transactional entity: it is keyed by an award year and populated with numeric factors rather than being written to by day-to-day user activity. No foreign keys are documented, and the heuristic Data Vault classification derived from the FK structure is standalone. In Data Vault modelling terms, this object is best treated as a reference or lookup satellite keyed on the award year, distinct from a hub or link because it represents a single business concept rather than a relationship between entities.

Per the ETRM metadata, the table is "Not implemented in this database" in the sampled environment, and its parent module is flagged obsolete. Implementations should verify whether the object exists in their specific 12.1.1 or 12.2.2 instance before writing dependent code, since the table may be shipped but unused, or omitted entirely depending on the installed product set.

Key Information Stored

The primary key IGF_FC_EFC_FRM_B_PK is defined on the single column S_AWARD_YEAR. This is notable: the physical primary key is a business key (the award year), and there is no surrogate identifier such as a generated ID column. Because the unique index IGF_FC_EFC_FRM_B_PK also covers S_AWARD_YEAR, the award year functions simultaneously as the surrogate and the business-key candidate, giving the table a natural, single-column grain of one row per award year.

• S_AWARD_YEAR — the award (processing) year for which the Formula B multiplication factors are valid; the table's primary key and unique index column.
• UNMARRIED_STUD_IPA_AMT — income protection allowance amount applied to an unmarried student's income.
• MSS_HALF_TIME_IPA_AMT — income protection allowance amount for a married student supported while studying at least half time.
• UNMARRIED_STUD_EEA_AMT — education expense allowance amount for an unmarried student.
• MARRIED_STUD_IPA_AMT — income protection allowance amount for a married student's income.
• MARRIED_ONE_WORK_EEA_AMT — education expense allowance amount where one spouse is working.
• MARRIED_TWO_WORK_EEA_RATE — rate applied to the couple's combined earnings where both spouses work.
• MARRIED_TWO_WORK_EEA_AMT — resulting education expense allowance amount for the two-worker case.
• STUD_AVAILABLE_INCOME — the computed or configured income amount available to the student after allowances.
• STUD_ASSET_CONV_RATE — conversion rate applied to student assets in the EFC computation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO columns providing audit and concurrency tracking.

Common Use Cases and Queries

The table is consumed during federal need-analysis processing to retrieve the correct-year constants before computing an EFC. A typical retrieval filters on a specific award year:

• Parameter lookup: SELECT * FROM igf.igf_fc_efc_frm_b WHERE s_award_year = :p_award_year;
• Parameter comparison across years: SELECT s_award_year, stud_available_income, stud_asset_conv_rate FROM igf.igf_fc_efc_frm_b ORDER BY s_award_year;, used for year-over-year analysis of formula constants.
• Data-authoring audit: SELECT s_award_year, last_updated_by, last_update_date FROM igf.igf_fc_efc_frm_b; to identify who last maintained the annual factors.

Typical scenarios include validating that a row exists for the award year before an EFC batch run, reconciling loaded constants against published federal tables, and reproducing historical EFC results by pinning the year.

Related Objects

The metadata documents no foreign keys and a standalone classification, so dependent objects are identified heuristically rather than through enforced constraints.

• IGF_FC_EFC_FRM_A — sibling Formula A (dependent student) multiplication factor table, sharing the same design pattern and award-year grain.
• IGF_FC_EFC_FRM_C / IGF_FC_EFC_FRM_D — parallel formula tables, where present, following the same structure.
• IGF_FC_EFC_MASTER — the EFC master/result entity that consumes Formula B constants at calculation time.
• IGF_FC_EFC_PARAM — parameter table often joined by award year to supply additional formula inputs.
• IGF_FC_AWARD_YEAR — award-year validation reference for the S_AWARD_YEAR key.

Because the module is obsolete, join columns should be confirmed against the actual installed schema; the conventional join column across these objects is S_AWARD_YEAR.