Search Results FORMULA_NUMBER

Overview

The IGS_FI_DSB_CAT table is a core data entity within the now-obsolete Oracle E-Business Suite Student System (IGS). Its primary function is to manage the mapping between user-defined disbursement categories and specific disbursement formulas. This mapping is critical for specialized financial reporting, enabling institutions to categorize and report on student fee disbursements according to custom business rules. The table's design establishes a formal relationship between a defined fee structure and the logic used to calculate disbursements for particular reporting categories. It is important to note that, per the provided ETRM documentation, this specific table was marked as "Not implemented in this database" at the time of the metadata extract, indicating it may not be present in all deployment instances.

Key Information Stored

The table's structure is defined by a composite primary key and holds essential mapping data. The key columns are FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FORMULA_NUMBER, and DISBURSEMENT_CAT. The FORMULA_NUMBER column, which was the focus of the user's search, is integral as it stores the identifier linking a specific disbursement calculation rule (formula) to the other entities in the key. The DISBURSEMENT_CAT column stores the user-defined category code for reporting. Together, these columns ensure a unique mapping for a given fee calendar instance, fee type, disbursement category, and formula. This design supports complex scenarios where different disbursement formulas might apply to the same fee based on the reporting category.

Common Use Cases and Queries

The primary use case revolves around financial reporting and audit trails for student fee disbursements. Administrators would use this mapping to generate reports that segment disbursement data by custom categories, with calculations driven by the associated formula. A typical query would retrieve all formula mappings for a specific fee or category. For example, to find all disbursement categories and their assigned formulas for a particular fee, one might use a SQL pattern such as: SELECT DISBURSEMENT_CAT, FORMULA_NUMBER FROM IGS_FI_DSB_CAT WHERE FEE_TYPE = :p_fee_type AND FEE_CAL_TYPE = :p_cal_type AND FEE_CI_SEQUENCE_NUMBER = :p_sequence;. Conversely, identifying all fee structures using a specific formula number would involve querying on the FORMULA_NUMBER column directly, which is essential for impact analysis if a formula rule is modified.

Related Objects

The IGS_FI_DSB_CAT table maintains integrity through defined foreign key relationships with two other tables in the IGS module. It references the IGS_FI_DSBR_CAT table via the DISBURSEMENT_CAT column, which likely contains the descriptive details and validation rules for the disbursement categories themselves. More significantly, it references the IGS_FI_FEE_DSBR_FML table through a composite foreign key consisting of FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FORMULA_NUMBER. This indicates that IGS_FI_FEE_DSBR_FML is the master table defining the valid disbursement formulas available for specific fee calendar instances, and IGS_FI_DSB_CAT extends that definition by assigning those formulas to reporting categories.