Search Results gtxrts_id

Overview

The IGF_AP_GEN_TX_RTS table is a data object within the Oracle E-Business Suite (EBS) module for Financial Aid (IGF). Its core purpose is to store rate definitions used in the calculation of transaction amounts for financial aid processing. The table functions as a reference repository for linking specific calculation methods and table codes to a range of values, starting with a defined RANGE_START, to determine applicable rates. As explicitly noted in the official ETRM documentation, this table is marked as OBSOLETE. This status indicates it is a legacy artifact; while it may still exist in the database schema for historical data integrity or upgrade compatibility, its business logic has likely been superseded by newer tables or application code in releases 12.1.1 and 12.2.2. Its role is therefore primarily archival.

Key Information Stored

The table's structure centers on defining a unique combination of context and a starting range for a rate. The primary identifier is the GTXRTS_ID column. The unique key, however, is a composite of several columns that establish the specific context for a rate range: CI_CAL_TYPE and CI_SEQUENCE_NUMBER define the academic calendar instance, METHOD_CODE references the calculation methodology, and TABLE_CODE categorizes the rate table. The RANGE_START column is a critical field, signifying the beginning value of the range to which a particular rate applies. For example, this could represent the starting income level, dependency index, or other numeric metric used in aid eligibility formulas.

Important Columns:

• GTXRTS_ID: Primary key surrogate identifier.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER: Together, they reference a specific calendar period (e.g., a term or award year).
• METHOD_CODE: Identifies the financial aid need calculation method.
• TABLE_CODE: Classifies the type of rate table.
• RANGE_START: The lower-bound numeric value defining the applicable range for a rate.

Common Use Cases and Queries

Given its obsolete status, direct operational use in current processes is unlikely. However, historical reporting or data migration validation may require querying this table. A typical use case would involve retrieving the defined rate ranges for a specific calculation method and academic period to audit or reconcile legacy aid awards. A sample query pattern would join the table to its referenced foreign key tables to get descriptive information.

Sample SQL Pattern:
SELECT gtxrts.ci_cal_type,
       gtxrts.ci_sequence_number,
       gtxrts.method_code,
       gtxrts.table_code,
       gtxrts.range_start
FROM igf.igf_ap_gen_tx_rts gtxrts
WHERE gtxrts.ci_cal_type = :p_cal_type
  AND gtxrts.method_code = :p_method_code
ORDER BY gtxrts.range_start;

Related Objects

The table maintains defined foreign key relationships with other core EBS tables, which are essential for understanding its data context and for constructing accurate joins in queries.

• IGS_CA_INST_ALL: The table is linked to the Calendar Instance table via the CI_CAL_TYPE and CI_SEQUENCE_NUMBER columns. This join provides the descriptive details of the academic period for which the rate range is defined.
• IGF_AP_NEED_MTH_TYP: The table references the Need Methodology Type table via the METHOD_CODE column. This relationship ties the rate range to a specific financial aid calculation methodology.

The primary key constraint IGF_AP_GEN_TX_RTS_PK (on GTXRTS_ID) and the unique key constraint IGF_AP_GEN_TX_RTS_UK (on the composite of CI_CAL_TYPE, CI_SEQUENCE_NUMBER, METHOD_CODE, TABLE_CODE, and RANGE_START) enforce data integrity within this obsolete structure.