Search Results igs_fi_unit_fee_trg




Overview
Explore in AI Chat

Overview

The IGS_FI_UNIT_FEE_TRG table is a core data entity within the Oracle E-Business Suite Student System (IGS), specifically for the Financials module. It defines unit-based fee triggers, which are rules that determine when a specific fee type should be assessed against a student based on their unit (course) enrollment. During the automated fee assessment processing run, the system references this table to identify applicable fees linked to particular units, their versions, locations, and class types. It is important to note that the provided ETRM metadata explicitly labels the IGS - Student System as "Obsolete," indicating this table belongs to a legacy component. Furthermore, the metadata states "Not implemented in this database," which may suggest it was part of a reference data model or a specific implementation where this functionality was not activated.

Key Information Stored

The table stores the combination of parameters that constitute a unit fee trigger. Its structure is defined by two composite primary keys, emphasizing the uniqueness of the fee rule. The key columns include identifiers for the fee structure itself (FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE) and the specific unit context to which it applies. This unit context is detailed by the unit code (UNIT_CD), its VERSION_NUMBER, the academic calendar instance (CAL_TYPE, CI_SEQUENCE_NUMBER), the LOCATION_CD where the unit is offered, and the UNIT_CLASS (e.g., lecture, lab). The SEQUENCE_NUMBER and FEE_TRIGGER_GROUP_NUMBER columns allow for ordering and grouping of multiple triggers. The CREATE_DT field tracks the record's creation date.

Common Use Cases and Queries

The primary use case is the batch assessment of student fees. A typical query would join this table to student unit attempt records to generate fee liabilities. For reporting and administration, queries often focus on listing all fee triggers for a given unit or fee type to audit fee rules.

  • Identifying Triggers for a Unit: SELECT * FROM IGS_FI_UNIT_FEE_TRG WHERE UNIT_CD = 'MATH101' AND VERSION_NUMBER = 1;
  • Auditing Fee Assessment Rules: A join to IGS_PS_UNIT_VER and IGS_FI_FEE_TYPE to produce a readable list of unit-based fees.
  • Fee Simulation: In a development or support context, queries against this table help simulate which fees would be triggered for a hypothetical student enrollment scenario.

Related Objects

IGS_FI_UNIT_FEE_TRG sits at the intersection of fee definition and academic structure. It has foreign key relationships to several fundamental tables, as documented in the ETRM:

These relationships ensure referential integrity, linking the fee trigger to valid configurations in the student system's core setup tables.