Search Results igs_fi_fee_type_hist_pk

Overview

The table IGS_FI_FEE_TYPE_HIST_ALL is a core data entity within the Oracle E-Business Suite (EBS) Student System (IGS). It serves as the historical record for fee type definitions, capturing changes to fee type attributes over time. Its primary role is to provide a complete audit trail for how a fee type—a classification used to apply charges and fees throughout the system—was configured at any given point in the past. This historical integrity is critical for accurate financial reporting, auditing of student accounts, and ensuring the correct application of fees based on their effective dates. As an "_ALL" table, it is designed to support a multi-organization structure (Multi-Org), storing data partitioned by the ORG_ID column.

Key Information Stored

The table stores historical snapshots of fee type configurations. Its structure is defined by a composite primary key consisting of FEE_TYPE and HIST_START_DT, which uniquely identifies each historical version. Key columns include the FEE_TYPE itself, which links to the current definition in IGS_FI_FEE_TYPE_ALL, and the HIST_START_DT, which marks the effective date of that historical version. Another critical column is SUBACCOUNT_ID, a foreign key to IGS_FI_SUBACCTS_ALL, which links the fee type to the appropriate general ledger sub-account for accounting purposes. Additional columns typically found in such historical tables would include HIST_END_DT, HIST_WHO (user who made the change), and various descriptive and control attributes valid for that specific period.

Common Use Cases and Queries

This table is essential for historical analysis and troubleshooting. A common use case is auditing the evolution of a fee's accounting setup. For instance, to trace all sub-account assignments for a specific fee type, one would query this history. Another critical scenario is generating financial reports for a prior period, ensuring fees are reported using the rules and account codes that were valid at that time, not the current configuration.

• Retrieving the full history of a fee type:
  SELECT fee_type, hist_start_dt, hist_end_dt, subaccount_id FROM igs_fi_fee_type_hist_all WHERE fee_type = 'TUITION' ORDER BY hist_start_dt;
• Finding the valid fee type configuration for a specific historical date:
  SELECT * FROM igs_fi_fee_type_hist_all WHERE fee_type = 'LAB_FEE' AND <target_date> BETWEEN hist_start_dt AND NVL(hist_end_dt, SYSDATE);
• Reporting on fee type changes within a date range: Queries often join this table with IGS_FI_FEE_TYPE_ALL and IGS_FI_SUBACCTS_ALL to provide descriptive context for reports.

Related Objects

The table maintains integral relationships with other key entities in the Student Financials module. Its primary foreign key relationship is with IGS_FI_FEE_TYPE_ALL, the table containing the current, active definition of each fee type. A second crucial foreign key links to IGS_FI_SUBACCTS_ALL, which defines the chart of accounts sub-account used for posting transactions of this fee type. The table IGS_FI_FEE_TYPE_HIST_ALL is the child table in these relationships. It is referenced by transactional and invoicing entities (such as IGS_FI_INV_INT_ALL or IGS_FI_CHARGE_ALL) when historical fee type data is required for validation or reporting on past transactions. The primary key constraint IGS_FI_FEE_TYPE_HIST_PK enforces data integrity for this historical record.