Results for “sub_upper_range”

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

Overview

IGS_FI_SUB_ELM_RNG_V is an Oracle E-Business Suite database view owned by the APPS schema within the IGS (Student System) product. Its documented purpose is to fetch Sub Element Range records, exposing the range definition rows used in Oracle Student System's fee and charge calculation engine. In EBS 12.1.1 and 12.2.2, the view serves as a reporting and integration surface over the underlying Sub Element Range entity, joining it to the standard lookup values table to translate the charge method code into a user-facing description.

The view is relevant to the sub_lower_range search term because it exposes the SUB_LOWER_RANGE column directly, along with its paired SUB_UPPER_RANGE column. Together these columns define the numeric band within which a particular sub-element charge method applies. This makes the view a convenient read-only access point for analyzing fee range thresholds without querying the base table directly.

Underlying Base Objects

The view is defined over two objects, as documented in the ETRM metadata:

• IGS_FI_SUB_ELM_RNG — the base Sub Element Range table, which stores each range record. The view selects its columns along with the ROWID.
• IGS_LOOKUP_VALUES — the standard Oracle lookup table, joined with an outer join (denoted by the (+) syntax) to translate the charge method code.

The join condition links SER.SUB_CHG_METHOD_CODE to LV.LOOKUP_CODE, restricted to LV.LOOKUP_TYPE = 'CHG_METHOD'. Because the join is outer, range rows that reference a charge method code with no matching lookup value are still returned, with the lookup-derived columns null. The documented view text shows this join exactly as: SER.SUB_CHG_METHOD_CODE = LV.LOOKUP_CODE (+) with LV.LOOKUP_TYPE(+) = 'CHG_METHOD'. No other base objects are documented.

Key Columns

• SUB_ER_ID — primary identifier of the sub element range record; the ROWID is also exposed as ROW_ID.
• ER_ID — identifier of the parent element record to which the range belongs.
• SUB_RANGE_NUM — sequence or ordinal number of the sub range within its parent.
• SUB_LOWER_RANGE — the lower bound of the range; the column most directly matched by the user's search term.
• SUB_UPPER_RANGE — the upper bound of the range, defining the band together with the lower bound.
• SUB_CHG_METHOD_CODE — the charge method code associated with the range, keyed to the CHG_METHOD lookup type.
• SUB_CHG_METHOD_CODE_DESC — the translated meaning of the charge method code derived from IGS_LOOKUP_VALUES.
• LOGICAL_DELETE_DATE — soft-delete indicator; when populated, the record is logically deleted.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns tracking record creation and modification.

Common Use Cases and Queries

The view is typically used to report on fee range thresholds, to verify charge method assignment by band, and to feed downstream integrations requiring range boundaries. A common diagnostic query retrieves all active ranges for a given element:

• SELECT sub_er_id, er_id, sub_range_num, sub_lower_range, sub_upper_range, sub_chg_method_code_desc FROM igs_fi_sub_elm_rng_v WHERE er_id = :element_id AND logical_delete_date IS NULL ORDER BY sub_range_num;
• To locate a specific threshold: SELECT * FROM igs_fi_sub_elm_rng_v WHERE sub_lower_range = :value;
• To review ranges by charge method: SELECT sub_chg_method_code, sub_lower_range, sub_upper_range FROM igs_fi_sub_elm_rng_v WHERE sub_chg_method_code = :code;

Because the view represents a simple select over its base table, it is safe for read-only reporting. Ensure logical deletes are excluded, and note that the charge method description may be null where no CHG_METHOD lookup value exists.