Results for “igs_fi_dsb_cat”

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

Overview

IGS_FI_DSB_CAT is a legacy Oracle EBS table belonging to the IGS (Student System) product family, which is documented as obsolete in EBS 12.1.1 and 12.2.2. The table describes the mapping of user-definable disbursement categories to disbursement formulas for special reporting purposes. In practice, it acts as a cross-reference construct that links a category code to a specific formula within the context of a fee type, fee calendar, and fee calendar instance.

Based on the documented foreign key structure, the heuristic Data Vault classification for this object is a link table. This is consistent with its role as a many-to-many style mapping between the IGS_FI_DSBR_CAT disbursement category reference table and the IGS_FI_FEE_DSBR_FML disbursement formula table, qualified by fee calendar context.

The ETRM metadata further records that this object is "Not implemented in this database." That annotation means the table is not physically created in the reporting database examined by ETRM, and it should be treated as a documentation-only artifact for most implementations. Any reference to it in custom code, extracts, or historical reports should be validated against the actual schema before relying on it.

Key Information Stored

The primary key, IGS_FI_DSB_CAT_PK, is composite and comprises five columns: FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FORMULA_NUMBER, and DISBURSEMENT_CAT. There is no documented single-column surrogate key; the business key is the combination of these five attributes.

• FEE_TYPE — Identifies the fee type that scopes the mapping. Also participates in the foreign key to IGS_FI_FEE_DSBR_FML.
• FEE_CAL_TYPE — Identifies the fee calendar type (for example, an academic period pattern) within which the formula applies.
• FEE_CI_SEQUENCE_NUMBER — The sequence number of the specific fee calendar instance, tying the mapping to a concrete calendar occurrence.
• FORMULA_NUMBER — The disbursement formula identifier. This is the column most commonly searched for and is part of the foreign key to IGS_FI_FEE_DSBR_FML.
• DISBURSEMENT_CAT — The user-definable disbursement category code, foreign-keyed to IGS_FI_DSBR_CAT.

Notably, FORMULA_NUMBER is not the primary key by itself. It is a component of the composite key and a foreign key column, meaning filters on FORMULA_NUMBER alone may return multiple rows spanning different fee types, calendars, and categories.

Common Use Cases and Queries

Typical use cases involve reporting on how disbursement formulas are categorized, tracing which categories map to a given formula, and reconciling special reporting extracts where category-level grouping is required.

A straightforward lookup by formula number:

• SELECT fee_type, fee_cal_type, fee_ci_sequence_number, formula_number, disbursement_cat FROM igs_fi_dsb_cat WHERE formula_number = :formula_number;

Resolving the category description by joining to the category reference table:

• SELECT c.formula_number, r.disbursement_cat, r.description FROM igs_fi_dsb_cat c, igs_fi_dsbr_cat r WHERE c.disbursement_cat = r.disbursement_cat AND c.formula_number = :formula_number;

Validating formula context against the formula master:

• SELECT c.* FROM igs_fi_dsb_cat c, igs_fi_fee_dsbr_fml f WHERE c.fee_type = f.fee_type AND c.fee_cal_type = f.fee_cal_type AND c.fee_ci_sequence_number = f.fee_ci_sequence_number AND c.formula_number = f.formula_number;

Because the object is flagged as not implemented, queries should be preceded by an existence check against ALL_TABLES before use in production reporting.

Related Objects

The documented foreign keys identify two parent objects that this table depends on:

• IGS_FI_DSBR_CAT — referenced via DISBURSEMENT_CAT. Provides the valid disbursement category values and their descriptive attributes.
• IGS_FI_FEE_DSBR_FML — referenced via FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FORMULA_NUMBER. Provides the disbursement formula definition that the category is mapped to.

Related objects in the same functional area include the fee calendar and fee type definition tables that supply the context columns, as well as any reporting views built over the disbursement formula and category tables. Given the obsolete status, no supported public APIs are documented for this table, and inbound references from other tables are not recorded in the ETRM metadata.