Results for “benbv_elig_mltry_stat_cvg_v”

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

Overview

The BENBV_ELIG_MLTRY_STAT_CVG_V view is a business-facing (BV) database object within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It is owned by the APPS schema and carries a VALID status. Its purpose is to identify the applicable military statuses that a contact must possess in order for a participant to designate that contact for coverage. In other words, the view resolves the eligibility criteria that govern whether a dependent or contact with a given military status qualifies to be enrolled under a dependent coverage eligibility profile.

Because this is a "BV" view, it is presented as a user-friendly, reporting-oriented projection of an underlying _F (flexfield) table. This design pattern is standard in Oracle Advanced Benefits, where the _F tables store raw, coded values and the BV views decode and present those values in a human-readable form. The view is read-only (defined WITH READ ONLY), which reinforces its role as a query and integration surface rather than a transactional object. Report developers, integration specialists, and functional analysts use it to extract eligibility configuration without navigating the underlying base tables directly.

Underlying Base Objects

The view is defined over the following documented base objects:

• BEN_ELIG_MLTRY_STAT_CVG_F (referenced as a SYNONYM) — the eligibility military status coverage flexfield table that stores the actual configuration rows, including effective dates, military status codes, and coverage start/through rules.
• HR_BIS (PACKAGE) — the Business Intelligence System utility package that supplies decoding functions and security profile handling.

The core SELECT draws from BEN_ELIG_MLTRY_STAT_CVG_F EMC. Two functions from HR_BIS are invoked: BIS_DECODE_LOOKUP translates coded values into their descriptive meaning, and GET_SEC_PROFILE_BG_ID enforces business group security by restricting rows to the caller's security profile. The WHERE clause applies this business group filter using NVL, so that if no security profile is resolved, all business groups are returned. The view also embeds a descriptive flexfield descriptor string ('_DF:BEN:BEN_ELIG_MLTRY_STAT_CVG_F:EMC') to expose flexfield context.

Key Columns

The view exposes the following notable columns:

• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-dated validity range of each eligibility military status coverage rule.
• MLTRY_STAT_CD — the military status code a contact must hold; MLTRY_STAT_CD_M is its decoded meaning via the YES_NO lookup.
• CVG_STRT_CD / CVG_STRT_RL — the coverage start code and its related rule (typically a date or event).
• CVG_THRU_CD / CVG_THRU_RL — the coverage end (through) code and its related rule. The CVG_THRU_CD_M column is decoded using the BEN_DPNT_CVG_END lookup, which is directly relevant to users searching for ben_dpnt_cvg_end behavior.
• ELIG_MLTRY_STAT_CVG_ID — the primary identifier for each eligibility military status coverage record.
• BUSINESS_GROUP_ID — the owning business group, used for security partitioning.
• DPNT_CVG_ELIGY_PRFL_ID — the dependent coverage eligibility profile to which the rule belongs.
• WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE) — standard audit columns.

Common Use Cases and Queries

This view is typically used to audit or report on the military-status eligibility rules attached to dependent coverage eligibility profiles, and to reconcile decoded coverage start and end values.

• Retrieve all military status eligibility rules for a given eligibility profile.
• Report decoded coverage end reasons (BEN_DPNT_CVG_END) across business groups.
• Feed downstream integrations with human-readable eligibility configuration.

A representative query follows:

SELECT elig_mltry_stat_cvg_id,
      mltry_stat_cd_m,
      cvg_strt_cd_m,
      cvg_thru_cd_m,
      effective_start_date,
      effective_end_date
FROM apps.benbv_elig_mltry_stat_cvg_v
WHERE dpnt_cvg_eligy_prfl_id = :p_profile_id
ORDER BY effective_start_date;

Because the view enforces business group security automatically, no additional security predicate is required in most reporting contexts.