Results for “ben_rt_strt”

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

Overview

APPS.BENBV_ENRT_PERD_FOR_PL_V is a read-only business view (the "BV" prefix denotes "business view") in Oracle E-Business Suite Advanced Benefits (BEN). It presents configuration data that governs how enrollment periods behave relative to a plan or plan type, specifically the date rules that control when enrollment coverage and rates begin and end. The view exposes the underlying BEN_ENRT_PERD_FOR_PL_F rows alongside decoded lookup meanings, providing both raw codes and human-readable descriptions in a single queryable object. It is intended primarily as a reporting and integration surface rather than as a transactional form.

The search term "ben_rt_strt" corresponds directly to columns exposed by this view: RT_STRT_DT_RL (rate start date rule) and RT_STRT_DT_CD (rate start date code). These columns drive the lookup BEN_RT_STRT, which is decoded within the view. This makes the view a natural entry point for administrators and developers investigating how rate start dates are derived for a given plan.

Underlying Base Objects

The view is defined over a single base object, BEN_ENRT_PERD_FOR_PL_F, referenced through a synonym in the APPS schema. This table stores the enrollment period rules associated with a plan or plan type, including effective-dated rule columns for coverage and rate start/end dates. The view applies a security predicate against BUSINESS_GROUP_ID using HR_BIS.GET_SEC_PROFILE_BG_ID, ensuring that only records belonging to the session's business group are visible.

The view also references the HR_BIS package, specifically the function HR_BIS.BIS_DECODE_LOOKUP, which translates stored lookup codes into their display meanings at query time. Because the view carries WITH READ ONLY, no DML is permitted against it, reinforcing its role as a pure reporting construct. The presence of the descriptive flexfield token _DF:BEN:BEN_ENRT_PERD_FOR_PL_F:ERP indicates that any DFF segments defined on the base table are surfaced automatically when the view is consumed by a business view framework or reporting tool that understands this convention.

Key Columns

• RT_STRT_DT_RL / RT_STRT_DT_CD — The rate start date rule and its associated lookup code. RT_STRT_DT_CD references the BEN_RT_STRT lookup, and the decoded meaning is returned by BIS_DECODE_LOOKUP('BEN_RT_STRT', ...).
• RT_END_DT_RL / RT_END_DT_CD — The corresponding rate end date rule, decoded against BEN_RT_END.
• ENRT_CVG_STRT_DT_RL / ENRT_CVG_STRT_DT_CD — Enrollment coverage start date rule, decoded against BEN_ENRT_CVG_STRT.
• ENRT_CVG_END_DT_RL / ENRT_CVG_END_DT_CD — Enrollment coverage end date rule, decoded against BEN_ENRT_CVG_END.
• ENRT_PERD_FOR_PL_ID — Primary key of the enrollment period rule row.
• PL_ID — Identifier of the associated plan.
• ENRT_PERD_ID — Identifier of the enrollment period.
• LEE_RSN_ID — Life event reason identifier, linking the rule to a qualifying life event where applicable.
• BUSINESS_GROUP_ID — Business group used for row-level security filtering.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date-effective bounds on the rule row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — Standard WHO audit columns.

Common Use Cases and Queries

The view is typically queried to audit rate start and end rules for plans, to build extract feeds for downstream benefits systems, or to troubleshoot why a rate began on an unexpected date. A representative query lists rate start rules for a specific plan:

• SELECT pl_id, rt_strt_dt_cd, rt_strt_dt_rl, rt_end_dt_cd, effective_start_date, effective_end_date FROM apps.benbv_enrt_perd_for_pl_v WHERE pl_id = :p_plan_id ORDER BY effective_start_date;
• SELECT enrt_perd_for_pl_id, pl_id, rt_strt_dt_rl FROM apps.benbv_enrt_perd_for_pl_v WHERE rt_strt_dt_cd = 'SOME_CODE';

Because the view enforces read-only semantics and business group security, it is safe to expose to report consumers and integration accounts without risk of data modification and without leaking cross-business-group records. Analysts seeking the meaning behind "ben_rt_strt" can filter on RT_STRT_DT_CD and read the decoded value from the adjacent column returned by the view.