Results for “ben_prtt_rt_val_rbv”

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

Overview

BEN.BEN_PRTT_RT_VAL_RBV is a table within the Advanced Benefits (BEN) product module of Oracle E-Business Suite, documented as VALID in both the 12.1.1 and 12.2.2 releases. In the Advanced Benefits architecture, the suffix _RBV conventionally denotes a "rate/benefit value" record generated during benefits processing — specifically, participant rate values produced by the rate and coverage calculation engine. This table therefore represents the persistent result of applying coverage calculation methods, activity base rates, and compensation level factors to a participant's benefit election or enrollment result. It serves as a backing store for calculated rates, premiums, and reimbursement values that populate enrollment results and feed subsequent payroll or billing processes.

From a dimensional modeling perspective, the supplied metadata classifies this object heuristically as standalone with respect to the Data Vault structure mined from its foreign key topology. Although the table carries several foreign keys (notably PRTT_RT_VAL_ID, COMP_LVL_FCTR_ID, PER_IN_LER_ID, BENEFIT_ACTION_ID, and PERSON_ACTION_ID), the heuristic treats it as a standalone entity rather than a strict hub, link, or satellite. Where a Data Vault treatment is desired, it may reasonably be modeled as a satellite keyed to participant rate-value and activity identifiers, since it holds descriptive, time-stamped attributes rather than pure linking associations.

Key Information Stored

The documented physical schema spans 68 columns. The most operationally significant include the following:

• PRTT_RT_VAL_ID — the surrogate identifier for the participant rate value record; combined with BENEFIT_ACTION_ID it forms the primary key candidate.
• RT_STRT_DT / RT_END_DT — the effective-date range for which the rate value is applicable.
• RT_VAL, ANN_RT_VAL, CMCD_RT_VAL — the calculated rate, annualized rate, and compensation-based rate values respectively.
• RT_TYP_CD, TX_TYP_CD, ACTY_TYP_CD, MLT_CD, ACTY_REF_PERD_CD, CMCD_REF_PERD_CD — rate type, transaction type, activity type, multiplier, and reference-period codes governing calculation.
• BNFT_RT_TYP_CD — the benefit rate type classification.
• PRTT_ENRT_RSLT_ID, ELEMENT_ENTRY_VALUE_ID — links to the enrollment result and payroll element entry value that consume the calculated rate.
• PRTT_RT_VAL_STAT_CD — status of the rate value (e.g., active, overridden).
• BUSINESS_GROUP_ID — the HR business group context for multi-tenant segregation.

The unique index BEN_PRTT_RT_VAL_RBV_PK (BENEFIT_ACTION_ID, PRTT_RT_VAL_ID) establishes the business key candidate, distinguishing it from the surrogate PRTT_RT_VAL_ID alone. Audit columns (LAST_UPDATE_DATE, CREATED_BY, OBJECT_VERSION_NUMBER) and the 30 PRV_ATTRIBUTE descriptive flexfield columns are present for extensibility.

Common Use Cases and Queries

Typical scenarios involve auditing calculated rates for a benefit action, reconciling rates against premiums, or reporting participant coverage costs. A representative query joins the rate table to the participant-in-life-event table:

• Rate reconciliation:
  SELECT r.PRTT_RT_VAL_ID, r.RT_VAL, r.ANN_RT_VAL, r.RT_STRT_DT, r.RT_END_DT
FROM BEN_PRTT_RT_VAL_RBV r
WHERE r.BENEFIT_ACTION_ID = :benefit_action_id;
• Overridden rate audit: filter on RT_OVRIDN_FLAG and RT_OVRIDN_THRU_DT to identify manual overrides.
• Compensation-based rate analysis joining COMP_LVL_FCTR_ID to BEN_COMP_LVL_FCTR.
• Enrollment-result reporting linking PRTT_ENRT_RSLT_ID back to the participant enrollment result.

Related Objects

The FK topology identifies the principal related objects:

• BEN_PRTT_RT_VAL — parent rate-value definition, joined via PRTT_RT_VAL_ID.
• BEN_COMP_LVL_FCTR — compensation level factor, joined via COMP_LVL_FCTR_ID.
• BEN_PER_IN_LER — participant life-event record, joined via PER_IN_LER_ID and ENDED_PER_IN_LER_ID.
• BEN_BENEFIT_ACTIONS — the benefit action driving processing, joined via BENEFIT_ACTION_ID.
• BEN_PERSON_ACTIONS — the person-level action, joined via PERSON_ACTION_ID.

These joins support enrollment lifecycle reporting, rate verification, and payroll or billing feed extraction within the Advanced Benefits module.