Results for “igs_fi_bal_ex_c_typs”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_FI_BAL_EX_C_TYPS table belongs to the IGS (Student System) product family within Oracle E-Business Suite, and is documented as VALID in the IGS schema across EBS 12.1.1 and 12.2.2. Its stated purpose is narrow but operationally significant: it captures the set of Credit Types that must be excluded from balance calculation logic. In functional terms, this table serves as an exception registry — a configuration surface through which institutions suppress selected credit types from contributing to a student's computed financial balance.

From a Data Vault modeling perspective, the metadata's FK structure supports classifying this object as a link. It holds no descriptive transactional facts of its own; instead it resolves the association between a Balance Rule and a Credit Type. This classification is a heuristic suggestion derived from the foreign key topology, not a mandated design.

Key Information Stored

The documented physical schema comprises nine columns. The most important are:

• BAL_EXC_CREDIT_TYPE_ID — the surrogate primary key, enforced by IGS_FI_BAL_EX_C_TYPS_PK and the unique index IGS_FI_BAL_EX_C_TYPS_U1. It uniquely identifies each exclusion record.
• BALANCE_RULE_ID — foreign key to IGS_FI_BALANCE_RULES, identifying the balance rule to which the exclusion applies.
• CREDIT_TYPE_ID — foreign key to IGS_FI_CR_TYPES_ALL, identifying the credit type being excluded.
• ENABLED_FLAG — controls whether a given exclusion is active, permitting rows to be retained but temporarily deactivated.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS WHO-style audit columns recording creation and modification provenance.

The unique index IGS_FI_BAL_EX_C_TYPS_U2 on (BALANCE_RULE_ID, CREDIT_TYPE_ID) is a business-key candidate: it guarantees that any given credit type is excluded at most once per balance rule, which is the table's central integrity constraint.

Common Use Cases and Queries

Typical scenarios include diagnosing why a particular charge is missing from a student's computed balance, auditing which credit types each balance rule suppresses, and reviewing configuration before period close. A representative query resolves the exclusion into readable names:

• SELECT ec.BAL_EXC_CREDIT_TYPE_ID, ec.BALANCE_RULE_ID, ec.CREDIT_TYPE_ID, ec.ENABLED_FLAG FROM IGS.IGS_FI_BAL_EX_C_TYPS ec WHERE ec.ENABLED_FLAG = 'Y' — returns all active exclusions.
• ... FROM IGS_FI_BAL_EX_C_TYPS ec, IGS_FI_BALANCE_RULES br, IGS_FI_CR_TYPES_ALL ct WHERE ec.BALANCE_RULE_ID = br.BALANCE_RULE_ID AND ec.CREDIT_TYPE_ID = ct.CREDIT_TYPE_ID — joined configuration report.
• Filter by CREDIT_TYPE_ID to determine every balance rule from which a given credit type is excluded.

Reporting use cases center on configuration attestation and reconciliation of balance results against intended business rules.

Related Objects

The documented referential relationships and the shared IGS_FI functional area point to the following significant objects:

• IGS_FI_BALANCE_RULES — parent of the BALANCE_RULE_ID foreign key; defines the rules against which exclusions operate.
• IGS_FI_CR_TYPES_ALL — parent of the CREDIT_TYPE_ID foreign key; the master list of credit types in the Student System.
• IGS_FI_BAL_EX_C_TYPS_PK / _U1 / _U2 — the primary key and unique indexes enforcing identity and the rule-plus-credit-type combination.
• Balance calculation and fee assessment program units within the IGS_FI module that consume these exclusions at runtime.
• Related balance-rule configuration tables and student account/credit transaction tables in the same schema that supply the credit types referenced here.