Search Results igf_ap_state_tx_rng

Overview

The IGF_AP_STATE_TX_RNG table is a data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary purpose was to store state-specific tax range data used in the calculation of financial aid need analysis. This table functioned as a reference table, holding parameters that defined income ranges and corresponding tax amounts or rates for specific states, which were critical inputs for determining a student's Expected Family Contribution (EFC). It is important to note that the official ETRM documentation explicitly marks this table as OBSOLETE. This status indicates that while the table may physically exist in databases running versions 12.1.1 or 12.2.2, its business logic is likely deprecated, superseded by other functionality, or no longer actively maintained by Oracle.

Key Information Stored

The table's structure centers on defining a unique tax range for a specific context. The primary identifier is the TXRNG_ID column. The table's unique key (IGF_AP_STATE_TX_RNG_UK) reveals the core dimensions of the data: the award year (via the CI_CAL_TYPE and CI_SEQUENCE_NUMBER columns linking to the calendar instance), the need analysis METHOD_CODE, a state or tax TABLE_CD, and a RANGE_START value. This combination would uniquely identify a specific tax bracket or range. While the full column list is not provided, the structure implies the existence of complementary columns, such as a RANGE_END and a corresponding tax value or rate, which would be applied to income falling within that defined range for the specified state and methodology.

Common Use Cases and Queries

As an obsolete object, direct operational or reporting use of this table is strongly discouraged in favor of any successor implementations. Historically, its use cases would have been embedded within the financial aid packaging engine. A typical query would retrieve the applicable tax amount for a given income, state, and methodology within an award year. A sample historical query pattern might have resembled:

• SELECT tax_value FROM igf_ap_state_tx_rng WHERE ci_cal_type = :award_cal_type AND ci_sequence_number = :award_seq AND method_code = :method AND table_cd = :state_code AND :income BETWEEN range_start AND range_end;

Any custom reports or interfaces directly referencing IGF_AP_STATE_TX_RNG should be reviewed for modernization, as the underlying data may be incorrect or unsupported.

Related Objects

Based on the documented foreign key relationships, this table integrates with several core Financial Aid tables. The relationships are as follows:

• IGS_CA_INST_ALL: The table links to the Calendar Instance to define the valid award year via columns CI_CAL_TYPE and CI_SEQUENCE_NUMBER.
• IGF_AP_NEED_MTH_TYP: It references the Need Methodology Type table via the METHOD_CODE column, tying each tax range to a specific need analysis methodology.
• IGF_AP_STATE_TX_RTS: This table holds a foreign key relationship where IGF_AP_STATE_TX_RTS.TXRNG_ID references IGF_AP_STATE_TX_RNG.TXRNG_ID. This suggests that tax rate details (RTS) were associated with a defined tax range (RNG).

These relationships underscore the table's former role as a central reference point within a state tax calculation hierarchy.