Results for “benbv_enrt_rt_v”

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

Overview

BENBV_ENRT_RT_V is a seeded, read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the BEN (Advanced Benefits) product family. The view identifies the rates calculated for a person for a plan or option in plan, and additionally exposes flexible credit values and imputed income values. In practice, this makes BENBV_ENRT_RT_V the primary reporting surface for everything the Benefits engine derives or stores as a monetary or numeric value on a person's enrollment: the elected rate amount, the default value, annualized amounts, minimum and maximum election limits, computed (CMCD) values, and the numerous control flags that govern how each rate behaves during enrollment.

The view is exposed as APPS.BENBV_ENRT_RT_V and is the "BV" (business view) presentation layer over the underlying BEN_ENRT_RT entity. Its role in EBS reporting and integration is to provide a decoded, reporting-friendly representation of enrollment rate data: coded lookup values such as activity type, transaction type, rate type, rate usage, and benefit rate type are joined via HR_BIS.BIS_DECODE_LOOKUP so consumers receive meaningful display values rather than internal codes. Because it carries effective-date columns (RT_STRT_DT, RT_STRT_DT_RL) and a program update timestamp, the view supports both point-in-time and change-tracking style reporting.

Underlying Base Objects

According to the documented view metadata for 12.2.2, BENBV_ENRT_RT_V is defined over two referenced objects:

• BEN_ENRT_RT (SYNONYM) — the enrollment rate entity. The view text selects directly from this object, aliased in the definition as ECR (for example, ECR.RT_STRT_DT, ECR.DFLT_VAL, ECR.VAL). The synonym resolves to the APPS.BEN_ENRT_RT base table, which stores one row per enrollment rate record tied to a person, plan, and option in plan.
• HR_BIS (PACKAGE) — the Benefits decode utility package. The view calls HR_BIS.BIS_DECODE_LOOKUP once per coded column, passing a lookup type (such as 'BEN_NNMNTRY_UOM', 'BEN_ACTY_TYP', 'BEN_TX_TYP', 'BEN_RT_STRT', 'BEN_RT_TYP', 'BEN_ENRT_INFO_RT_FREQ', 'BEN_RT_USG', 'BEN_BNFT_RT_TYP', 'BEN_MLT', and 'YES_NO') and the stored code, returning the decoded display value.

The relationship is therefore a straightforward one-to-many read: each row of BEN_ENRT_RT produces one row in BENBV_ENRT_RT_V, with its code columns translated through HR_BIS lookups at query time. The view does not persist data and should never be used as a DML target.

Key Columns

• RT_STRT_DT / RT_STRT_DT_RL / RT_STRT_DT_CD — effective date of the rate, its related/rollback date, and the decoded rule controlling when the rate starts.
• VAL, DFLT_VAL, ANN_VAL, ANN_DFLT_VAL — the calculated rate value, its default, and the annualized equivalents of both.
• MN_ELCN_VAL, MX_ELCN_VAL, INCRMT_ELCN_VAL, ANN_MN_ELCN_VAL, ANN_MX_ELCN_VAL, DSPLY_MN_ELCN_VAL, DSPLY_MX_ELCN_VAL — election minimums, maximums, increment amounts, their annualized forms, and the display variants shown to the user.
• CMCD_VAL, CMCD_DFLT_VAL, CMCD_MN_ELCN_VAL, CMCD_MX_ELCN_VAL, CMCD_ACTY_REF_PERD_CD — computed values and the activity reference period that drives them (for example, per-pay-period flexible credits).
• DFLT_PNDG_CTFN_FLAG — the flag the user searched on. It indicates whether a defaulted rate is left in a pending confirmation state, requiring participant confirmation before it becomes effective. It is decoded via HR_BIS.BIS_DECODE_LOOKUP('YES_NO', ...).
• CTFN_RQD_FLAG — whether confirmation of the rate is required at all.
• DFLT_FLAG, DSPLY_ON_ENRT_FLAG, ENTR_VAL_AT_ENRT_FLAG, ASN_ON_ENRT_FLAG, USE_TO_CALC_NET_FLX_CR_FLAG — control flags governing defaulting, display on the enrollment page, entry at enrollment, assignment at enrollment, and use in net flexible credit calculation.
• NNMNTRY_UOM, RT_USG_CD, RT_TYP_CD, BNFT_RT_TYP_CD, RT_MLT_CD, ACTY_TYP_CD, TX_TYP_CD, ORDR_NUM, PP_IN_YR_USED_NUM, ISS_VAL, VAL_LAST_UPD_DATE, PROGRAM_UPDATE_DATE — unit of measure, usage/type indicators, ordering, periods-per-year, issued-value metadata, and audit timestamps.
• Descriptive flexfield — the literal marker '_DF:BEN:BEN_ENRT_RT:ECR' exposes the enrollment rate DFF, allowing attribute columns to be surfaced by the form/report consumer.

Common Use Cases and Queries

Typical uses include auditing defaulted rates that require confirmation, reconciling calculated versus default values for a plan, and reporting flexible credit or imputed income amounts. The following query lists rates for a person where a default has been placed in pending-confirmation status:

• SELECT rt_strt_dt, dflt_val, val, dflt_pndg_ctfn_flag, rt_usg_cd, rt_typ_cd FROM apps.benbv_enrt_rt_v WHERE dflt_pndg_ctfn_flag = 'Y';
• SELECT person_id, plan_id, rt_strt_dt, ann_val, cmcd_val, use_to_calc_net_flx_cr_flag FROM apps.benbv_enrt_rt_v WHERE rt_strt_dt BETWEEN :p_start AND :p_end ORDER BY person_id, rt_strt_dt;

Because the coded columns are decoded by HR_BIS at runtime, queries that filter on the flag columns are best written using the stored code (for example, 'Y'/'N') rather than the decoded display text, which may be subject to lookup customization. When joining to person or plan descriptive data, join on the identifying keys carried through from BEN_ENRT_RT rather than on the decoded columns, and restrict by effective date using RT_STRT_DT to obtain point-in-time results.