Search Results ben_elig_mltry_stat_prte_f




Overview
Explore in AI Chat

Overview

BEN_ELIG_MLTRY_STAT_PRTE_F is a date-tracked (non-future-dated) table within the BEN schema of Oracle Advanced Benefits. It identifies the military status a participant must hold in order for that participant to be included in or excluded from a compensation object during eligibility determination. In practical terms, the table stores the military-status participation rule criteria that eligibility profiles apply when evaluating compensation objects such as plans, programs, and benefit offerings.

Based on the heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as a standalone entity. The absence of a strongly modeled parent or child link suggests the table functions as an independent reference of eligibility criteria, keyed by its own identifier and effective dating. Each row captures one military-status criterion attached to an eligibility profile, combined with flags and sequencing that determine how the criterion is applied.

Key Information Stored

The table contains seven documented columns in ETRM 12.2.2. The most significant are:

  • ELIG_MLTRY_STAT_PRTE_ID – The surrogate primary key identifying a unique military-status criterion record. It forms the leading column of both the primary key and the unique business-key index.
  • EFFECTIVE_START_DATE and EFFECTIVE_END_DATE – Date-effective columns that enable historical tracking of criterion definitions over time, allowing rule changes to be versioned without overwriting prior definitions.
  • MLTRY_STAT_CD – The military status code being evaluated as the inclusion/exclusion criterion. This is the core business attribute of the row.
  • EXCLD_FLAG – Indicates whether the specified military status is used to exclude (rather than include) participants from the compensation object.
  • ELIGY_PRFL_ID – The eligibility profile to which this criterion belongs, linking the rule to the broader eligibility determination logic.
  • ORDR_NUM – The sequencing value controlling the order in which the criterion is evaluated relative to other criteria in the same profile.

The documented primary key is BEN_ELIG_MLTRY_STAT_PRTE_F_PK, comprising ELIG_MLTRY_STAT_PRTE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. A separate unique index, EML_PK, is defined over ELIG_MLTRY_STAT_PRTE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, serving as a business-key candidate. The overlap between the surrogate and business keys reflects the standard Oracle date-effective pattern.

Common Use Cases and Queries

Typical usage centers on auditing and reporting eligibility rules attached to compensation objects. A common reporting query retrieves the current effective criteria for a given eligibility profile:

  • Select MLTRY_STAT_CD, EXCLD_FLAG, and ORDR_NUM from BEN_ELIG_MLTRY_STAT_PRTE_F where ELIGY_PRFL_ID equals the target profile and SYSDATE falls between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, ordered by ORDR_NUM.
  • Diagnose why a participant was excluded from a plan by inspecting EXCLD_FLAG values tied to the applicable MLTRY_STAT_CD.
  • Perform historical analysis of rule changes by comparing rows across multiple effective date ranges for the same ELIG_MLTRY_STAT_PRTE_ID.
  • Validate configuration by joining to eligibility profile tables to enumerate all criteria associated with a compensation object.

Related Objects

Because the metadata classifies this object as standalone, no explicit foreign keys are documented. The following related objects are significant in practice:

These relationships are joined primarily on ELIGY_PRFL_ID and the effective date columns.