Results for “igs_fi_elm_range_h_all”

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

Overview

IGS_FI_ELM_RANGE_H_ALL is a historical (audit) table within the Oracle E-Business Suite Student System module (IGS), which is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. The table captures the full change history of element ranges used in fee and charge calculation processing. Each time a range definition is modified — whether the lower or upper boundary, the calculation method, or the associated fee category changes — a new historical row is written with an effective start date, allowing point-in-time reconstruction of how a range looked at any given moment.

The metadata does not reveal a strict Data Vault hierarchy, but the FK structure (FEE_CAT referencing IGS_FI_F_CAT_FEE_LBL_ALL and FEE_TYPE referencing IGS_FI_F_TYP_CA_INST_ALL) plus the heavy business-key composition suggests a satellite classification heuristically — a descriptive history table attached to a hub/link of fee element range business keys. In practice, this acts as the temporal extension of the current IGS_FI_ELM_RANGE table pattern.

Key Information Stored

The primary key ERH_UK is a composite surrogate-style unique identifier built from FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, RANGE_NUMBER, FEE_CAT, and HIST_START_DT. This combination uniquely identifies a historical version of a fee range.

• FEE_TYPE and FEE_CAL_TYPE — identify the fee and its calendar context.
• FEE_CI_SEQUENCE_NUMBER — links the range to a specific calendar instance.
• S_RELATION_TYPE — the relationship type, part of the secondary unique index U1.
• RANGE_NUMBER — the ordinal of the range within the element.
• FEE_CAT — the fee category, a FK to IGS_FI_F_CAT_FEE_LBL_ALL.
• HIST_START_DT / HIST_END_DT — the effective dating window for this historical version.
• HIST_WHO — the user who made the change.
• LOWER_RANGE / UPPER_RANGE — the numeric boundaries of the range.
• S_CHG_METHOD_TYPE — the calculation method applied to the range.
• ORG_ID — the operating unit for multi-org security.

The standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide row-level audit metadata. The unique index IGS_FI_ELM_RANGE_H_ALL_U1 on (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, S_RELATION_TYPE, RANGE_NUMBER, HIST_START_DT) identifies the business key candidate.

Common Use Cases and Queries

Typical reporting needs include reconstructing a fee range as of a past date, auditing who changed a boundary and when, and validating that historical ranges do not overlap.

• Point-in-time reconstruction: SELECT * FROM IGS_FI_ELM_RANGE_H_ALL WHERE FEE_TYPE = :p AND HIST_START_DT <= :as_of AND NVL(HIST_END_DT, SYSDATE) > :as_of;
• Change audit trail: filter by HIST_WHO and HIST_START_DT to see modifications by user and period.
• Range gap analysis: compare LOWER_RANGE and UPPER_RANGE across sequential HIST_START_DT values.
• Multi-org reporting: constrain by ORG_ID for a specific operating unit.

Related Objects

• IGS_FI_F_CAT_FEE_LBL_ALL — joined on FEE_CAT, providing fee category labels.
• IGS_FI_F_TYP_CA_INST_ALL — joined on FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER for the fee calendar instance.
• The current (non-historical) element range table following the same IGS_FI_ELM_RANGE naming pattern.
• IGS_FI_ELM_RANGE_H_PK provides an alternate PK perspective including S_RELATION_TYPE.