Search Results igs_fi_fee_trg_grp




Overview
Explore in AI Chat

Overview

The IGS_FI_FEE_TRG_GRP table is a core data entity within the Oracle E-Business Suite's now-obsolete Student System (IGS) module. Its primary function is to define and manage special contract-based fee assessment rates. This table acts as a master grouping mechanism for fee triggers, allowing institutions to associate specific, often discounted or negotiated, fee rates with defined groups of students or academic activities based on contractual agreements. The metadata explicitly notes that this table was "Not implemented in this database," indicating it may have been part of a planned or legacy feature set not deployed in standard Oracle EBS 12.1.1 or 12.2.2 instances, though its structure remains defined within the data model.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each fee trigger group record. The key columns are FEE_CAT (fee category), FEE_CAL_TYPE (fee calendar type), FEE_CI_SEQUENCE_NUMBER (fee calendar instance sequence number), FEE_TYPE (the specific type of fee), and FEE_TRIGGER_GROUP_NUMBER (a unique identifier for the group within the preceding context). While the specific descriptive columns for the group (such as a name or rate modifier) are not detailed in the provided excerpt, the table's purpose is to store the definition of the group itself. The primary key columns establish the precise fee structure to which the special contractual rates apply.

Common Use Cases and Queries

In a functional implementation, this table would be central to administering bespoke fee agreements. Common use cases would include creating and maintaining fee groups for corporate training contracts, special cohort discounts, or partnership program rates. A typical reporting query would join this table to its related fee trigger tables to list all defined contract groups for a specific fee type. For example, a SQL pattern to identify all trigger groups for a given fee might be: SELECT * FROM IGS_FI_FEE_TRG_GRP WHERE fee_cat = :p_cat AND fee_type = :p_type AND fee_cal_type = :p_cal_type;. Data maintenance would involve inserting new groups or updating existing ones via the application's dedicated forms or APIs, ensuring referential integrity with the linked fee definition and trigger tables.

Related Objects

The IGS_FI_FEE_TRG_GRP table sits at the center of a relational network with several key tables, as documented by its foreign key relationships. It is a child table to IGS_FI_F_CAT_FEE_LBL_ALL, which defines the base fee label. Crucially, it is a parent table to multiple entities that define what triggers the application of the special contract fee group:

These relationships share the same join columns: FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, and FEE_TRIGGER_GROUP_NUMBER. This design allows a single defined contract fee group to be referenced by triggers across different academic entities (programs, units, unit sets).