Search Results table_cd

Overview

The IGF_AP_STATE_TX_RNG table is a core configuration table within the Oracle E-Business Suite's Institutional Grants and Financial Aid (IGF) module, specifically for releases 12.1.1 and 12.2.2. It stores the income range definitions used in state-specific tax tables for calculating financial aid contributions. These pre-defined ranges are essential for automating the needs analysis process, where a family's income is evaluated against standardized tables to determine an expected financial contribution. The table is marked as OBSOLETE in the provided metadata, indicating it may be part of a legacy structure that has been superseded in later application logic, though it remains a valid database object within the specified versions.

Key Information Stored

The table's primary function is to define discrete income brackets. Each record represents a single range within a specific tax table configuration. Key data columns include:

• TXRNG_ID: The primary key uniquely identifying each range record.
• CI_CAL_TYPE & CI_SEQUENCE_NUMBER: Together, these columns define the award year (calendar instance) for which the range is valid.
• METHOD_CODE: Links to the specific family contribution methodology (IGF_AP_NEED_MTH_TYP).
• TABLE_CD: Identifies the specific tax table (e.g., A, B, or C) within the methodology.
• RANGE_START: The lower bound (inclusive) of the income range.
• RANGE_END: The upper bound (inclusive) of the income range, which is the specific column searched for by the user.
• Standard WHO Columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN for audit tracking.

Common Use Cases and Queries

This table is primarily referenced during financial aid packaging and needs analysis batch processes. A common operational query involves retrieving all valid income ranges for a specific award year and calculation method to apply against applicant data. For instance, to find the applicable range for a given income, one might use a query such as:

SELECT TABLE_CD, RANGE_START, RANGE_END FROM IGF.IGF_AP_STATE_TX_RNG WHERE CI_CAL_TYPE = :1 AND CI_SEQUENCE_NUMBER = :2 AND METHOD_CODE = :3 AND :income_value BETWEEN RANGE_START AND RANGE_END;

Reporting use cases include validating the configuration of state tax tables and auditing the income brackets used in historical aid calculations. The OBSOLETE status suggests that while existing data may be queried for reference or support, new configurations likely occur through a different application interface or table.

Related Objects

Based on the provided relationship data, IGF_AP_STATE_TX_RNG has defined dependencies with other EBS objects:

• Referenced by Foreign Keys (This table references):
  • IGS_CA_INST_ALL: The CI_CAL_TYPE column references this table to ensure the award year calendar type is valid.
  • IGF_AP_NEED_MTH_TYP: The METHOD_CODE column references this table to enforce valid contribution method codes.
• Referencing Foreign Keys (Tables that reference this table):
  • IGF_AP_STATE_TX_RTS: The TXRNG_ID foreign key in this table references IGF_AP_STATE_TX_RNG.TXRNG_ID, indicating that rate values (likely tax rates or contribution percentages) are stored separately and linked to these defined income ranges.