Search Results tax_rate_excess

Overview

The IGF_FC_GEN_TAX_RTS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Federal and Campus-Based Financial Aid module (IGF). It functions as a generic tax rate table, storing pre-defined tax brackets and corresponding rates used in financial aid calculations. Its primary role is to support the computation of tax liabilities or allowances for students and applicants based on their reported income, ensuring compliance with regulatory requirements for aid packaging and needs analysis. The table is designated as a seed data table, residing in the APPS_TS_SEED tablespace, indicating its data is typically static and loaded during system implementation or patching.

Key Information Stored

The table defines discrete tax brackets and their associated calculation rules. Each record is uniquely identified by a composite primary key and contains the following critical columns:

• S_AWARD_YEAR and TABLE_CODE: These columns define the context for the tax rule, specifying the applicable award year and the specific tax table (e.g., for federal, state, or institutional calculations).
• INCOME_RANGE_START and INCOME_RANGE_END: These NUMBER columns define the lower and upper bounds of an income bracket.
• TAX_RATE and AMOUNT: The base tax percentage and a fixed amount applicable within the defined income range.
• TAX_RATE_EXCESS and AMOUNT_EXCESS: These are pivotal columns for progressive tax calculations. They define the tax rate (percentage) and a fixed amount applied to income that exceeds the lower bound (INCOME_RANGE_START) of the bracket. The user's search for "amount_excess" directly relates to this column, which holds the constant value used in the excess income calculation formula.
• Standard WHO Columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN for audit trails.

Common Use Cases and Queries

The primary use case is determining the tax amount for a given income during financial aid processing. A typical query involves identifying the correct tax bracket for an applicant's income and applying the appropriate calculation. The presence of the excess columns suggests a standard calculation where tax liability for a bracket equals a base AMOUNT plus (TAX_RATE_EXCESS * (Income - INCOME_RANGE_START)).

Sample Query to Find Applicable Tax Bracket and Calculate Liability:

SELECT table_code,
       tax_rate,
       amount,
       tax_rate_excess,
       amount_excess,
       -- Sample calculation for a given income of 50000
       amount + (tax_rate_excess/100 * (50000 - income_range_start)) AS calculated_tax
FROM igf.igf_fc_gen_tax_rts
WHERE s_award_year = '2024-2025'
  AND table_code = 'FEDERAL_STD'
  AND 50000 BETWEEN income_range_start AND income_range_end;

Reporting use cases include validating configured tax tables, auditing changes to tax rates over time via the WHO columns, and generating summaries of active tax brackets by award year.

Related Objects

Based on the provided metadata, the table's relationships are defined by its primary key. It is referenced by other objects within the APPS schema, as indicated by the dependency information stating "IGF.IGF_FC_GEN_TAX_RTS is referenced by following: APPS". While specific foreign key relationships are not enumerated, the composite primary key (IGF_FC_GEN_TAX_RTS_PK on S_AWARD_YEAR, TABLE_CODE, INCOME_RANGE_START, INCOME_RANGE_END) is the definitive point of reference. Any other table or view in the financial aid module that requires tax rate data would join to this table using some or all of these key columns. Common related objects are likely to be forms, concurrent programs, and PL/SQL packages responsible for needs analysis and packaging logic within the IGF module.