Results for “ben_vrbl_rt_rl_f”

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

Overview

BEN_VRBL_RT_RL_F is the Advanced Benefits (BEN) table that stores variable rate rule definitions. It holds the configuration metadata that governs how a variable rate is derived or calculated for a benefit offering, driving rate determination logic used by the Oracle Advanced Benefits rating and enrollment engine.

In the Oracle E-Business Suite RDBMS (12.1.1 / 12.2.2), the table resides in the BEN schema and is exposed as a non-key flexfield (DFF-extended) entity, as evidenced by the 30 VRR_ATTRIBUTE columns. The VRBL_RT_RL_ID column identified in the user search corresponds to the first component of the composite primary key, BEN_VRBL_RT_RL_F_PK, and is the single-column surrogate identifier most commonly referenced in joins and lookups.

From a Data Vault modeling perspective, the metadata classifies this object as standalone, with a heuristic suggestion of a satellite around the variable rate rule business key. The composite primary key (VRBL_RT_RL_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) reflects Oracle’s standard date-effective (datetrack) pattern, making the table an effective-dated satellite rather than a pure hub or link.

Key Information Stored

The table comprises 46 documented columns across three functional groups. The most significant are:

• VRBL_RT_RL_ID — surrogate primary key and the primary business identifier for the variable rate rule; the value returned when users search for vrbl_rt_rl_id.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the datetrack columns completing the composite primary key. Note that in the physical table, EFFECTIVE_END_DATE carries a high-date sentinel (4712-12-31) for the current row.
• FORMULA_ID — foreign key to the formula (FF_FORMULAS_F) that supplies the calculation logic executed at rating time.
• ACTY_BASE_RT_ID — the activity base rate identifier linking this rule to the activity rate setup in BEN.
• RT_TRTMT_CD — rate treatment code, controlling how the computed rate is applied to the benefit calculation.
• ORDR_TO_APLY_NUM — sequence number determining the order in which multiple variable rate rules are applied.
• DRVBL_FCTR_APLS_FLAG — flag indicating whether derivable factors apply to this rate rule.
• BUSINESS_GROUP_ID — the HR business group (operating unit) that owns the configuration row.
• OBJECT_VERSION_NUMBER — concurrency control column used by the PL/SQL and OAF APIs.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns.
• VRR_ATTRIBUTE_CATEGORY plus VRR_ATTRIBUTE1 through VRR_ATTRIBUTE30 — the descriptive flexfield segment block, a critical extension point for client-specific rate rule attributes.

The surrogate key should not be confused with the natural composite key; uniqueness is enforced only by the combination of VRBL_RT_RL_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE.

Common Use Cases and Queries

Typical applications include generating benefit rate audit reports, troubleshooting enrollment rate calculations, migrating rate rule configurations across instances, and integrating with external payroll or carrier systems. A standard pattern for retrieving the current effective rule is:

• SELECT vrbl_rt_rl_id, formula_id, rt_trtmt_cd, ordr_to_aply_num FROM ben.ben_vrbl_rt_rl_f WHERE vrbl_rt_rl_id = :p_id AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
• Filtering on business_group_id to scope reporting to a single legal employer.
• Extracting DFF segments (VRR_ATTRIBUTE1–30) where clients have stored custom rate drivers.
• Joining to FF_FORMULAS_F on formula_id to decode the calculation associated with each variable rate rule.

Related Objects

• BEN_ACTY_BASE_RT_F — parent activity base rate setup; joined via ACTY_BASE_RT_ID.
• FF_FORMULAS_F — formula library; joined via FORMULA_ID.
• FND_FORMULA_COMPILED / FF_FORMULA_FUNCTIONS — formula compilation artifacts that resolve the rule logic at runtime.
• PER_BUSINESS_GROUPS — HR business group definition; joined via BUSINESS_GROUP_ID.
• BEN_VRBL_RT_RL_F_PK — the primary key constraint enforcing the composite uniqueness.
• FND_DF_FLEX_USAGES / FND_DESCR_FLEX_COL_USAGE — flexfield definition metadata for the VRR_ATTRIBUTE segment block.
• BEN_VRBL_RT_RL_B / _TL — where a translation-enabled variant exists, though this table is documented as physical-only with no separate base view.