Search Results igs_fi_f_cat_ca_inst




Overview
Explore in AI Chat

Overview

The table IGS_FI_F_CAT_CA_INST is a core entity within the Oracle E-Business Suite Student System (IGS), specifically for the Financials module. Its primary function is to define the valid periods, or fee calendar instances, during which a specific fee category is assessed. This establishes a critical link between the definition of a fee (its category) and the academic calendar, ensuring fees are applied and processed within the correct institutional timeframes. It is important to note that this object is documented as part of an obsolete product line, indicating it belongs to a legacy component of the Student System. Furthermore, the provided metadata explicitly states it is "Not implemented in this database," suggesting it may be a reference or historical structure in standard EBS documentation, and its physical existence and data should be verified in any specific implementation.

Key Information Stored

The table's structure centers on identifying a unique fee assessment period for a fee category. Its composite primary key precisely defines this relationship. The key columns are:

  • FEE_CAT: The code identifying the specific category of fee (e.g., tuition, lab fee).
  • FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER: Together, these identify a specific instance (period) within the academic calendar, sourced from IGS_CA_INST_ALL, to which the fee category is applicable.

Additional significant columns, as indicated by foreign key relationships, include FEE_CAT_CI_STATUS (linking to a status in IGS_FI_FEE_STR_STAT), and date alias columns (START_DT_ALIAS, END_DT_ALIAS, RETRO_DT_ALIAS with their corresponding sequence numbers) which link to IGS_CA_DA_INST to define precise calendar dates for the start, end, and retroactive application of the fee period.

Common Use Cases and Queries

This table is central to queries that determine when and how fees are assessed. A primary use case is validating or reporting on all active fee periods for a given academic term. For instance, an institution may need to list all fee categories applicable to the 'FALL-2024' calendar instance. A typical query would join this table to the fee category and calendar instance tables.

Sample SQL Pattern:
SELECT fcci.*, fcat.description, ci.calendar_type
FROM igs_fi_f_cat_ca_inst fcci
JOIN igs_fi_fee_cat_all fcat ON fcci.fee_cat = fcat.fee_cat
JOIN igs_ca_inst_all ci ON fcci.fee_cal_type = ci.cal_type
AND fcci.fee_ci_sequence_number = ci.sequence_number
WHERE ci.cal_type = 'FALL'
AND ci.sequence_number = 2024
AND fcci.fee_cat_ci_status = 'ACTIVE';
This table also serves as a master reference for downstream financial processes, such as generating fee liabilities, payment schedules, and encumbrances, which are stored in related child tables.

Related Objects

Based on the documented foreign key relationships, IGS_FI_F_CAT_CA_INST sits at a nexus within the student financials schema. Its key relationships are:

  • Parent Tables (Referenced by this table):
    • IGS_FI_FEE_CAT_ALL: The master definition of the fee category (via FEE_CAT).
    • IGS_CA_INST_ALL: The academic calendar instance (via FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER).
    • IGS_FI_FEE_STR_STAT: The status of the fee category calendar instance (via FEE_CAT_CI_STATUS).
    • IGS_CA_DA_INST: Date aliases for the period's start, end, and retroactive dates.
  • Child Tables (Referencing this table): These objects store transactional or configuration data specific to a fee category and calendar instance.

All child relationships use the table's full primary key (FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER) as their foreign key.