Search Results igs_fi_bal_ex_f_typs_uk

Overview

The table IGS_FI_BAL_EX_F_TYPS is a configuration table within the Oracle E-Business Suite (EBS) Student System (IGS), which is now marked as obsolete. Its primary function is to support the financial balance calculation logic by defining specific exclusions. The table serves as a junction, linking a balance calculation rule to the specific fee types that must be excluded from the calculation of a student's outstanding financial balance. This ensures that certain charges, which may be non-monetary, deferred, or otherwise irrelevant for a particular balance assessment, do not skew the calculated amount. Its existence is critical for tailoring financial reporting and dunning processes to institutional policies.

Key Information Stored

The table's structure is designed to maintain a simple list of exclusions per balance rule. The key columns include the surrogate primary key, BAL_EXC_FEE_TYPE_ID, and the two foreign key columns that define the relationship. The BALANCE_RULE_ID column references the specific balance calculation rule being configured. The FEE_TYPE column holds the code for the fee type (e.g., a specific library fine or application fee) that should be ignored when the linked balance rule is executed. The combination of BALANCE_RULE_ID and FEE_TYPE is enforced as a unique key (IGS_FI_BAL_EX_F_TYPS_UK) to prevent duplicate exclusions for the same rule.

Common Use Cases and Queries

The primary use case is the runtime evaluation of a student's financial balance. When a process, such as generating a statement of account or assessing a financial hold, invokes a specific balance rule, the system queries this table to filter out the designated fee types from the balance total. A common reporting query would involve joining this table to the fee type and balance rule descriptions for administrative review. For example, an administrator might run a query to audit all exclusions for a given rule:

• SELECT brt.rule_name, ft.fee_type, ft.description FROM igs_fi_bal_ex_f_typs ex, igs_fi_balance_rules brt, igs_fi_fee_type_all ft WHERE ex.balance_rule_id = brt.balance_rule_id AND ex.fee_type = ft.fee_type AND brt.rule_name = 'RULE_NAME';

Another critical operational query would be used by the balance calculation engine itself to dynamically exclude fees: SELECT fee_type FROM igs_fi_bal_ex_f_typs WHERE balance_rule_id = :rule_id;

Related Objects

IGS_FI_BAL_EX_F_TYPS is centrally connected to two core financial tables in the Student System, as defined by its foreign key constraints. It is a child table of IGS_FI_BALANCE_RULES, joining on the BALANCE_RULE_ID column. This relationship ties each exclusion record to a master balance calculation rule. Secondly, it references IGS_FI_FEE_TYPE_ALL via the FEE_TYPE column, ensuring that only valid, defined fee types can be marked for exclusion. There are no documented foreign keys where other tables reference IGS_FI_BAL_EX_F_TYPS, positioning it as a terminal configuration point within its data model.