Results for “igs_fi_fee_dsbr_fml_pk”

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

Overview

IGS_FI_FEE_DSBR_FML is a table within the Oracle E-Business Suite IGS — Student System product family. Its documented description states that it "describes special contract based fee assessment rates." In practical terms, the table stores the disbursement formula definitions that govern how contract-based fee assessments are calculated and distributed for a given fee type, fee calendar, and calendar instance. It serves as a configuration or rules repository consulted during fee assessment processing so that the system knows which disbursement formulas apply and under what conditions.

Based on the foreign-key topology mined from the ETRM metadata, this object is classified heuristically as hub-leaning within a Data Vault modeling approach. The classification is a modeling suggestion rather than a physical implementation detail: the table's composite primary key anchors a set of business keys (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FORMULA_NUMBER), and multiple downstream tables reference it. The metadata notes a self-referencing relationship, which in Data Vault terms can be modeled as a recursive link or a hierarchy within the hub. Note also that the ETRM entry explicitly records "Not implemented in this database" under Implementation/DBA Data, indicating the object is documented in the data model but not instantiated in the queried environment.

Key Information Stored

The table is keyed by the composite primary key IGS_FI_FEE_DSBR_FML_PK, defined over FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FORMULA_NUMBER. These four columns collectively form the business-key candidate and the documented unique index, distinguishing the row from the surrogate identity used internally. The most significant columns documented in the metadata include:

• FEE_TYPE — identifies the category of fee to which the disbursement formula applies; a core business key and part of the primary key.
• FEE_CAL_TYPE — the fee calendar type, scoping the formula to a particular academic or billing calendar.
• FEE_CI_SEQUENCE_NUMBER — the calendar instance sequence, further narrowing the formula to a specific instance of the calendar type.
• FORMULA_NUMBER — the identifier of the disbursement formula record; part of the primary key.
• CLASSIFICATION_CD — a foreign key referencing IGS_FI_ACC_CLASS, tying the formula to an account classification used in fee accounting.
• OVERRIDE_FORMULA — a self-referencing foreign key that allows one formula row to override or substitute another, enabling layered or exception-based assessment logic.

The remaining attributes are not individually enumerated here because the excerpt defers to the full data model; only the columns appearing in the documented metadata are named above. Together these columns define the contract-based fee assessment rate rules that downstream disbursement allocation and category processing rely upon.

Common Use Cases and Queries

Typical usage centers on fee assessment and disbursement setup and validation. Administrative queries retrieve the formulas configured for a given fee type and calendar to confirm correct contract mapping. A common pattern joins the table to its account classification to resolve the classification description:

• Configuration review: select the formulas defined for a fee type across calendar instances to audit contract-based rate coverage.
• Override tracing: follow the OVERRIDE_FORMULA self-reference to determine which formula supersedes another for the same fee type and calendar.
• Downstream impact analysis: join to IGS_FI_DSB_DTL_ALC, IGS_FI_DSB_CAT, and IGS_FI_FEE_DSB_FM_RU on the four key columns to see which disbursement categories, allocation details, and formula rules depend on a given row.

A representative SQL pattern selects the key columns and resolves classification, for example selecting FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FORMULA_NUMBER, and CLASSIFICATION_CD from IGS_FI_FEE_DSBR_FML while joining IGS_FI_ACC_CLASS on CLASSIFICATION_CD. Because the object is not physically implemented in some environments, queries should be guarded against ORA-00942 conditions during model validation.

Related Objects

The following are the most significant objects related through the documented FK/PK relationships:

• IGS_FI_ACC_CLASS — referenced via IGS_FI_FEE_DSBR_FML.CLASSIFICATION_CD; supplies account classification detail.
• IGS_FI_DSB_DTL_ALC — references this table on FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FORMULA_NUMBER; holds disbursement allocation detail.
• IGS_FI_DSB_CAT — references this table on the same four columns; defines disbursement categories.
• IGS_FI_FEE_DSB_FM_RU — references this table on the same four columns; stores formula rule definitions.
• IGS_FI_FEE_DSBR_FML (self) — referenced through FEE_TYPE and OVERRIDE_FORMULA, supporting formula selection and override hierarchies.

Collectively, these dependencies establish IGS_FI_FEE_DSBR_FML as a central hub for contract-based fee disbursement formula configuration within the IGS Student System.