Results for “igs_fi_sub_elm_rng”

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

Overview

IGS_FI_SUB_ELM_RNG is a transactional configuration table in the IGS (Student System) product family of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It describes the sub-ranges applied to elements derived from charge methods for the purpose of determining fee assessment rates. In functional terms, it sits between the element range definition and the rate definition: an element range (IGS_FI_ELM_RANGE) may be subdivided into numbered sub-ranges, each with its own lower and upper bounds and an associated charge method code, and each sub-range then feeds into a rate record in IGS_FI_SUB_ER_RT. The table is owned by the IGS schema and is marked VALID in the ETRM data dictionary.

Data Vault classification (heuristic, mined from the foreign key structure) suggests this object is satellite-leaning. Its natural parent, IGS_FI_ELM_RANGE, acts as a hub or link for the element range, while IGS_FI_SUB_ELM_RNG carries the descriptive and qualifying attributes of each sub-range and therefore behaves as a satellite of that parent. The downstream rate table, IGS_FI_SUB_ER_RT, in turn depends on this satellite for its key.

Key Information Stored

The documented physical schema contains twelve columns. The most significant are:

• SUB_ER_ID — the surrogate primary key, enforced by IGS_FI_SUB_ELM_RNG_PK. It uniquely identifies each sub-range row and is the column referenced by downstream rate records.
• ER_ID — foreign key to IGS_FI_ELM_RANGE, identifying the parent element range to which this sub-range belongs. Together with SUB_RANGE_NUM it forms the unique business key IGS_FI_SUB_ELM_RNG_U1.
• SUB_RANGE_NUM — the ordinal number of the sub-range within the parent element range; the second component of the business-key unique index.
• SUB_LOWER_RANGE and SUB_UPPER_RANGE — the numeric or threshold boundaries that define where the sub-range begins and ends, used to bucket the derived element value for rate lookup.
• SUB_CHG_METHOD_CODE — the charge method code applicable to the sub-range, determining how the element value is computed or assessed within these bounds.
• LOGICAL_DELETE_DATE — soft-delete timestamp; a non-null value indicates the sub-range row has been logically removed without physical deletion.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS WHO columns providing audit and concurrency tracking.

The distinction between the surrogate key (SUB_ER_ID) and the business-key candidate (ER_ID + SUB_RANGE_NUM) matters for integration: external feeds should match on the business key, while internal joins and updates should use SUB_ER_ID.

Common Use Cases and Queries

Typical scenarios include static verification of fee sub-range configuration, reporting on active sub-ranges per element range, and rate validation joining to the downstream rate table. A representative listing query is:

• SELECT sub_er_id, er_id, sub_range_num, sub_lower_range, sub_upper_range, sub_chg_method_code FROM igs.igs_fi_sub_elm_rng WHERE er_id = :p_er_id AND logical_delete_date IS NULL ORDER BY sub_range_num;
• Joining to the rate table to produce a full assessment matrix: SELECT r.er_id, r.sub_range_num, r.sub_lower_range, r.sub_upper_range, t.rate_code FROM igs.igs_fi_sub_elm_rng r, igs.igs_fi_sub_er_rt t WHERE r.sub_er_id = t.sub_er_id AND r.logical_delete_date IS NULL;
• Detecting gaps or overlaps in configured bounds by comparing SUB_UPPER_RANGE of one row against SUB_LOWER_RANGE of the next SUB_RANGE_NUM within the same ER_ID.

Because the business key is unique, queries that de-duplicate on (ER_ID, SUB_RANGE_NUM) are safe, and reporting extracts commonly filter out logically deleted rows. All such queries should be executed with the IGS schema context or appropriate synonym and privilege grants.

Related Objects

The principal related objects, based on the documented foreign key relationships, are:

• IGS_FI_ELM_RANGE — parent element range table; joined via IGS_FI_SUB_ELM_RNG.ER_ID = IGS_FI_ELM_RANGE.ER_ID.
• IGS_FI_SUB_ER_RT — the rate table that references this object through IGS_FI_SUB_ER_RT.SUB_ER_ID = IGS_FI_SUB_ELM_RNG.SUB_ER_ID; it holds the assessment rates applied to each sub-range.
• Other fee-calculation and charge-method objects in the IGS Financials area that consume element ranges and rates, and the standard audit and WHO-related views that surface CREATED_BY, LAST_UPDATED_BY, and related audit columns.

Any delete or re-keying of SUB_ER_ID must respect the dependent rate rows in IGS_FI_SUB_ER_RT, and any change to ER_ID must remain consistent with the parent IGS_FI_ELM_RANGE record.