Search Results ben_cmbn_age_los_rt_f




Overview
Explore in AI Chat

Overview

BEN_CMBN_AGE_LOS_RT_F is a table within the BEN (Advanced Benefits) product module of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. The object resides in the BEN schema and carries a VALID status. Its documented purpose is to store the rate to use for a combination age and length-of-service factor. In functional terms, it holds the rate values that are evaluated against an employee's age combined with length of service, and is therefore central to benefits plan configuration where eligibility, contribution, or coverage amounts vary by both age and tenure simultaneously.

Although no Data Vault classification is explicitly asserted in the source metadata, the heuristic classification mined from the foreign key structure is satellite-leaning. This is a modeling suggestion rather than a normative statement: the table behaves like a satellite because its key is an identifier combined with an effective dating range, and it references a parent factor definition rather than serving as an independent hub or an associative link. The presence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE in the primary key reinforces the temporal, descriptive nature of the row data.

Key Information Stored

The primary key is defined by the index BEN_CMBN_AGE_LOS_RT_F_PK, which spans CMBN_AGE_LOS_RT_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. This composite key establishes the surrogate identifier together with the effective dating window, making each row a dated version of a rate definition. The documented physical schema contains 45 columns; the most significant are summarized below.

Common Use Cases and Queries

Primary usage centers on rate determination during benefits processing and on configuration review and reporting. A typical query resolves the active rate for a given factor as of a date:

  • SELECT cmbn_age_los_rt_id, cmbn_age_los_fctr_id, vRbl_rt_prfl_id, ordr_num FROM ben.ben_cmbn_age_los_rt_f WHERE cmbn_age_los_fctr_id = :p_factor AND :p_as_of BETWEEN effective_start_date AND effective_end_date AND NVL(excld_flag,'N') = 'N';
  • Listing all rate versions for a factor to audit effective-dated history: query the table by CMBN_AGE_LOS_FCTR_ID ordered by EFFECTIVE_START_DATE.
  • Reporting configured rates for a business group by filtering on BUSINESS_GROUP_ID and joining to the factor table for descriptive labels.
  • Extracting descriptive flexfield content via CMR_ATTRIBUTE_CATEGORY and the CMR_ATTRIBUTE1–30 columns for plan-specific customization reporting.

Related Objects

The following objects are the most significant dependents or references based on the documented foreign key and key structure.

  • BEN_CMBN_AGE_LOS_FCTR — parent factor definition; joined on CMBN_AGE_LOS_FCTR_ID. This is the governing parent for every rate row.
  • BEN_CMBN_AGE_LOS_RT_F_PK — the unique index enforcing the composite primary key on CMBN_AGE_LOS_RT_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE; a business-key candidate.
  • VRBL_RT_PRFL (variable rate profile reference) — referenced through VRBL_RT_PRFL_ID for rate profile configuration.
  • Advanced Benefits rate and eligibility processing logic — consumes these effective-dated rate rows when evaluating age-and-service-driven benefits.
  • FND standard WHO/audit consumers — populate and validate LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER.

Collectively, these relationships position BEN_CMBN_AGE_LOS_RT_F as the dated rate detail attached to an age-and-length-of-service factor, best treated in a Data Vault model as a satellite of BEN_CMBN_AGE_LOS_FCTR.