Search Results igs_ps_grp_fee_trg

Overview

The IGS_PS_GRP_FEE_TRG table is a core data entity within the Oracle E-Business Suite's Student System (IGS), specifically for release versions 12.1.1 and 12.2.2. It functions as a configuration and control table for managing program group-based fee assessments. Its primary role is to define the linkage between a specific fee type and a program group, serving as a trigger during automated fee assessment processing. When the system assesses fees for a student, this table is referenced to determine if a particular fee applies based on the student's enrollment in a program belonging to a defined course group. This enables institutions to implement complex, group-based fee structures efficiently.

Key Information Stored

The table's structure is designed to uniquely identify a fee trigger through its primary key and to maintain referential integrity with related master data. The critical columns include the composite primary key: FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, COURSE_GROUP_CD, and CREATE_DT. These columns store the fee category, calendar type, sequence number for the fee calendar instance, the specific fee type code, and the code for the relevant course group. The CREATE_DT timestamp records when the trigger record was established. The foreign key constraints explicitly tie this table to the master definitions for course groups (IGS_PS_GRP_ALL) and fee type labels (IGS_FI_F_CAT_FEE_LBL_ALL), ensuring data consistency.

Common Use Cases and Queries

The primary use case is the batch assessment of tuition and other fees, where the system queries this table to apply group-specific charges. For instance, a "Laboratory Fee" might be triggered only for students in programs belonging to the "SCIENCE" course group. Common operational and reporting queries involve listing all fee triggers for a given program group or validating fee setup. A typical SQL pattern for reporting would join this table to its parent tables to provide descriptive information.

• Identifying all fee triggers for a specific course group:

  SELECT * FROM igs.igs_ps_grp_fee_trg WHERE course_group_cd = '&GROUP_CODE';

• Reporting on the full fee trigger setup with descriptions:

  SELECT trg.*, grp.course_group_name, lbl.description fee_type_desc
  FROM igs.igs_ps_grp_fee_trg trg,
       igs.igs_ps_grp_all grp,
       igs.igs_fi_f_cat_fee_lbl_all lbl
  WHERE trg.course_group_cd = grp.course_group_cd
  AND trg.fee_cat = lbl.fee_cat
  AND trg.fee_cal_type = lbl.fee_cal_type
  AND trg.fee_ci_sequence_number = lbl.fee_ci_sequence_number
  AND trg.fee_type = lbl.fee_type;

Related Objects

IGS_PS_GRP_FEE_TRG is centrally connected to several key master tables in the Student and Financials modules. Its integrity is enforced through foreign key relationships. The primary related objects are:

• IGS_PS_GRP_ALL: The master table for Course Groups. The COURSE_GROUP_CD column in the fee trigger table references this to validate the applicable academic group.
• IGS_FI_F_CAT_FEE_LBL_ALL: The master table defining Fee Types within a Fee Category and Calendar. The composite foreign key (FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE) references this table, ensuring the triggered fee is properly defined.

This table is likely referenced by various fee assessment engines and batch processes within the IGS module, though those program units are not detailed in the provided metadata.