Results for “ben_bnft_rt_typ”

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

Overview

APPS.BENBV_ENRT_RT_V is a reporting and integration view in the Oracle EBS Advanced Benefits (BEN) module. It presents benefit enrollment rate records — the individual rate rows attached to a person's benefit enrollment — in a denormalized, display-ready form. The view exposes the rate table structure of BEN_ENRT_RT together with decoded lookup values, so that consumers do not have to resolve lookup codes themselves.

The view is particularly relevant to the search term ben_rt_usg: the RT_USG_CD column (rate usage code) is exposed in the view, and the view also supplies the decoded description via HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_USG', ECR.RT_USG_CD). This makes BENBV_ENRT_RT_V the natural object for queries that need to report or filter enrollment rates by rate usage — for example, distinguishing rates used for calculation versus display.

Underlying Base Objects

The documented metadata identifies two referenced objects: the synonym BEN_ENRT_RT and the package HR_BIS.

• BEN_ENRT_RT — the base enrollment rate table. Every column in the view is drawn from this table using the alias ECR. The view is therefore a one-to-many projection: one row per enrollment rate record, linked back to the enrollment by ENRT_RT_ID.
• HR_BIS — a decoding package. It is invoked repeatedly through BIS_DECODE_LOOKUP(lookup_type, lookup_code) to translate stored codes into their lookup meanings. This is what gives the view its "BV" (business view) character: the stored code and its decoded meaning are returned side by side.

The view also carries a descriptive flexfield reference ('_DF:BEN:BEN_ENRT_RT:ECR') and the identifier column ENRT_RT_ID in the id column block, confirming it is intended for use by the BEN business view layer rather than as a standalone table.

Key Columns

• RT_USG_CD and its decoded form from BEN_RT_USG — the rate usage code, the primary subject of the "ben_rt_usg" search.
• ACTY_TYP_CD (BEN_ACTY_TYP), TX_TYP_CD (BEN_TX_TYP), RT_TYP_CD (BEN_RT_TYP), BNFT_RT_TYP_CD, RT_MLT_CD — activity, taxation, rate type, benefit rate type, and multiplier codes, each paired with a decoded value.
• RT_STRT_DT, RT_STRT_DT_RL, RT_STRT_DT_CD — the rate start date, its rule, and the decoded rule for when the rate begins.
• VAL, DFLT_VAL, ANN_VAL, ANN_DFLT_VAL, MN_ELCN_VAL, MX_ELCN_VAL — the actual rate value and its default, annualized, minimum and maximum election equivalents.
• NNMNTRY_UOM — the non-monetary unit of measure, decoded through BEN_NNMNTRY_UOM.
• CMCD_VAL, CMCD_DFLT_VAL, CMCD_MN_ELCN_VAL, CMCD_MX_ELCN_VAL, CMCD_ACTY_REF_PERD_CD — communicated (calculated) values and their reference period.
• Numerous YES_NO flags — CTFN_RQD_FLAG, DFLT_FLAG, DFLT_PNDG_CTFN_FLAG, DSPLY_ON_ENRT_FLAG, USE_TO_CALC_NET_FLX_CR_FLAG, ENTR_VAL_AT_ENRT_FLAG, ASN_ON_ENRT_FLAG, RL_CRS_ONLY_FLAG, ENTR_ANN_VAL_FLAG — controlling how the rate behaves during enrollment.
• INCRMT_ELCN_VAL, DSPLY_MN_ELCN_VAL, DSPLY_MX_ELCN_VAL, ISS_VAL, PP_IN_YR_USED_NUM, ORDR_NUM, VAL_LAST_UPD_DATE, PROGRAM_UPDATE_DATE — increment, display bounds, pay periods in year, ordering, and date-stamp attributes.

Common Use Cases and Queries

Typical uses include auditing rate usage assignments on enrollments, validating that rate usage codes are consistent across plans, and building extracts that require both the code and its meaning.

To list enrollment rates grouped by rate usage:

• SELECT RT_USG_CD, COUNT(*) FROM APPS.BENBV_ENRT_RT_V GROUP BY RT_USG_CD;

To isolate rates whose usage is a specific type, filtering on the stored code is more reliable than filtering on the decoded text:

• SELECT ENRT_RT_ID, RT_USG_CD, VAL, ANN_VAL, RT_STRT_DT FROM APPS.BENBV_ENRT_RT_V WHERE RT_USG_CD = :p_usage;

Because the view already returns decoded values and flags, it is suitable for direct use in BI Publisher reports and concurrent program extracts without an additional lookup join on BEN_RT_USG.