Search Results igf_ap_state_tx_rts

Overview

The table IGF_AP_STATE_TX_RTS is a historical data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). As explicitly noted in the official ETRM documentation, its status is "OBSOLETE." This designation indicates that the table is no longer actively maintained or used for core processing logic in the specified EBS releases (12.1.1 and 12.2.2) and likely remains in the database schema for backward compatibility or data retention purposes. Its original role was to manage the relationship between state-specific tax rate ranges and individual states, forming a critical junction in the configuration of financial aid calculations that considered state tax implications.

Key Information Stored

The table's structure is defined by a composite primary key, which also represents its core data elements. The primary purpose was to associate a tax rate range with a specific state code. The key columns are:

• TXRNG_ID: A foreign key column linking directly to the primary key of the IGF_AP_STATE_TX_RNG table. This identifier points to a specific defined range of tax rates.
• STATE_CD: The code representing a U.S. state, territory, or other geographic entity. The combination of TXRNG_ID and STATE_CD forms the table's unique key (IGF_AP_STATE_TX_RTS_PK), enforcing that a given tax rate range is uniquely assigned to a state within this table.

Given the table's obsolete status, these columns would contain legacy configuration data that is not utilized by the application's current business rules.

Common Use Cases and Queries

Direct operational or reporting use cases for this table in active EBS implementations are non-existent due to its obsolete status. Its primary use in a contemporary context would be for historical data analysis, forensic accounting audits of past aid awards, or during data migration and cleanup projects. Sample queries would typically be investigative, such as identifying all state associations for a legacy tax range or verifying the existence of historical data prior to archival. An example pattern would be:

SELECT state_cd, txrng_id FROM igf.igf_ap_state_tx_rts WHERE state_cd = 'CA';

Development or customization that references this table is strongly discouraged, as the underlying business logic it supported has been superseded.

Related Objects

The metadata defines one crucial relationship for this table. It is a child table to IGF_AP_STATE_TX_RNG via a foreign key constraint. The TXRNG_ID column in IGF_AP_STATE_TX_RTS references the primary key of the IGF_AP_STATE_TX_RNG table, which itself is likely also obsolete. This relationship enforced referential integrity, ensuring that every state-tax rate association pointed to a valid, predefined tax rate range. No other foreign key relationships or dependent APIs are indicated in the provided documentation, which is consistent with an object that has been decommissioned from active application flows.