Results for “ecr_attribute1”

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

Overview

The BEN_ENRT_RT_RBV table is a core configuration object within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite, available in both release 12.1.1 and 12.2.2. The object name follows the standard BEN naming convention, where the "RBV" suffix indicates a Rate/Benefit Value definition. It stores the enrollment rate definitions that govern how benefit costs, coverage amounts, and contribution values are calculated and presented to participants during the enrollment process. Each row represents a defined rate rule that is associated with an enrollment benefit, an eligibility electable choice, and a participation rate value, forming the pricing and value layer of the benefits configuration model.

From a heuristic Data Vault modeling perspective, the metadata classifies this object as standalone. Although it carries numerous foreign key relationships to parent configuration tables, the modeler has classified it as neither a pure hub, link, nor satellite. This reflects its role as a reference/configuration entity that maintains its own rate attributes rather than functioning as a transactional association or a descriptive satellite of a single business key.

Key Information Stored

The table contains 94 documented columns. The unique index BEN_ENRT_RT_RBV_PK is defined on the composite of BENEFIT_ACTION_ID and ENRT_RT_ID. Notably, the business-key candidates are exposed directly through this unique index rather than a single generated surrogate column, meaning the natural identity combines the enrollment rate context with the benefit action driving the rate change.

Among the most significant columns are:

• ENRT_RT_ID — foreign key to BEN_ENRT_RT, identifying the parent enrollment rate.
• BENEFIT_ACTION_ID — foreign key to BEN_BENEFIT_ACTIONS, tying the rate to a lifecycle action.
• ENRT_BNFT_ID and ELIG_PER_ELCTBL_CHC_ID — link the rate to the enrollment benefit and the electable choice it prices.
• RT_TYP_CD and BNFT_RT_TYP_CD — code the rate type and benefit rate type.
• VAL, DFLT_VAL, ANN_VAL, ANN_DFLT_VAL — hold the current, default, annualized, and annualized default rate values.
• MN_ELCN_VAL, MX_ELCN_VAL, INCRMT_ELCN_VAL — define minimum, maximum, and increment election bounds.
• RT_STRT_DT, RT_STRT_DT_CD, RT_STRT_DT_RL — date-effective start conditions for the rate.
• PRTT_RT_VAL_ID — foreign key to BEN_PRTT_RT_VAL for participation rate values.
• COMP_LVL_FCTR_ID, PTD_COMP_LVL_FCTR_ID, CLM_COMP_LVL_FCTR_ID — compensation level factors.
• The ECR_ATTRIBUTE1 through ECR_ATTRIBUTE30 flexfield columns — a Descriptive Flexfield (DFF) segment set for extensibility.
• Standard WHO audit columns (CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE) and OBJECT_VERSION_NUMBER for optimistic locking.

Common Use Cases and Queries

Typical use cases include auditing benefit rate configurations, troubleshooting incorrect premium or coverage amounts, and reporting on rate defaults and election limits by benefit. A representative query joining the rate to its parent enrollment rate and benefit is:

• SELECT rb.ENRT_RT_ID, rb.ENRT_BNFT_ID, rb.RT_TYP_CD, rb.VAL, rb.DFLT_VAL, rb.ANN_VAL
• FROM BEN_ENRT_RT_RBV rb
• WHERE rb.ENRT_RT_ID = :p_enrt_rt_id
• AND rb.BENEFIT_ACTION_ID = :p_action_id;

Analysts frequently trace a rate back to the electable choice: SELECT b.NAME, rb.VAL FROM BEN_ENRT_RT_RBV rb JOIN BEN_ELIG_PER_ELCTBL_CHC c ON c.ELIG_PER_ELCTBL_CHC_ID = rb.ELIG_PER_ELCTBL_CHC_ID. Reporting extracts often filter on RT_STRT_DT to identify effective-dated rate changes.

Related Objects

The following are the most significant related objects, joined through the documented foreign keys:

• BEN_ENRT_RT — parent enrollment rate, via ENRT_RT_ID.
• BEN_ELIG_PER_ELCTBL_CHC — eligibility electable choice, via ELIG_PER_ELCTBL_CHC_ID.
• BEN_ENRT_BNFT — the enrollment benefit, via ENRT_BNFT_ID.
• BEN_COMP_LVL_FCTR — compensation level factor, via COMP_LVL_FCTR_ID.
• BEN_PRTT_RT_VAL — participation rate value, via PRTT_RT_VAL_ID.
• BEN_BENEFIT_ACTIONS — benefit lifecycle action, via BENEFIT_ACTION_ID.
• BEN_PERSON_ACTIONS — person action, via PERSON_ACTION_ID.