Search Results igs_ps_type_fee_trg




Overview
Explore in AI Chat

Overview

The IGS_PS_TYPE_FEE_TRG table is a core data entity within the Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a configuration and mapping table that defines fee triggers based on a student's program type. Its primary role is to be referenced during the automated fee assessment process to determine when a specific fee, categorized under a particular fee calendar, should be applied to a student based solely on the type of academic program (e.g., undergraduate, postgraduate) in which they are enrolled. This enables the institution to establish standardized fee rules at the program type level, ensuring consistent and automated financial charges.

Key Information Stored

The table stores the combination of attributes that uniquely identifies a valid program type fee trigger. Its primary key consists of the following columns, which collectively link a fee definition to a specific program type: FEE_CAT (Fee Category), FEE_CAL_TYPE (Fee Calendar Type), FEE_CI_SEQUENCE_NUMBER (Fee Calendar Instance Sequence Number), FEE_TYPE, COURSE_TYPE (Program Type), and CREATE_DT (Creation Date). The CREATE_DT is part of the primary key to maintain a historical record of when the trigger rule was established. The core business logic resides in the relationship between the FEE_TYPE and the COURSE_TYPE, indicating that the specified fee is applicable for the given program type within the context of the defined fee calendar and category.

Common Use Cases and Queries

The primary use case is the batch or real-time assessment of student fees. A fee engine process queries this table to find all applicable fee triggers for a student's program type. Common reporting and validation queries include listing all active fee triggers for a specific program type or fee calendar. For example, to audit all fee triggers for 'UNDERGRAD' course types in a given fee calendar, one might use:

  • SELECT fee_type, fee_cat FROM igs_ps_type_fee_trg WHERE course_type = 'UNDERGRAD' AND fee_cal_type = 'ACADEMIC' AND fee_ci_sequence_number = 202401;

Another critical scenario is during the setup of a new fee or program type, where administrators must query this table to avoid creating duplicate trigger rules. Data fixes may also involve inserting or updating records in this table to correct fee assessment outcomes for cohorts of students.

Related Objects

IGS_PS_TYPE_FEE_TRG is centrally linked to two key master tables via foreign key constraints. The COURSE_TYPE column references the IGS_PS_TYPE_ALL table, which holds the definition of all valid program types in the system. The composite key of FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FEE_TYPE references the IGS_FI_F_CAT_FEE_LBL_ALL table, which defines the valid fee labels within a fee category and calendar instance. This relationship ensures that only valid, pre-defined fee types and program types can be used in a trigger rule. The table is primarily read by fee assessment engine programs and is likely referenced by key Student System forms for fee trigger maintenance.