Search Results bnft_dflt_flag




Overview
Explore in AI Chat

Overview

The view APPS.BEN_ENRT_RT_PRTT_RT_VAL_V is a seeded database object within the Oracle E-Business Suite Advanced Benefits (BEN) module. It consolidates benefit enrollment rate, participant rate, and rate value information into a single queryable structure. The object carries a status of VALID in the APPS schema and is flagged as "Retrofitted," indicating it was introduced or re-engineered as part of Oracle's ongoing standardization of the Benefits data model rather than as an original 11i-era object.

The view exists primarily to support the Benefits self-service and professional forms layers, where an enrollment's calculated rate, the participant-specific rate override, and the benefit-level default value must all be presented together. Its presence in ETRM reflects its role as a documented, stable interface for reporting and integration. The name itself encodes the join path: ENRT (enrollment) → RT (rate) → PRTT (participant) → RT_VAL (rate value), which signals to developers the grain at which rows are returned.

Underlying Base Objects

The view is defined over three documentation-listed base objects, all referenced as synonyms in the APPS schema:

  • BEN_ENRT_BNFT (alias ENB) — the benefit-level enrollment record, supplying default value, minimum/maximum values, increment value, benefit type, coverage multiple, and default flag.
  • BEN_ENRT_RT (alias ECR) — the enrollment rate record, supplying entry-value flags, display minimum/maximum election values, rate start date, rate multiplier code, activity base rate, and non-monetary unit of measure.
  • BEN_PRTT_RT_VAL (alias PRV) — the participant rate value record, supplying participant-specific overrides including rate value, override flag, override-through date, activity type, and tax type code.

The join predicate begins PRV.PRTT_... = ECR..., linking participant rate values to their originating enrollment rate, and further to the benefit enrollment. Because it is a view rather than a table, it carries no storage of its own; all columns are derived from the concatenation and DECODE/NVL transformation of the base tables.

Key Columns

Common Use Cases and Queries

This view is typically queried to reconcile what a participant actually elected against what was displayed, and to expose rate overrides applied during enrollment. A representative query restricts to a single benefit enrollment:

  • SELECT enrt_rt_id, prtt_rt_val_id, rt_val, cmcd_val, rt_ovridn_flag FROM apps.ben_enrt_rt_prtt_rt_val_v WHERE enrt_bnft_id = :p_bnft_id — retrieves all rate values for a benefit.
  • SELECT rt_val, rt_strt_dt, rt_end_dt FROM apps.ben_enrt_rt_prtt_rt_val_v WHERE prtt_rt_val_id IS NOT NULL AND business_group_id = :p_bg — isolates participant-level overrides only.
  • SELECT enrt_rt_id, mn_elcn_val, mx_elcn_val, ann_mn_elcn_val, ann_mx_elcn_val FROM apps.ben_enrt_rt_prtt_rt_val_v WHERE enrt_val_at_enrt_flag = 'Y' — surfaces display bounds for enrollment-time validation.

Typical scenarios include auditing rate overrides for compliance, populating custom benefits extracts, and supporting conversions where participant rate values must be validated against benefit defaults. Because the view preserves override flags and effective dates, it is suitable for point-in-time reconstructions of an enrollment's cost components.