Search Results igs_fi_elm_range_h_pk

Overview

The IGS_FI_ELM_RANGE_H_ALL table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for release versions 12.1.1 and 12.2.2. As a history table, its primary role is to provide a complete audit trail for changes made to the configuration of fee element ranges. These ranges define the applicability of financial elements (fees) based on criteria like amounts or dates. The table captures a historical snapshot each time a range record is modified, enabling institutions to track the evolution of fee structures over time for compliance, reporting, and troubleshooting purposes.

Key Information Stored

The table stores historical versions of fee element range records, uniquely identified by a composite primary key. The key columns establish the specific fee context and the historical version. The FEE_TYPE, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER columns identify the fee calendar instance. The RANGE_NUMBER pinpoints the specific range within that fee structure, and the HIST_START_DT marks the effective date when that historical version became active. The metadata indicates two primary key definitions (ERH_UK and IGS_FI_ELM_RANGE_H_PK), with the latter including the S_RELATION_TYPE column, suggesting it may define the relationship context for the range. The FEE_CAT column stores the fee category code. Other typical columns in such a history table, inferred from standard patterns, would include HIST_END_DT, HIST_WHO, and the full set of data columns mirrored from the main IGS_FI_ELM_RANGE_ALL table at the time of the change.

Common Use Cases and Queries

This table is essential for auditing and historical analysis. Common use cases include generating reports on how a fee range's value or criteria changed between two academic periods, investigating student billing discrepancies by reviewing the fee rules in effect on a past date, and complying with financial governance requirements. A typical query retrieves the complete history for a specific fee element range.

• Sample Query: SELECT * FROM igs_fi_elm_range_h_all WHERE fee_type = 'TUITION' AND fee_cal_type = 'SEM' AND fee_ci_sequence_number = 202301 AND range_number = 1 ORDER BY hist_start_dt;
• Reporting Use Case: Comparing the active range definitions at the start and end of a fiscal year to analyze fee policy changes.

Related Objects

The IGS_FI_ELM_RANGE_H_ALL table maintains strong referential integrity with key setup tables in the Student System's financials component, as defined by its foreign keys. It is a direct historical counterpart to the main transaction table IGS_FI_ELM_RANGE_ALL. Its structure is validated against the fee label definition table (IGS_FI_F_CAT_FEE_LBL_ALL) via the FEE_CAT column and against the fee calendar instance table (IGS_FI_F_TYP_CA_INST_ALL) via the combination of FEE_TYPE, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER. Any forms, reports, or APIs that interact with fee element ranges will inherently rely on or update this history table to maintain the audit trail.