Results for “benbv_elig_mrtl_stat_cvg_v”

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

Overview

BENBV_ELIG_MRTL_STAT_CVG_V is a read-only Oracle EBS Advanced Benefits (BEN) view owned by the APPS schema. It exposes the marital status eligibility rules that determine whether a participant may designate another person (a dependent or contact) for coverage under a benefit program. In other words, the view answers the eligibility question: what marital status must a contact hold for a participant to be permitted to enroll them for coverage? The view is a "BV" (business view) style wrapper over the underlying eligibility marital status coverage table, adding decoded display values and flexfield descriptors suitable for reporting, OAF pages, and integration extraction.

Because it is defined WITH READ ONLY and filters by the session's business group through a security profile, it is intended for query and reporting rather than transactional DML. The view is relevant to the ben_dpnt_cvg_start search term because one of its decoded columns, CVG_STRT_CD, is resolved through the BEN_DPNT_CVG_START lookup type, which governs when dependent coverage starts.

Underlying Base Objects

The view is defined over a single base object and references one package:

• BEN_ELIG_MRTL_STAT_CVG_F (SYNONYM) — the eligibility marital status coverage table (or its synonym) that stores the marital status rules and coverage start/through rules used in dependent eligibility. The view's aliased columns (EMS.*) all originate here.
• HR_BIS (PACKAGE) — the HR business intelligence/decoding package used to translate code columns into their display meanings via HR_BIS.BIS_DECODE_LOOKUP, and to enforce business-group security via HR_BIS.GET_SEC_PROFILE_BG_ID.

The WHERE clause filters rows by business group: EMS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, EMS.BUSINESS_GROUP_ID), so a caller only sees eligibility rules for the business group associated with their security profile, or all groups when no profile is set.

Key Columns

• ELIG_MRTL_STAT_CVG_ID — primary identifier for the marital status coverage eligibility rule.
• DPNT_CVG_ELIGY_PRFL_ID — foreign key linking the rule to the dependent coverage eligibility profile that owns it.
• BUSINESS_GROUP_ID — the business group that owns the rule; drives security filtering.
• MRTL_STAT_CD / MRTL_STAT_CD_M — the marital status code and its decoded meaning (through the MAR_STATUS lookup).
• CVG_STRT_CD / CVG_STRT_CD_M — the coverage start rule code and its decoded value (through BEN_DPNT_CVG_START). This is the column most closely tied to the ben_dpnt_cvg_start search.
• CVG_THRU_CD / CVG_THRU_CD_M — the coverage end rule code and its decoded value (through BEN_DPNT_CVG_END).
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date range for which the rule is valid.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard audit (WHO) columns.
• "_DF:EMS" — a descriptive flexfield descriptor token passed through for the BEN_ELIG_MRTL_STAT_CVG_F flexfield.

Common Use Cases and Queries

This view is typically used to validate or display the marital status conditions attached to a dependent coverage eligibility profile, and to resolve start/end coverage rules into readable text.

• Reviewing all marital status rules for a given dependent coverage profile.
• Confirming which coverage start rules (BEN_DPNT_CVG_START) apply to contacts of a particular marital status.
• Reporting eligibility setup with decoded values for end users.

Example query listing decoded rules for a profile:

SELECT elig_mrtl_stat_cvg_id, mrtl_stat_cd, mrtl_stat_cd_m, cvg_strt_cd, cvg_strt_cd_m, cvg_thru_cd, cvg_thru_cd_m, effective_start_date, effective_end_date FROM apps.benbv_elig_mrtl_stat_cvg_v WHERE dpnt_cvg_eligy_prfl_id = :p_profile_id ORDER BY mrtl_stat_cd;

Because the view is read-only and security-filtered, it is safe for ad hoc reporting and integration extracts, but all maintenance must be performed against the underlying BEN_ELIG_MRTL_STAT_CVG_F table.