Search Results igs_en_unitsetfeetrg




Overview
Explore in AI Chat

Overview

The IGS_EN_UNITSETFEETRG table is a core data entity within the Oracle E-Business Suite Student System (IGS), specifically designed for fee assessment and management. It functions as a trigger mechanism that links specific unit sets (academic programs or groups of courses) to particular fee types. During the automated fee assessment processing run, the presence of a record in this table indicates that a student's enrollment in a defined unit set should trigger the application of an associated fee. This enables institutions to configure complex, program-based fee structures, ensuring accurate and automated financial charges are applied to student accounts based on their academic enrollment.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each fee trigger rule. The key columns are FEE_CAT (fee category), FEE_CAL_TYPE (fee calendar type), FEE_CI_SEQUENCE_NUMBER (fee calendar instance sequence), FEE_TYPE (the specific type of fee), UNIT_SET_CD (the code identifying the unit set), VERSION_NUMBER (the version of the unit set), and CREATE_DT (the creation date of the rule). This granularity allows for precise control over which fee applies to which version of a unit set within a specific fee assessment period and category. Additional columns, such as FEE_TRIGGER_GROUP_NUMBER, facilitate grouping multiple triggers for logical fee assessment.

Common Use Cases and Queries

The primary use case is the batch assessment of student fees. A typical reporting or validation query would join this table to the unit set and fee definition tables to list all active triggers. For example, to audit all unit set fee triggers for a specific fee category and calendar, one might use:

  • SELECT usft.unit_set_cd, usft.version_number, usft.fee_type, us.name FROM igs_en_unitsetfeetrg usft JOIN igs_en_unit_set_all us ON usft.unit_set_cd = us.unit_set_cd AND usft.version_number = us.version_number WHERE usft.fee_cat = 'TUITION' AND usft.fee_cal_type = 'ACADEMIC';

Another critical scenario is troubleshooting fee assessment results for a student, which involves checking if their enrolled unit sets have corresponding triggers in this table. Data fixes or implementations often require inserting or updating records here to align fee rules with new or modified academic programs.

Related Objects

IGS_EN_UNITSETFEETRG maintains strict referential integrity through foreign key relationships with other foundational tables in the Student and Financials modules. The documented relationships are:

  • IGS_FI_F_CAT_FEE_LBL_ALL: References FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FEE_TYPE. This validates the fee trigger against defined fee labels within a category.
  • IGS_FI_FEE_TRG_GRP: References FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, and FEE_TRIGGER_GROUP_NUMBER. This links the trigger to a broader logical grouping of fee triggers.
  • IGS_EN_UNIT_SET_ALL: References UNIT_SET_CD and VERSION_NUMBER. This ensures the trigger is associated with a valid and existing academic unit set definition.