Search Results s_award_year




Overview
Explore in AI Chat

Overview

The IGF_FC_STATE_TX table is a core configuration table within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary role is to store state-specific tax allowance rates used in the calculation of a student's financial need for a given award year. The table functions as a lookup repository for tax percentages, which are applied based on the student's state of residence and their income range. This data is critical for ensuring that federal and institutional need analysis calculations, such as those performed by the Institutional Methodology (IM) or the Federal Methodology (FM), accurately account for state tax liabilities, thereby determining a student's correct Expected Family Contribution (EFC). The table resides in the APPS_TS_SEED tablespace, indicating it is part of the shared seed data layer in EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to support multi-year, multi-state tax rate configurations. The key business columns are:

  • S_AWARD_YEAR: A mandatory VARCHAR2 column identifying the system award year (e.g., 2024-2025) for which the tax rate is applicable.
  • TABLE_CODE: A VARCHAR2 column classifying the tax table, likely differentiating between various calculation methodologies or tax types.
  • STATE_CODE: A VARCHAR2 column storing the code for the U.S. state or territory to which the tax rate applies.
  • INCOME_RANGE_START and INCOME_RANGE_END: NUMBER columns that define the lower and upper bounds of an income bracket.
  • TAX_RATE: A NUMBER column holding the tax percentage applicable to the specified state, income range, award year, and table code.

The table also includes standard "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing. The primary key (IGF_FC_STATE_TX_PK) enforces uniqueness across the combination of S_AWARD_YEAR, TABLE_CODE, INCOME_RANGE_START, INCOME_RANGE_END, and STATE_CODE.

Common Use Cases and Queries

The primary use case is the retrieval of the correct tax rate during financial need analysis processing. A typical query would filter by the current award year, the student's state, and the relevant table code to find the rate matching the family's taxable income. For reporting or validation, administrators may query all rates for a specific year and state.

Sample Query to Retrieve a Tax Rate:
SELECT tax_rate
FROM igf.igf_fc_state_tx
WHERE s_award_year = '2024-2025'
AND state_code = 'CA'
AND table_code = 'FED'
AND 50000 BETWEEN income_range_start AND income_range_end;

Sample Query for Configuration Review:
SELECT s_award_year, state_code, table_code,
income_range_start, income_range_end, tax_rate
FROM igf.igf_fc_state_tx
WHERE s_award_year = '2024-2025'
ORDER BY state_code, table_code, income_range_start;

Related Objects

Based on the provided dependency information, the IGF_FC_STATE_TX table is referenced by an object named APPS.IGF_FC_STATE_TX. This is most likely a public synonym (APPS.IGF_FC_STATE_TX) that points to the underlying IGF.IGF_FC_STATE_TX base table, providing a standard access point for all EBS application code. The metadata indicates no foreign key relationships from this table to others, and it is not referenced by other objects with documented foreign keys in this excerpt. Its data is typically referenced programmatically by packages and views within the Financial Aid module that perform need analysis calculations.