Results for “ben_rt_typ”

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

Overview

APPS.BENBV_PRTT_RT_VAL_V is a read-only Oracle EBS view that exposes participant rate value records held in the Benefits (BEN) module. It presents a flattened, decoded projection of the BEN_PRTT_RT_VAL entity, which stores the individual rate, amount, or coverage values calculated for a participant's enrollment in a plan or option. The view is one of the BENBV ("Benefits Business View") family of objects used by Oracle Advanced Benefits and related reporting layers to surface benefit configuration and enrollment data in a consistent, business-friendly form.

Because the view is defined WITH READ ONLY and filters on BUSINESS_GROUP_ID through HR_BIS.GET_SEC_PROFILE_BG_ID, it enforces the caller's security profile at the business group level. This makes it suitable for concurrent programs, Oracle Discoverer/OBIEE extracts, and integration interfaces that must respect operating unit/business group separation without writing their own predicate logic.

Underlying Base Objects

The view is defined over a single base object, BEN_PRTT_RT_VAL, accessed via a synonym (ETRM lists BEN_PRTT_RT_VAL as a SYNONYM). The second referenced object is the HR_BIS database package, whose BIS_DECODE_LOOKUP function converts stored lookup codes into user-facing lookup meanings.

The distinguishing characteristic of this view is that for every coded column it returns both the raw code stored in BEN_PRTT_RT_VAL and a decoded value obtained via HR_BIS.BIS_DECODE_LOOKUP. It also appends a descriptive flexfield reference column ('_DF:BEN:BEN_PRTT_RT_VAL:PRV') that tells the BEN flexfield framework which DFF context applies to the row.

Key Columns

• Rate value columns: RT_VAL, ANN_RT_VAL (annualized), and CMCD_RT_VAL (communicated rate) hold the numeric rate; RT_STRT_DT, RT_END_DT, and RT_OVRIDN_THRU_DT bound its effective period.
• RT_TYP_CD / BNFT_RT_TYP_CD: The rate type code, decoded against the BEN_RT_TYP lookup. This is the column most relevant to a search for "ben_rt_typ", since the lookup BEN_RT_TYP defines the allowed rate type values (for example fixed, variable, or calculated rates).
• PRTT_RT_VAL_STAT_CD: Status of the participant rate value, decoded against BEN_PRTT_ENRT_RSLT_STAT.
• TX_TYP_CD, ACTY_TYP_CD, MLT_CD: Tax type, activity type, and multiplier codes, each paired with a decoded value.
• ACTY_REF_PERD_CD / CMCD_REF_PERD_CD: Activity reference period and rate frequency, the latter decoded against BEN_ENRT_INFO_RT_FREQ.
• DSPLY_ON_ENRT_FLAG / RT_OVRIDN_FLAG: Yes/No flags controlling display during enrollment and indicating whether the rate was overridden.
• Identifier columns: PRTT_RT_VAL_ID, PRTT_ENRT_RSLT_ID, ELEMENT_ENTRY_VALUE_ID, PK_ID, PK_ID_TABLE_NAME, and BUSINESS_GROUP_ID establish the join keys to enrollment results, payroll element entries, and flexfield rows.
• WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

A typical use case is auditing which rate type applies to a participant's calculated rates, or producing a listing of enrollment rate values for a business group.

SELECT prtt_rt_val_id,
       prtt_enrt_rslt_id,
       rt_typ_cd,
       rt_typ_cd_meaning,
       rt_val,
       ann_rt_val,
       rt_strt_dt,
       rt_end_dt
FROM   apps.benbv_prtt_rt_val_v
WHERE  rt_typ_cd = '&rate_type'
ORDER  BY prtt_enrt_rslt_id, rt_strt_dt;

A second scenario reconciles communicated rates against annualized values and override flags for a given enrollment result:

SELECT prtt_enrt_rslt_id,
       cmcd_rt_val,
       ann_rt_val,
       cmcd_ref_perd_cd_meaning,
       rt_ovridn_flag_meaning
FROM   apps.benbv_prtt_rt_val_v
WHERE  prtt_enrt_rslt_id = :p_enrt_rslt_id
AND    rt_end_dt IS NULL;

Because the view is read-only and security-filtered, it is well suited for reporting and extraction rather than for DML. When coded lookups such as BEN_RT_TYP are customized, the decoded meaning columns reflect the current lookup values, so reports should always reference the *_meaning columns rather than hard-coded code lists.