Search Results benbv_elig_mltry_stat_prte_v




Overview
Explore in AI Chat

Overview

BENBV_ELIG_MLTRY_STAT_PRTE_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, defined within the BEN (Advanced Benefits) product module. The view presents eligibility participation data related to military status participation rules, exposing records stored in the underlying eligibility military status participation table in a decoded, presentation-ready format.

In the Oracle EBS 12.1.1 and 12.2.2 release context, this view follows the standard "BV_" naming convention applied to many Advanced Benefits business views. These views are typically created to support the Benefits forms-based user interface and associated reporting. The view joins or references the HR_BIS package to decode stored code values into their human-readable meanings. As the metadata confirms, the view is defined with the READ ONLY clause, ensuring no DML operations are permitted against it.

The view is not intended for transactional processing; rather, it serves reporting and integration purposes, presenting eligibility rule definitions for military status in a form suitable for querying, extraction, and downstream analysis.

Underlying Base Objects

The view is defined over a single documented base object, accessed through a synonym:

  • BEN_ELIG_MLTRY_STAT_PRTE_F (SYNONYM): The core eligibility military status participation table. The "_F" suffix indicates it is the base (or "F" for the foundation) table storing the actual eligibility rule rows for military status participation.
  • HR_BIS (PACKAGE): Referenced within the view's SELECT statement via the function HR_BIS.BIS_DECODE_LOOKUP, which translates coded values into descriptive text.

The base table is aliased as ELI in the view definition. Because the view references BEN_ELIG_MLTRY_STAT_PRTE_F through a synonym and applies a WITH READ ONLY constraint, it provides a controlled, decoded projection of the underlying eligibility rule data without exposing the raw code columns alone.

Key Columns

The view exposes the following columns, per the documented metadata:

  • EFFECTIVE_START_DATE — The date on which the eligibility rule row becomes effective.
  • EFFECTIVE_END_DATE — The date on which the eligibility rule row ceases to be effective.
  • ORDR_NUM — The ordering or sequence number applied to the participation rule.
  • MLTRY_STAT_CD — The military status code stored on the base record.
  • MLTRY_STAT_CD_M — The decoded, meaningful description of MLTRY_STAT_CD, produced through HR_BIS.BIS_DECODE_LOOKUP. Where no lookup match exists, the function returns the defined "LOOKUP_NOT_FOUND" value.
  • EXCLD_FLAG — A flag indicating whether the military status is excluded from the eligibility rule.
  • EXCLD_FLAG_M — The decoded meaning of EXCLD_FLAG, resolved against the YES_NO lookup.
  • ELIG_MLTRY_STAT_PRTE_ID — The unique identifier for the eligibility military status participation record.
  • ELIGY_PRFL_ID — The identifier of the associated eligibility profile to which this rule belongs.

The presence of both raw code columns and decoded "_M" columns is characteristic of Benefits business views, allowing reporting tools to display descriptive values while retaining the underlying codes for programmatic use.

Common Use Cases and Queries

This view is most commonly queried when administrators or developers need to inspect or report on military status eligibility rules defined within eligibility profiles. Typical scenarios include auditing which military statuses are included or excluded, extracting eligibility profile configurations for migration or integration, and building Benefits reports where descriptive values are preferred over raw codes.

A representative query returning decoded rule data for a specific eligibility profile:

  • SELECT eligy_prfl_id, mltry_stat_cd_m, excld_flag_m, order_num, effective_start_date, effective_end_date FROM apps.benbv_elig_mltry_stat_prte_v WHERE eligy_prfl_id = :p_profile_id AND SYSDATE BETWEEN effective_start_date AND effective_end_date ORDER BY order_num;

A second common pattern lists all active military status rules and their exclusion behavior for review purposes:

  • SELECT mltry_stat_cd_m, excld_flag_m FROM apps.benbv_elig_mltry_stat_prte_v WHERE TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

Because the view is defined WITH READ ONLY, all such queries are strictly for retrieval and reporting, consistent with its role as a presentation layer over the BEN_ELIG_MLTRY_STAT_PRTE_F base table.