Search Results stud_asset_assessment_rate

Overview

IGF.IGF_FC_EFC_FRM_A is a seed configuration table in the Oracle E-Business Suite Financial Aid module, owned by the IGF schema. Its documented purpose is "Multiplication Factor – Formula A Table," positioning it as the parameter repository for the Formula A needs-analysis methodology used in the computation of the Expected Family Contribution (EFC). Each row is keyed to a system award year (S_AWARD_YEAR), allowing Oracle to publish and retain the distinct allowance rates, asset conversion factors, and protection thresholds that apply to each processing cycle without overwriting prior-year figures.

From a Data Vault modeling perspective, the heuristic classification of this object is standalone. Because the documented schema shows no foreign keys to parent or child tables, it would most naturally be modeled as a reference or code table rather than as a conventional hub, link, or satellite. It functions as a year-versioned lookup whose single descriptive key drives the arithmetic applied during federal methodology calculations.

Key Information Stored

The table holds sixteen documented columns, of which the following are the most operationally significant:

• S_AWARD_YEAR (VARCHAR2(30)) — the surrogate primary key of the table and the sole column of the unique index IGF_FC_EFC_FRM_A_PK. It is the business-key candidate that identifies each set of Formula A factors for a given award year.
• STUD_INC_PROT_ALLOWANCE (NUMBER) — the Student's Income Protection Allowance, the threshold below which a dependent student's own income is sheltered from assessment. This is the column directly targeted by the search term "stud_inc_prot_allowance."
• STUD_AVAILABLE_INCOME (NUMBER) — the assessment of a student's available income after protected allowances are applied.
• STUD_ASSET_ASSESSMENT_RATE (NUMBER) — the percentage rate applied to a student's assets when determining the asset contribution.
• EMPL_EXP_ALLOWANCE_RATE1 / EMPL_EXP_ALLOWANCE_AMOUNT1 — the percentage and dollar allowance for employment expenses where one parent is present.
• EMPL_EXP_ALLOWANCE_RATE2 / EMPL_EXP_ALLOWANCE_AMOUNT2 — the equivalent percentage and dollar allowance for households with two parents.
• PARENT_ASSET_CONV_RATE (NUMBER) — the conversion rate applied to parental assets.
• INCOME_PROTECTION_DIFF_9 (NUMBER) — the income protection differential applied to enrollment periods other than nine months.
• A5_DEFAULT_AGE (NUMBER) — the default age assigned to the older parent when actual age data is unavailable.

Standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit traceability for each seeded row.

Common Use Cases and Queries

The dominant use case is retrieving the correct factor set for a specific award year before running EFC or needs-analysis processing. A typical lookup is:

SELECT STUD_INC_PROT_ALLOWANCE, STUD_AVAILABLE_INCOME, STUD_ASSET_ASSESSMENT_RATE FROM IGF.IGF_FC_EFC_FRM_A WHERE S_AWARD_YEAR = :award_year;

Reporting scenarios include year-over-year comparisons of income protection allowances and employment expense limits to validate that newly loaded federal tables have been applied correctly. Because the primary key is the award year, joins back to award-year-driven configuration are simple equality predicates on S_AWARD_YEAR. Administrators also query the table directly to audit the PARENT_ASSET_CONV_RATE and INCOME_PROTECTION_DIFF_9 values after a legislative update.

Related Objects

The documented dependency analysis states that IGF.IGF_FC_EFC_FRM_A references no other object and is referenced by none within the extracted metadata, confirming its standalone classification. It nonetheless participates logically with other IGF formula and reference tables:

• IGF_FC_EFC_FRM_A_PK — the unique index enforcing the S_AWARD_YEAR primary key.
• Other Formula A methodology tables in the IGF schema that share the S_AWARD_YEAR key, consulted in the same EFC computation sequence.
• IGF needs-analysis and institutional methodology tables that consume STUD_INC_PROT_ALLOWANCE and the employment expense allowances as inputs.
• Award-year control tables that define the valid values of S_AWARD_YEAR.

Because no foreign keys are documented, any joins to these objects are logical rather than enforced, and should be validated against the specific rules version in use for Oracle EBS 12.1.1 or 12.2.2.