Search Results igs_fi_fee_cat_all




Overview
Explore in AI Chat

Overview

The IGS_FI_FEE_CAT_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It functions as the master definition table for special contract-based fee assessment rates. Its primary role is to establish and maintain distinct fee categories that can be applied to student enrollments, program applications, and institutional agreements. These categories enable the system to implement differentiated fee structures, such as those governed by specific sponsorship contracts, corporate agreements, or special student cohorts, beyond standard tuition rates. As a multi-org table (indicated by the '_ALL' suffix), it stores data specific to different operating units, ensuring data isolation in a multi-organization environment.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as FEE_CAT. This column is the unique identifier for each fee category record. Based on its description and relational context, the table likely stores descriptive and control attributes for each category. Typical columns in such a master table would include a code (FEE_CAT), a description, an effective date range (START_DATE, END_DATE), and attributes controlling its applicability and calculation logic. The core data point is the FEE_CAT code itself, which is referenced by numerous downstream transactional tables to assign a specific fee assessment rate to a student, application, or term.

Common Use Cases and Queries

This table is central to queries and reports analyzing fee assessments based on special contracts. Common operational and reporting scenarios include identifying all students assigned to a particular corporate fee category, auditing fee category usage across programs, and managing the setup of new contractual fee arrangements. A typical query would join this master table to key transactional tables to retrieve descriptive information.

  • Listing Active Fee Categories: SELECT fee_cat, description FROM igs_fi_fee_cat_all WHERE sysdate BETWEEN start_date AND NVL(end_date, sysdate+1) AND org_id = :p_org_id;
  • Finding Students by Fee Category: This joins to the student program attempt table: SELECT spa.person_id, spa.course_cd, cat.fee_cat FROM igs_en_stdnt_ps_att_all spa JOIN igs_fi_fee_cat_all cat ON spa.fee_cat = cat.fee_cat WHERE cat.fee_cat = 'CORP_XYZ';

Related Objects

The IGS_FI_FEE_CAT_ALL table is a key reference point, linked via its primary key (FEE_CAT) to several important transactional tables in the Student System. The documented foreign key relationships are as follows:

  • IGS_AD_PS_APPL_INST_ALL: Links the fee category to specific program application instances for an institution.
  • IGS_FI_F_CAT_CA_INST: Associates the fee category with charge assessment instances, likely detailing the specific rates or rules.
  • IGS_FI_FEE_CAT_MAP: Maps the fee category to other system entities, potentially for translation or integration purposes.
  • IGS_EN_SPA_TERMS: Assigns the fee category to a student's program attempt for a specific academic term.
  • IGS_EN_STDNT_PS_ATT_ALL: Assigns a default or overarching fee category to a student's entire program attempt.

These relationships illustrate that the FEE_CAT code defined in this master table is integral to fee assessment processes across admissions, enrollment, and financial modules.