Results for “benbv_enrt_perd_for_pl_v”

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

Overview

The view APPS.BENBV_ENRT_PERD_FOR_PL_V is a business view (indicated by the BENBV prefix and the _V suffix) delivered with Oracle Advanced Benefits (BEN) in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to identify the plans in program for which an enrollment period has been defined. The view is important because enrollment periods in Advanced Benefits can be defined at two levels: at the program level ("in program") or at the individual plan level. This view isolates the latter case, presenting one row for each plan-in-program record that carries its own enrollment-period definition, together with the rules governing the coverage start date, coverage end date, rate start date, and rate end date.

In EBS reporting and integration, the view serves as the descriptive-flexfield-enabled interface to the underlying foreign key flexfield entity BEN_ENRT_PERD_FOR_PL_F. Because it is defined WITH READ ONLY, it is intended strictly for query, reporting, and extract purposes. The user search term ben_enrt_cvg_end corresponds directly to the lookup and decode columns exposed here for the enrollment coverage end date.

Underlying Base Objects

The view is owned by the APPS schema and is status VALID. It is defined over two documented referenced objects:

• BEN_ENRT_PERD_FOR_PL_F (referenced through a SYNONYM) — the base table storing enrollment period definitions at the plan-in-program level, aliased as ERP in the view text.
• HR_BIS (PACKAGE) — the Business Intelligence System utility package used for secured decode of lookup values and business-group security filtering.

The WHERE clause filters rows so that BUSINESS_GROUP_ID equals NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ERP.BUSINESS_GROUP_ID), enforcing the session's security profile business group. The view therefore inherits the effective-dating (EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) model of the base table and adds presentation-level decoding.

Key Columns

• ENRT_PERD_FOR_PL_ID — primary identifier for the enrollment-period-for-plan record.
• PL_ID, ENRT_PERD_ID, BUSINESS_GROUP_ID, LEE_RSN_ID — foreign keys to the plan, the enrollment period, the business group, and the life event reason respectively.
• ENRT_CVG_STRT_DT_RL / ENRT_CVG_END_DT_RL — the rule dates controlling when enrollment coverage starts and ends. The corresponding code columns ENRT_CVG_STRT_DT_CD and ENRT_CVG_END_DT_CD are decoded via HR_BIS.BIS_DECODE_LOOKUP using the lookups BEN_ENRT_CVG_STRT and BEN_ENRT_CVG_END, surfacing as _CD_M meaning columns.
• RT_STRT_DT_RL / RT_END_DT_RL — the rule dates for rate start and rate end, with decoded counterparts using lookups BEN_RT_STRT and BEN_RT_END.
• "_DF:ERP" — the descriptive flexfield reference token _DF:BEN:BEN_ENRT_PERD_FOR_PL_F:ERP, allowing DFF attributes to be surfaced by the reporting layer.
• WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE for audit traceability.

Common Use Cases and Queries

Typical uses include validating which plans carry independent enrollment periods rather than inheriting the program-level period, auditing coverage-end rule assignments, and feeding downstream extracts. The following query retrieves enrollment-period-for-plan records with their coverage end decoding:

• SELECT pl_id, enrt_perd_id, enrt_cvg_strt_dt_cd, enrt_cvg_strt_dt_cd_m, enrt_cvg_end_dt_cd, enrt_cvg_end_dt_cd_m
• FROM apps.benbv_enrt_perd_for_pl_v
• WHERE TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

To find records where a coverage end rule is explicitly defined, filter on enrt_cvg_end_dt_cd IS NOT NULL. Because the view implements business-group security automatically, no additional security predicate is required in the query. All access should remain read-only, consistent with the view's WITH READ ONLY definition.