Search Results igs_fi_bal_ex_c_typs




Overview
Explore in AI Chat

Overview

The table IGS_FI_BAL_EX_C_TYPS is a configuration table within the Oracle E-Business Suite Student System (IGS) module, specifically for Release 12.1.1 and 12.2.2. Its primary function is to support the financial balance calculation engine by defining exceptions. The table stores a list of specific credit types that the system must exclude or ignore when calculating a student's financial balance. This allows institutions to implement nuanced financial rules, ensuring that certain types of credits, such as promotional waivers or non-monetary adjustments, do not artificially inflate or reduce a calculated receivable balance. It acts as a critical child table to the broader balance rule definitions.

Key Information Stored

The table's structure is designed to link a balance rule with the credit types to be excluded. The key columns are:

  • BAL_EXC_CREDIT_TYPE_ID: The primary key surrogate identifier for each record in this table.
  • BALANCE_RULE_ID: A foreign key column linking to the IGS_FI_BALANCE_RULES table. This identifies the specific financial balance rule for which the exclusion is defined.
  • CREDIT_TYPE_ID: A foreign key column linking to the IGS_FI_CR_TYPES_ALL table. This identifies the precise type of credit (e.g., scholarship, waiver, adjustment) that should be omitted from balance calculations under the associated rule.
The unique key constraint on BALANCE_RULE_ID and CREDIT_TYPE_ID ensures that a specific credit type cannot be duplicated for exclusion under the same balance rule.

Common Use Cases and Queries

This table is primarily accessed during the execution of automated balance calculation processes and for administrative configuration. A common operational use case is an institution creating a rule to calculate "Tuition Due" while excluding all credits classified as "External Scholarship." Administrators would query this table to audit or report on existing exclusions. A typical SQL query to list all excluded credit types for a given balance rule would be: 

SELECT crt.credit_type_code, crt.description
FROM igs_fi_bal_ex_c_typs excl,
     igs_fi_cr_types_all crt
WHERE excl.balance_rule_id = :p_balance_rule_id
AND excl.credit_type_id = crt.credit_type_id;
Another critical reporting use case involves verifying the integrity of configuration data by identifying balance rules with no defined exclusions or validating that deprecated credit types are not still referenced in exclusion rules.

Related Objects

The IGS_FI_BAL_EX_C_TYPS table has defined dependencies within the Student System schema, primarily through its foreign key relationships:

  • Parent Table: IGS_FI_BALANCE_RULES via column BALANCE_RULE_ID. This is the master table defining the financial balance calculation rules for which exclusions are specified.
  • Parent Table: IGS_FI_CR_TYPES_ALL via column CREDIT_TYPE_ID. This reference table holds the valid list of credit types (e.g., waiver, scholarship, payment) used across the financial module, from which the exclusions are selected.
These relationships are enforced by foreign key constraints, ensuring referential integrity. The table is central to the configuration hierarchy, sitting between a rule definition (IGS_FI_BALANCE_RULES) and the foundational data defining credit types (IGS_FI_CR_TYPES_ALL).