Search Results igs_fi_fee_as_rt_h_all




Overview
Explore in AI Chat

Overview

The table IGS_FI_FEE_AS_RT_H_ALL is a core data entity within the Oracle E-Business Suite (EBS) Student System (IGS) module, versions 12.1.1 and 12.2.2. It serves as a historical repository for special contract-based fee assessment rates. Its primary role is to maintain a time-sensitive record of fee rates applied to specific student cohorts or contractual agreements, enabling the system to track changes in assessment policies over time. This historical tracking is critical for audit purposes, financial reporting, and analyzing the evolution of fee structures tied to academic calendars, fee types, and various student or organizational attributes.

Key Information Stored

The table's composite primary key defines the unique combination required to identify a specific historical fee assessment rate record. This includes the core fee identifiers (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER), the relationship type (S_RELATION_TYPE), a specific RATE_NUMBER, and the HIST_START_DT which marks the effective beginning of that historical period. Beyond the key, the table stores attributes that define the precise scope of the rate. These include identifiers for the organizational party (ORG_PARTY_ID), academic structures like unit sets (UNIT_SET_CD, US_VERSION_NUMBER), units (UNIT_CD, UNIT_VERSION_NUMBER), unit levels (UNIT_LEVEL), unit types (UNIT_TYPE_ID), unit classes (UNIT_CLASS), and unit modes (UNIT_MODE). The presence of these columns allows for highly granular fee rate definitions based on complex academic and contractual criteria.

Common Use Cases and Queries

A primary use case is auditing the history of fee rates for a specific contract or student group. For instance, an analyst may need to report all rate changes for a particular fee type within an academic calendar. A typical query would filter on the fee identifiers and order by the historical start date. Another common scenario involves validating the applicable rate for a student at a given point in time, which requires joining this history table to student enrollment data and using a date-effective query pattern to find the valid record. Sample SQL to retrieve the historical timeline for a fee assessment rate might be:

  • SELECT hist_start_dt, rate_amount, unit_cd FROM igs_fi_fee_as_rt_h_all WHERE fee_type = 'TUITION' AND fee_cal_type = 'SEMESTER' AND fee_ci_sequence_number = 1 AND s_relation_type = 'CONTRACT' ORDER BY hist_start_dt DESC;

Reporting use cases often involve joining this table to its related foreign key tables to translate codes into meaningful descriptions for financial and compliance reports.

Related Objects

The table maintains extensive foreign key relationships with fundamental Student System tables, as documented in the ETRM. These relationships enforce data integrity and define the context for the fee rates. Key related objects include: