Results for “igs_fi_elm_range”

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

Overview

IGS_FI_ELM_RANGE is a transactional configuration table within the Oracle E-Business Suite IGS (Student System) product family. As documented in the ETRM 12.1.1 metadata, the entity "describes ranges applied to elements derived from charge methods for the purpose of determining fee assessment rates." In practical terms, the table stores the numeric band boundaries that drive tiered or scaled fee calculations for student charges, such as sliding-scale tuition, banded course fees, or graduated assessment structures. It is a component of the Student System's fee-calculation engine, which applies rules against element ranges to derive the amount a student is charged.

The metadata carries a Heuristic Data Vault classification of satellite-leaning. Read as a modeling suggestion, this implies the table behaves as a descriptive, attribute-bearing satellite keyed by ER_ID, which is more a context record than a true hub or link. It holds business attributes (range boundaries, fee categories) rather than merely connecting actors, consistent with a satellite role. The ETRM record notes that this object is "Not implemented in this database," and the product is flagged obsolete, so its primary value today is for legacy integration, migration assessment, and understanding historical fee structures.

Key Information Stored

The table contains 20 documented columns. The surrogate primary key is ER_ID, defined by constraint IGS_FI_ELM_RANGE_PK and enforced through unique index IGS_FI_ELM_RANGE_U1. Among the columns, the most significant include:

• ER_ID — the surrogate primary key uniquely identifying each range record; also the join anchor used by dependent tables.
• FEE_TYPE — the fee type to which the range applies; part of the composite foreign key to IGS_FI_F_TYP_CA_INST_ALL.
• FEE_CAL_TYPE — the fee calendar type, used with FEE_TYPE and FEE_CI_SEQUENCE_NUMBER to identify the applicable fee assessment context.
• FEE_CI_SEQUENCE_NUMBER — the calendar instance sequence number completing the fee-context key.
• FEE_CAT — the fee category; part of the composite foreign key to IGS_FI_F_CAT_FEE_LBL_ALL.
• RANGE_NUMBER — the ordinal identifier of the band, ordering ranges within a set.
• LOWER_RANGE and UPPER_RANGE — the numeric boundaries defining each band; the core business attributes of the entity.
• S_RELATION_TYPE and S_CHG_METHOD_TYPE — flags describing the relation and charge-method type governing interpretation of the range.
• LOGICAL_DELETE_DT — soft-delete marker used to retire ranges without physical removal.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, and PROGRAM_UPDATE_DATE.

Business-key candidacy is represented primarily by the ER_ID unique index; the composite FEE_TYPE / FEE_CAL_TYPE / FEE_CI_SEQUENCE_NUMBER / FEE_CAT combination functions as a functional key when combined with RANGE_NUMBER.

Common Use Cases and Queries

Typical use is resolving which range band applies to a given fee assessment. Reporting queries join to the fee category and fee type tables and filter by active ranges:

• Band lookup: select LOWER_RANGE, UPPER_RANGE from IGS_FI_ELM_RANGE where FEE_TYPE = :p_type and FEE_CAT = :p_cat and LOGICAL_DELETE_DT is null.
• Ordered band listing: order by RANGE_NUMBER to reconstruct the tier ladder for a fee context.
• Dependency analysis: join IGS_FI_SUB_ELM_RNG on ER_ID to find subordinate elements referencing each range.
• Audit reporting: filter on LAST_UPDATE_DATE or PROGRAM_ID to track configuration changes.

Related Objects

• IGS_FI_F_CAT_FEE_LBL_ALL — joined on FEE_CAT, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER; provides fee-category labeling.
• IGS_FI_F_TYP_CA_INST_ALL — joined on FEE_TYPE, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER; supplies fee-type calendar-instance context.
• IGS_FI_SUB_ELM_RNG — references IGS_FI_ELM_RANGE.ER_ID, representing subordinate element ranges that depend on the parent band.
• IGS_FI_ELM_RANGE_PK / IGS_FI_ELM_RANGE_U1 — the primary key constraint and unique index on ER_ID.