Search Results igs_fi_fee_cat_map




Overview
Explore in AI Chat

Overview

The IGS_FI_FEE_CAT_MAP table is a core data entity within the Oracle E-Business Suite Student System (IGS). Its primary role is to define and manage special contract-based fee assessment rates by establishing a mapping relationship between specific fee categories and admission categories. This mapping is a critical component of the financial assessment engine, enabling the system to apply specialized fee rules for students based on their admission classification. The table's existence supports complex tuition and fee models, particularly for institutional agreements or cohorts where standard fee schedules do not apply.

Key Information Stored

The table stores the fundamental link between two key classification entities. Its structure is defined by a composite primary key, ensuring a unique relationship for each fee and admission category pair. The critical columns are:

  • FEE_CAT: References a valid fee category from the IGS_FI_FEE_CAT_ALL table. This column identifies the specific type of fee (e.g., tuition, technology fee) to which the special assessment rule applies.
  • ADMISSION_CAT: References a valid admission category from the IGS_AD_CAT_ALL table. This column identifies the student admission classification (e.g., international, transfer, sponsored) that qualifies for the special fee rate.

Together, these columns form the IGS_FI_FEE_CAT_MAP_PK primary key. The table does not store the actual rate or amount; it defines the eligibility rule. The specific assessment logic and rates are typically managed in related fee setup tables or formulas referenced via these categories.

Common Use Cases and Queries

A primary use case is validating and reporting on special fee arrangements for distinct student populations. For instance, an institution may have a contract with a corporate partner where employees admitted under a specific "CORPORATE_SPONSOR" admission category receive a discounted rate for a "TUITION" fee category. This table would hold that mapping. Common queries include identifying all special fee categories applicable to a given admission category, or verifying if a mapping exists for a proposed new contract. A typical reporting SQL pattern would join to the referenced tables to retrieve descriptive names:

SELECT fcat.fee_cat, fcat.description fee_description, acat.admission_cat, acat.description adm_description FROM igs_fi_fee_cat_map map, igs_fi_fee_cat_all fcat, igs_ad_cat_all acat WHERE map.fee_cat = fcat.fee_cat AND map.admission_cat = acat.admission_cat ORDER BY acat.admission_cat, fcat.fee_cat;

Related Objects

The IGS_FI_FEE_CAT_MAP table maintains strict referential integrity with two key master tables in the Student System, as documented by its foreign keys:

  • IGS_FI_FEE_CAT_ALL: This is the master table for fee categories. The IGS_FI_FEE_CAT_MAP.FEE_CAT column references IGS_FI_FEE_CAT_ALL.FEE_CAT. Any fee category used in a mapping must be predefined here.
  • IGS_AD_CAT_ALL: This is the master table for admission categories. The IGS_FI_FEE_CAT_MAP.ADMISSION_CAT column references IGS_AD_CAT_ALL.ADMISSION_CAT. Any admission category used in a mapping must be predefined here.

These relationships ensure data consistency, preventing the creation of special fee rules for invalid categories. The table is likely referenced by various financial assessment and invoicing programs within the IGS module that process student fees based on admission data.