Results for “ben_enrt_prem_rbv”

50+ results




Overview
Explore in AI Chat

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

Overview

BEN_ENRT_PREM_RBV is a table in the BEN (Advanced Benefits) product module of Oracle E-Business Suite, owned by the BEN schema and documented as VALID in both EBS 12.1.1 and 12.2.2. The "RBV" suffix conventionally indicates a run-time or retrieval-only backing view table used by Oracle Advanced Benefits to persist enrollment premium results. The object stores the premium amounts, values, and units of measure associated with a person's enrollment in a benefit plan or option, keyed by the enrollment premium record and the benefit action that produced it. The table carries 50 documented columns, an unusually wide structure driven largely by 30 generic EPR_ATTRIBUTE descriptive flexfield columns, plus standard WHO audit columns and concurrent program tracking columns.

From a Data Vault modeling perspective, the supplied metadata classifies this table heuristically as standalone, meaning it does not act as a pure hub or link in a normalized vault sense, but its foreign keys to BEN_ENRT_PREM, BEN_ENRT_BNFT, BEN_ELIG_PER_ELCTBL_CHC, BEN_BENEFIT_ACTIONS, and BEN_PERSON_ACTIONS give it clear link-like characteristics tied to transactional enrollment events. It may therefore be modeled as a link or satellite depending on the integration pattern chosen.

Key Information Stored

The table's surrogate primary key is defined by the unique index BEN_ENRT_PREM_RBV_PK, composed of the columns BENEFIT_ACTION_ID and ENRT_PREM_ID. These two columns together form the business-key candidate that uniquely identifies each row.

  • ENRT_PREM_ID – Foreign key to BEN_ENRT_PREM; identifies the source enrollment premium record that this run-time row derives from.
  • ACTL_PREM_ID – Identifies the actual premium amount record associated with the computed premium.
  • BUSINESS_GROUP_ID – Multi-tenant / business group discriminator for the row.
  • BENEFIT_ACTION_ID – Foreign key to BEN_BENEFIT_ACTIONS; the benefits action that generated the premium result.
  • PERSON_ACTION_ID – Foreign key to BEN_PERSON_ACTIONS; links the premium to the person-level action performed during the enrollment lifecycle.
  • ENRT_BNFT_ID – Foreign key to BEN_ENRT_BNFT; ties the premium to the person's enrollment in a specific benefit.
  • ELIG_PER_ELCTBL_CHC_ID – Foreign key to BEN_ELIG_PER_ELCTBL_CHC; identifies the eligibility/electable choice whose premium is being recorded.
  • VAL – The computed premium value stored for the enrollment.
  • UOM – Unit of measure for the premium value (for example, a currency or a period-based unit).
  • OBJECT_VERSION_NUMBER – Optimistic locking column used by the applications layer to detect concurrent updates.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE – Standard WHO audit columns recording row creation and last modification.
  • REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE – Concurrent program context columns identifying the request and program that populated or last updated the row.
  • EPR_ATTRIBUTE_CATEGORY and EPR_ATTRIBUTE1 … EPR_ATTRIBUTE30 – Descriptive flexfield segments that flexibly capture customer-specific premium attributes beyond the seeded columns.

Common Use Cases and Queries

Typical usage centers on reporting and reconciliation of premium amounts produced during benefits enrollment processing. Analysts commonly join to BEN_ENRT_PREM and BEN_ENRT_BNFT to compare source and run-time premium values, or to BEN_BENEFIT_ACTIONS to trace which action generated a result.

A sample query joining on the FK relationships:

  • SELECT r.ENRT_PREM_ID, r.ENRT_BNFT_ID, r.ELIG_PER_ELCTBL_CHC_ID, r.VAL, r.UOM FROM BEN.BEN_ENRT_PREM_RBV r WHERE r.BUSINESS_GROUP_ID = :p_bg_id AND r.BENEFIT_ACTION_ID = :p_action_id;
  • Reconciliation of run-time values to source premiums: join BEN_ENRT_PREM_RBV to BEN_ENRT_PREM on ENRT_PREM_ID to isolate discrepancies between stored and computed amounts.
  • Audit/trace reports joining to BEN_PERSON_ACTIONS and BEN_BENEFIT_ACTIONS via PERSON_ACTION_ID and BENEFIT_ACTION_ID to establish the timing and actor of each premium computation.
  • Descriptive flexfield extraction using EPR_ATTRIBUTE_CATEGORY and EPR_ATTRIBUTE1 through EPR_ATTRIBUTE30 for customer-specific premium analysis.

Related Objects

The following documented foreign key relationships define the most significant dependent and referenced objects:

  • BEN_ENRT_PREM – Referenced via ENRT_PREM_ID; the primary source premium definition for each row.
  • BEN_ENRT_BNFT – Referenced via ENRT_BNFT_ID; the underlying benefit enrollment to which the premium belongs.
  • BEN_ELIG_PER_ELCTBL_CHC – Referenced via ELIG_PER_ELCTBL_CHC_ID; identifies the electable choice governing the premium.
  • BEN_BENEFIT_ACTIONS – Referenced via BENEFIT_ACTION_ID; part of the unique key and provides the action context for the computation.
  • BEN_PERSON_ACTIONS – Referenced via PERSON_ACTION_ID; links the premium to the person-level action history.

Together these referenced tables form the transactional backbone of the Advanced Benefits enrollment flow, while BEN_ENRT_PREM_RBV serves as the run-time premium result store that supports compensation, payroll interface, and benefits reconciliation reporting.