Results for “chg_method”

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

Overview

IGS_FI_SUB_ELM_RNG_V is a financials view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 footprint associated with the Student System / receivables integration objects (the IGS_ prefix denotes the Student Systems product family). The view exposes sub-element range definitions and resolves their associated charge method code to a human-readable meaning. It functions as a reporting and enquiry layer over the IGS_FI_SUB_ELM_RNG base table, presenting denormalized descriptive text that would otherwise require a separate join to the lookup values table. The name itself describes its purpose: "SUB_ELM_RNG" refers to sub-element range, and "_V" confirms it is a view intended for read-only consumption by reports, forms, concurrent programs, and integration extracts. Because the charge method is expressed as a decoded meaning rather than a raw code, the view is well suited to user-facing output such as billing schedules, fee range configuration listings, and reconciliation extracts.

Underlying Base Objects

The view text documented in ETRM references two underlying objects: IGS_FI_SUB_ELM_RNG (aliased SER) and IGS_LOOKUP_VALUES (aliased LV). The primary driving table is IGS_FI_SUB_ELM_RNG, which stores the actual sub-element range records. IGS_LOOKUP_VALUES is joined in an outer fashion using the Oracle (+) outer-join syntax, constrained so that LOOKUP_TYPE equals 'CHG_METHOD'. Because the join is outer, a sub-element range row is retained even when no matching charge method lookup value exists; in that case the MEANING column is null. The ETRM metadata lists no separately documented referenced base objects, and the view inherits the ROWID of the base table record, enabling updatable behavior through the view where the database permits it.

Key Columns

• ROWID — The physical row identifier of the underlying IGS_FI_SUB_ELM_RNG record.
• SUB_ER_ID — Identifier of the sub-element range record.
• ER_ID — Identifier of the parent element range to which the sub-range belongs.
• SUB_RANGE_NUM — Sequencing number for the sub-range within its parent.
• SUB_LOWER_RANGE / SUB_UPPER_RANGE — The lower and upper boundaries defining the numeric or value band of the sub-range.
• SUB_CHG_METHOD_CODE — The charge method code applied to the sub-range; this is the column matched to the lookup type 'CHG_METHOD'.
• MEANING — Decoded description of the charge method, sourced from IGS_LOOKUP_VALUES.
• LOGICAL_DELETE_DATE — Marks the logical deletion (soft delete) of the record; null indicates an active row.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording creation and modification metadata.

Common Use Cases and Queries

The view supports configuration reporting of sub-element ranges with their charge method descriptions, and it is frequently used when validating that the SUB_CHG_METHOD_CODE values in use map to valid 'CHG_METHOD' lookups. A typical query filtering active records and ordering by parent and sequence would be:

SELECT sub_er_id, er_id, sub_range_num, sub_lower_range, sub_upper_range, sub_chg_method_code, meaning FROM apps.igs_fi_sub_elm_rng_v WHERE logical_delete_date IS NULL ORDER BY er_id, sub_range_num;

To isolate the exact code targeted by a user search for "chg_method", a query can restrict on the charge method code or meaning, for example WHERE sub_chg_method_code = :p_code or WHERE meaning = :p_meaning. Because the lookup join is outer, monitoring rows where meaning IS NULL and sub_chg_method_code IS NOT NULL reveals charge method codes that lack a corresponding lookup value, a useful data-integrity check.