Search Results gtxrts_id




Overview
Explore in AI Chat

Overview

The IGF_AP_GEN_TX_RTS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Grants Accounting (IGF) module. It functions as a repository for rate tables used in the calculation of family contributions for financial aid packaging. The table stores percentage and amount slabs based on income ranges, which are critical for determining a student's expected family contribution (EFC) according to specific federal methodology rules. Its role is to provide the configurable computational logic that drives automated aid award calculations, ensuring consistency and compliance with regulatory guidelines.

Key Information Stored

The table's structure is designed to define calculation parameters for specific award years and methodologies. The primary and unique identifier is the GTXRTS_ID column. Key functional columns define the context and calculation rules:

  • CI_CAL_TYPE & CI_SEQUENCE_NUMBER: Together, these identify the award year (calendar instance).
  • METHOD_CODE & TABLE_CODE: Specify the family contribution methodology (e.g., Federal Methodology) and the specific table (A, B, or C) within that methodology.
  • RANGE_START & RANGE_END: Define the applicable income range for the calculation rule.
  • PERCT, AMOUNT, PERCT_EXCESS, AMOUNT_EXCESS: These columns hold the core calculation values—fixed percentages, fixed amounts, and rules for income in excess of a specified threshold—used to compute the contribution amount.
  • Standard WHO columns (CREATED_BY, CREATION_DATE, etc.) track audit information.

Common Use Cases and Queries

This table is primarily accessed during the financial aid packaging process. A common use case is retrieving the applicable calculation rule for a student based on their calculated income, award year, and processing methodology. For reporting and validation, administrators may query the configured rates. A fundamental query pattern involves filtering by the award year and method:

SELECT TABLE_CODE, RANGE_START, RANGE_END, PERCT, AMOUNT, PERCT_EXCESS FROM IGF.IGF_AP_GEN_TX_RTS WHERE CI_CAL_TYPE = :1 AND CI_SEQUENCE_NUMBER = :2 AND METHOD_CODE = :3 ORDER BY RANGE_START;

Another critical query is to find the specific slab for a given income amount, which is essential for the real-time calculation engine: SELECT * FROM IGF.IGF_AP_GEN_TX_RTS WHERE CI_CAL_TYPE = :cal_type AND CI_SEQUENCE_NUMBER = :seq_num AND METHOD_CODE = :method AND TABLE_CODE = :table AND :income BETWEEN RANGE_START AND RANGE_END;

Related Objects

Based on the provided dependency metadata, the IGF_AP_GEN_TX_RTS table is referenced by other objects within the APPS schema, indicating its data is accessed by application code, likely through public synonyms and views. While specific foreign key relationships are not detailed in the excerpt, the unique indexes suggest logical relationships. The primary key GTXRTS_ID (enforced by index IGF_AP_GEN_TX_RTS_U1) is the likely target for foreign keys from transactional or runtime calculation tables. The composite unique key on CI_CAL_TYPE, CI_SEQUENCE_NUMBER, METHOD_CODE, RANGE_START, and TABLE_CODE (enforced by index IGF_AP_GEN_TX_RTS_U2) ensures unique rate definitions and may be referenced by application logic enforcing business rules. The table is stored in the APPS_TS_ARCHIVE tablespace.