Results for “igs_fi_elm_range_rt_u1”

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

Overview

IGS.IGS_FI_ELM_RANGE_RT is a transaction-level table in the Oracle EBS Student Systems (IGS) schema that stores charge rates specific to a range of charge elements. In the Oracle E-Business Suite 12.1.1 and 12.2.2 footprint, it belongs to the fee assessment and charge calculation subsystem: it holds the rate definitions that the fee assessment routines consume when determining how much to charge an enrolled student. Each row represents a rate record tied to a fee type, a fee calendar instance, a system relation type, and an element range number. Rows are never physically removed; instead they carry a logical delete timestamp, giving the table a temporal, history-preserving character.

From a Data Vault modelling perspective, the documented structure suggests a satellite-leaning classification. The table is keyed by a single system-generated surrogate (ERR_ID) and carries descriptive attributes such as rates, fee categories, and audit columns that change over time, rather than serving as a pure hub of unique business keys or a link between two hubs. The presence of LOGICAL_DELETE_DT and the standard WHO/audit columns reinforces this interpretation.

Key Information Stored

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

• ERR_ID — the system-generated element range rate identifier and the primary key (IGS_FI_ELM_RANGE_RT_PK) and unique index (IGS_FI_ELM_RANGE_RT_U1). This surrogate key is the sole documented business-key candidate.
• FEE_TYPE — the fee type used to apply fees and charges (for example, contribution or guild). This value is also a foreign key into IGS_FI_FEE_AS_RATE.
• FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER — the fee calendar type and the sequence number uniquely identifying the calendar instance.
• S_RELATION_TYPE — the system relation type to which the element range belongs.
• RANGE_NUMBER — uniquely identifies the element range rate record.
• RATE_NUMBER — the fee assessment or charge rate that the assessment routine evaluates together with the charge method and number of charge elements.
• FEE_CAT — the fee category identifying the distinct fee assessment group assigned the fee type liability.
• CREATE_DT and LOGICAL_DELETE_DT — creation and logical deletion timestamps.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical usage centres on fee assessment validation and reconciliation. The non-unique indexes IGS_FI_ELM_RANGE_RT_N1 (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, S_RELATION_TYPE, RATE_NUMBER, FEE_CAT) and IGS_FI_ELM_RANGE_RT_N2 (same leading columns, RANGE_NUMBER, FEE_CAT) reveal the dominant access paths: joins to fee assessment rates and lookups by calendar instance and relation type.

A representative query resolves active rates for a fee type and calendar instance:

• SELECT err_id, fee_type, fee_cal_type, fee_ci_sequence_number, s_relation_type, range_number, rate_number, fee_cat
• FROM igs.igs_fi_elm_range_rt
• WHERE fee_type = :p_fee_type
• AND fee_cal_type = :p_cal_type
• AND fee_ci_sequence_number = :p_seq
• AND logical_delete_dt IS NULL
• ORDER BY range_number, rate_number;

Reporting scenarios include rate-range audits, detection of superseded rates by comparing CREATE_DT against LOGICAL_DELETE_DT, and reconciliation of assessment output against the stored RATE_NUMBER for a given FEE_CAT. Because deletion is logical, all queries intended to reflect the current state must filter on LOGICAL_DELETE_DT IS NULL.

Related Objects

The documented foreign key links FEE_TYPE to IGS_FI_FEE_AS_RATE, the principal reference point for fee assessment rates. Beyond that relationship, the table integrates with the wider IGS fee and calendar model:

• IGS.IGS_FI_FEE_AS_RATE — joined on FEE_TYPE; the parent definition of assessment rates.
• IGS.IGS_FI_FEE_CALENDAR — supplies the calendar type and instance identified by FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER.
• IGS.IGS_FI_FEE_CAT — defines the fee categories referenced by FEE_CAT.
• IGS.IGS_FI_FEE_TYPE — defines the system-wide fee types referenced by FEE_TYPE.
• IGS.IGS_FI_S_RELATION_TYPE — defines the system relation types referenced by S_RELATION_TYPE.
• IGS.IGS_FI_ELM_RANGE — the element range header with which RANGE_NUMBER associates.
• FND audit objects — FND_USER and FND_CONCURRENT_PROGRAM, joined on the CREATED_BY, LAST_UPDATED_BY, PROGRAM_ID, and REQUEST_ID columns for lineage reporting.