Results for “bnft_typ_cd”

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

Overview

BENBV_ENRT_BNFT_V is a read-only view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2, delivered as part of the Oracle Advanced Benefits (BEN) product family. Its purpose is to expose the coverage or benefit provided by the electable choices available to an eligible person as a result of a life event or open enrollment. In practice, each row represents an enrollment benefit line — a valuation or limit associated with a specific electable choice — carrying both the raw coded values and their decoded, user-facing meanings.

The view is a reporting and integration convenience layer. Rather than requiring report authors and interface developers to join BEN_ENRT_BNFT to the BEN lookup views manually, BENBV_ENRT_BNFT_V embeds calls to HR_BIS.BIS_DECODE_LOOKUP so that every coded attribute is presented twice: once as the stored code and once as a translated meaning. It also applies the Business Group security profile through HR_BIS.GET_SEC_PROFILE_BG_ID, ensuring that a query returns only rows for the Business Group to which the session has access. The trailing WITH READ ONLY clause guarantees that no DML can be issued against the view.

Underlying Base Objects

The view is defined over two documented dependencies. The primary source is the synonym BEN_ENRT_BNFT, which resolves to the BEN_ENRT_BNFT base table in the APPS schema. Every non-derived column in the view originates from this table. The second dependency is the HR_BIS package, which supplies two functions: BIS_DECODE_LOOKUP, invoked repeatedly to translate codes against lookups such as BEN_NNMNTRY_UOM, BEN_BNDRY_PERD, BEN_BNFT_TYP, BEN_RT_TYP, BEN_CVG_MLT and YES_NO; and GET_SEC_PROFILE_BG_ID, invoked in the WHERE predicate to restrict output by the operator's Business Group security profile. The join is a simple single-table projection — no other BEN HR or PAY tables are joined, so referential enrichment beyond lookup decoding must be performed by the consumer.

Key Columns

Columns fall into several logical groups. Monetary and valuation attributes include VAL, NNMNTRY_UOM (and its decoded companion NNMNTRY_UOM_M), MN_VAL, MX_VAL, INCRMT_VAL, DFLT_VAL and MX_WOUT_CTFN_VAL, describing the value, unit of measure, minimum, maximum, increment, default and maximum-without-certification amounts for the enrollment benefit.

Descriptive flexfield support is provided by the literal column alias "_DF:ENB", which signals the BEN_ENRT_BNFT descriptive flexfield context to Oracle Forms and OAF-based consumers. Coded attributes include BNDRY_PERD_CD, BNFT_TYP_CD, RT_TYP_CD and CVG_MLT_CD, each paired with a decoded equivalent. Flag columns — DFLT_FLAG, VAL_HAS_BN_PRORTD_FLAG, CTFN_RQD_FLAG, CRNTLY_ENRLD_FLAG, ENTR_VAL_AT_ENRT_FLAG and MX_WO_CTFN_FLAG — each carry a YES_NO decoded counterpart.

The column CRNTLY_ENRLD_FLAG is the attribute most commonly sought by users searching for "crntly_enrld_flag". It indicates whether the person is currently enrolled in the benefit represented by the row, and is exposed alongside its decoded meaning via BIS_DECODE_LOOKUP('YES_NO', ENB.CRNTLY_ENRLD_FLAG). Identifier columns include ENRT_BNFT_ID, BUSINESS_GROUP_ID, ELIG_PER_ELCTBL_CHC_ID, COMP_LVL_FCTR_ID, PRTT_ENRT_RSLT_ID and the concurrent request context columns REQUEST_ID, PROGRAM_APPLICATION_ID and PROGRAM_ID. Standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) complete the projection.

Common Use Cases and Queries

Typical uses include enrollment audits, benefits reconciliation extracts, open-enrollment reporting and integration feeds into downstream payroll or carrier systems. The decoded columns remove the need for the caller to join lookup tables.

To list currently enrolled benefit lines for a participant:

• SELECT enrt_bnft_id, elig_per_elctbl_chc_id, bnft_typ_cd_m, cvg_mlt_cd_m, crntly_enrld_flag_m FROM apps.benbv_enrt_bnft_v WHERE crntly_enrld_flag = 'Y';
• SELECT enrt_bnft_id, dflt_val, mn_val, mx_val, incrmt_val FROM apps.benbv_enrt_benft_v WHERE bnft_typ_cd = 'HLTH' ORDER BY ordr_num;
• SELECT elig_per_elctbl_chc_id, val, nnmntry_uom_m FROM apps.benbv_enrt_bnft_v WHERE cvg_mlt_cd_m IS NOT NULL;

Because Business Group filtering is automatic, no explicit predicate on BUSINESS_GROUP_ID is required for a normal session. Consumers needing underlying identifiers for further joins should select ENRT_BNFT_ID or ELIG_PER_ELCTBL_CHC_ID and link to BEN_ENRT_BNFT or the electable choice tables directly.