Results for “fee_trigger_group_number”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_FI_FEE_TRG_GRP is a transactional configuration table within the Oracle E-Business Suite Student System (IGS) product family, used to describe special contract-based fee assessment rates. In the Oracle EBS 12.1.1 and 12.2.2 data models, this table acts as a grouping construct that ties a fee trigger group number to a specific fee category, fee calendar, calendar instance sequence, and fee type. It enables institutions to define and manage fee trigger groups that control when and how fees are assessed against students under contract-based or non-standard fee arrangements, distinguishing these from the standard fee assessment rules maintained in the broader fee calendar infrastructure.

From a Data Vault modeling perspective, the heuristic classification for this table is hub-leaning. The composite primary key composed of business attributes suggests that IGS_FI_FEE_TRG_GRP functions as a central reference point from which downstream assessment and unit-fee records are keyed, making it a natural candidate for a hub entity with associated descriptive attributes.

Key Information Stored

The table is defined in the IGS schema and contains 13 documented columns. The most significant are:

• FEE_CAT — Fee category, the primary business qualifier for the fee definition.
• FEE_CAL_TYPE — Fee calendar type, identifying the calendar context under which the fee applies.
• FEE_CI_SEQUENCE_NUMBER — Calendar instance sequence number that resolves the specific calendar instance.
• FEE_TYPE — Fee type, further distinguishing the fee classification.
• FEE_TRIGGER_GROUP_NUMBER — The trigger group number that binds the record to a particular assessment trigger grouping.
• DESCRIPTION — Free-text description of the contract-based fee trigger group.
• COMMENTS — Additional narrative remarks supporting the record.
• LOGICAL_DELETE_DT — Logical deletion date supporting soft-delete semantics and effective-dating behavior.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns capturing who created and last modified the row, and when.

The surrogate primary key is defined by the constraint IGS_FI_FEE_TRG_GRP_PK and covers FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, and FEE_TRIGGER_GROUP_NUMBER. A unique index, IGS_FI_FEE_TRG_GRP_U1, is documented over the exact same five-column combination, effectively confirming this set as the business-key candidate.

Common Use Cases and Queries

Typical reporting and integration scenarios include verifying that fee trigger groups exist for a given fee category and calendar, auditing active versus logically deleted records, and joining to downstream assessment tables to confirm fee application. A representative query follows:

• SELECT fee_cat, fee_cal_type, fee_ci_sequence_number, fee_type, fee_trigger_group_number, description FROM igs_fi_fee_trg_grp WHERE logical_delete_dt IS NULL;
• SELECT * FROM igs_fi_fee_trg_grp WHERE fee_cat = :p_fee_cat AND fee_cal_type = :p_cal_type AND fee_trigger_group_number = :p_group;
• Audit reporting: SELECT last_updated_by, last_update_date FROM igs_fi_fee_trg_grp WHERE creation_date >= :p_from_date;

Related Objects

IGS_FI_FEE_TRG_GRP participates in a hub-and-spoke relationship with several assessment and unit-fee tables that reference its composite business key:

• IGS_FI_F_CAT_FEE_LBL_ALL — Referenced via FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FEE_TYPE, providing fee category label context.
• IGS_PS_FEE_TRG — References IGS_FI_FEE_TRG_GRP through FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, and FEE_TRIGGER_GROUP_NUMBER; used for program-of-study fee triggers.
• IGS_FI_UNIT_FEE_TRG — References the same key set and applies trigger groups to unit-based fee assessment.
• IGS_EN_UNITSETFEETRG — Ties enrollment unit-set fee triggers back to the trigger group definition.

Together these relationships confirm IGS_FI_FEE_TRG_GRP as the central reference table for contract-based fee trigger configuration in the Oracle Student System fee assessment architecture.