Results for “ben_enrt_bnft_rbv”

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

Overview

BEN_ENRT_BNFT_RBV is a table in the BEN schema (Oracle Advanced Benefits) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores benefit enrollment result values at the "RBV" (Rate/Benefit Value) level — the resolved numeric or monetary values that Advanced Benefits derives for a person's enrollment in a benefit, plan, or option after eligibility, rate, and coverage calculation processing has run. Each row represents one benefit value component tied to an enrollment benefit record, carrying default amounts, minimum and maximum bounds, proration flags, and rating-type characteristics. Collectively these rows drive payroll deductions, imputed income, coverage amounts, and cost calculations downstream.

Per the ETRM physical schema for 12.2.2, the table is owned by BEN and contains 66 columns. Its primary key is BEN_ENRT_BNFT_RBV_PK, defined on the composite of BENEFIT_ACTION_ID and ENRT_BNFT_ID. The metadata's heuristic Data Vault classification is standalone, suggesting it be modeled as an independent satellite or reference structure rather than a classic hub or link, since it attaches descriptive and value attributes around the enrollment benefit and benefit action context rather than representing a pure business entity relationship.

Key Information Stored

The most operationally significant columns include the following.

• ENRT_BNFT_ID — Foreign key to BEN_ENRT_BNFT; the parent enrollment benefit row this value belongs to. Part of the unique business key.
• BENEFIT_ACTION_ID — Foreign key to BEN_BENEFIT_ACTIONS; identifies the benefit action (enrollment, change, termination) that produced the value. Part of the unique business key.
• ELIG_PER_ELCTBL_CHC_ID — Foreign key to BEN_ELIG_PER_ELCTBL_CHC; links the value to the specific electable choice for which the person is eligible.
• COMP_LVL_FCTR_ID — Foreign key to BEN_COMP_LVL_FCTR; the compensation-level factor applied when determining the value.
• PERSON_ACTION_ID — Foreign key to BEN_PERSON_ACTIONS; ties the value to the person-level action record.
• VAL, DFLT_VAL, MN_VAL, MX_VAL, INCRMT_VAL — the resolved value, its default, minimum, maximum, and incremental amounts. These carry the actual benefit amount or rate figures.
• NNMNTRY_UOM, RT_TYP_CD, CVG_MLT_CD, BNFT_TYP_CD — units of measure and rate/coverage/benefit type codes qualifying the numeric value.
• CRNTLY_ENRLD_FLAG, DFLT_FLAG, CTFN_RQD_FLAG, VAL_HAS_BN_PRORTD_FLAG, MN_WO_CTFN_FLAG, MX_WO_CTFN_FLAG — status flags indicating whether the person is currently enrolled, whether the value is a default, whether certification is required, and proration/boundary behavior.
• BNDRY_PERD_CD, ORDR_NUM, PRTT_ENRT_RSLT_ID, ENTER_VAL_AT_ENRT_FLAG — boundary period, ordering sequence, proration result linkage, and entry-time flag.
• BENEFIT_ACTION_ID, ENRT_BNFT_ID — the composite that forms the surrogate business key; per ETRM the primary key candidate is the pair (BENEFIT_ACTION_ID, ENRT_BNFT_ID), not a single numeric surrogate.
• Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, REQUEST_ID, PROGRAM_ID, OBJECT_VERSION_NUMBER — for audit and concurrency.
• ENB_ATTRIBUTE1–30 — the descriptive flexfield (DFF) segments.

Common Use Cases and Queries

Typical usage resolves the value that a person receives for a given benefit election, supporting payroll deduction feeds, cost reporting, and reconciliation of calculated versus entered values.

• Retrieving resolved benefit values for an enrollment:

  SELECT r.ENRT_BNFT_ID, r.BENEFIT_ACTION_ID, r.VAL,
         r.MN_VAL, r.MX_VAL, r.DFLT_VAL, r.RT_TYP_CD
    FROM   BEN.BEN_ENRT_BNFT_RBV r
   WHERE  r.ENRT_BNFT_ID = :enrt_bnft_id

• Joining to BEN_ENRT_BNFT and BEN_BENEFIT_ACTIONS to trace the enrollment and action context.
• Identifying values requiring certification or currently enrolled results to filter operational data.
• Reporting defaults versus overridden values using DFLT_FLAG.

Related Objects

• BEN_ENRT_BNFT — parent enrollment benefit; joined on ENRT_BNFT_ID.
• BEN_ELIG_PER_ELCTBL_CHC — electable choice context; joined on ELIG_PER_ELCTBL_CHC_ID.
• BEN_COMP_LVL_FCTR — compensation factor; joined on COMP_LVL_FCTR_ID.
• BEN_BENEFIT_ACTIONS — benefit action; joined on BENEFIT_ACTION_ID.
• BEN_PERSON_ACTIONS — person action; joined on PERSON_ACTION_ID.