Search Results igs_fi_fee_dsbr_fml




Overview
Explore in AI Chat

Overview

The IGS_FI_FEE_DSBR_FML table is a core data entity within the Oracle E-Business Suite Student System (IGS), specifically designed for managing complex fee assessment rules. Its primary role is to store special contract-based fee assessment rates, often referred to as disbursement formulas. These formulas enable institutions to define and apply customized fee calculations that deviate from standard fee schedules, typically based on specific agreements, sponsorships, or student contracts. The table is integral to the financial modules of the Student System, allowing for precise and conditional fee allocation. It is important to note that, according to the provided metadata, this specific object may not be implemented in all database instances, indicating its use could be conditional on specific institutional configurations or module implementations.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each disbursement formula rule. The key columns are FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FORMULA_NUMBER. This combination links the formula to a specific fee within a defined academic calendar context. While the full column list is not detailed in the excerpt, the foreign key relationships imply the presence of critical attributes such as CLASSIFICATION_CD, which links to an accounting class (IGS_FI_ACC_CLASS), and OVERRIDE_FORMULA, which creates a hierarchical relationship allowing one formula to supersede another. The table essentially acts as a header or definition table for a set of fee disbursement rules.

Common Use Cases and Queries

The primary use case is the administration and application of non-standard fee calculations. This is critical for handling sponsored students, corporate billing agreements, or special financial aid packages where fees are calculated based on a unique formula rather than a published rate. A common reporting need would be to list all active special fee formulas for a given fee type and calendar. A sample query pattern would involve joining to related detail tables to get the full rule definition.

SELECT fml.*
FROM igs_fi_fee_dsbr_fml fml
WHERE fml.fee_type = 'TUITION'
  AND fml.fee_cal_type = 'SEMESTER'
  AND fml.fee_ci_sequence_number = 202401;

Another critical operational query would validate formula hierarchies by checking for circular references in the OVERRIDE_FORMULA self-relationship.

Related Objects

The IGS_FI_FEE_DSBR_FML table sits at the center of a network of related entities governing fee disbursement logic, as evidenced by its foreign key relationships.

  • IGS_FI_ACC_CLASS: Linked via CLASSIFICATION_CD, associating the formula with a specific accounting classification for financial posting.
  • IGS_FI_DSB_DTL_ALC: A detail table likely storing allocation rules, joined on the four primary key columns (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FORMULA_NUMBER).
  • IGS_FI_DSB_CAT: Likely a category or grouping table for disbursements, also joined on the four primary key columns.
  • IGS_FI_FEE_DSB_FM_RU: Presumably a child table storing the specific rule components or conditions of the formula, joined on the same four primary key columns.
  • Self-Referential Foreign Key: The table references itself via (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, OVERRIDE_FORMULA), creating a hierarchy where one formula can override another, enabling complex rule precedence.