Search Results ben_elig_to_prte_rsn_f




Overview
Explore in AI Chat

Overview

BEN_ELIG_TO_PRTE_RSN_F is a core configuration table within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. The table stores the eligibility-to-participation reason definitions that determine when a life event reason causes immediate inclusion into, or exclusion from, a compensation object. In practical terms, it links a life event reason (LER) to an eligibility or ineligibility outcome, optionally qualified by waiting periods, maximum periods of enrollment, and participation override rules. The "_F" suffix indicates a date-tracked (datetrack) table, meaning every row carries EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns to preserve historical versions of the rule.

The ETRM metadata classifies this object heuristically as standalone under the Data Vault model. In a dimensional or Data Vault re-engineering exercise, this suggests the table may be modeled as an independent structure rather than as a strict hub, link, or satellite, because the mined foreign-key structure does not surface strong parent-child dependencies. Its 67 documented columns and composite primary key reinforce its role as a configuration master rather than a transactional fact.

Key Information Stored

The primary key BEN_ELIG_TO_PRTE_RSN_F_PK is composed of three columns: ELIG_TO_PRTE_RSN_ID (the surrogate identifier), EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. The ID is the system-generated surrogate key, while the two date columns act as the business-effective envelope used for date-tracked versioning.

The most operationally significant columns include:

Common Use Cases and Queries

Consultants and developers query this table to validate why a participant was included or excluded from a compensation object following a life event. Typical scenarios include auditing waiting period logic, confirming override behavior, and tracing maximum period of enrollment enforcement. Common SQL patterns join on LER_ID to BEN_LER_F and on the plan identifiers to BEN_PL_F, BEN_PGM_F, or BEN_PTIP_F, always applying the effective date filter to select the correct datetracked version. Reporting extracts frequently filter by BUSINESS_GROUP_ID and restrict on SYSDATE between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to retrieve only currently active rules.

Related Objects

  • BEN_LER_F — Joined via LER_ID to resolve the life event reason causing the inclusion/exclusion.
  • BEN_PL_F — Joined via PL_ID to identify the plan being affected.
  • BEN_PGM_F — Joined via PGM_ID for the program context.
  • BEN_PTIP_F — Joined via PTIP_ID for plan-type-in-program references.
  • BEN_PLIP_F — Joined via PLIP_ID for plan-in-program options.
  • BEN_OIPL_F — Joined via OIPL_ID for options-in-plan references.
  • BEN_PER_PTIP_F / BEN_PER_PLIP_F — Participation tables whose behavior is governed by these rules.
  • BEN_ELIG_TO_PRTE_RSN_F_PK — The unique index enforcing the composite primary key on ELIG_TO_PRTE_RSN_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE.