Search Results ben_enrt_bnft




Overview
Explore in AI Chat

Overview

The BEN_ENRT_BNFT table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module. It serves as the central repository for recording an employee's enrollment in a specific benefit. The table represents the fundamental link between an employee's election and the actual benefit they have chosen, capturing the outcome of the enrollment process. Its primary role is to persist the definitive record of which benefits are active for a participant, forming the basis for eligibility validation, coverage calculations, and downstream processing such as premium and rate determination.

Key Information Stored

The table's primary key is the unique identifier ENRT_BNFT_ID. A critical foreign key column is ELIG_PER_ELCTBL_CHC_ID, which links the enrollment benefit record back to the employee's specific election choice stored in the BEN_ELIG_PER_ELCTBL_CHC table. This establishes the lineage from the initial eligible choice to the final enrolled benefit. While the provided ETRM excerpt does not list all columns, typical data stored includes references to the participant (PERSON_ID), the specific plan or option (BNFT_PRVDR_PL_OPT_ID or PL_TYP_ID), the associated coverage period (CVG_STRT_DT, CVG_END_DT), and the enrollment status. The table essentially holds the snapshot of the benefit election as it was finalized.

Common Use Cases and Queries

This table is central to reporting on employee benefit enrollments and integration with other systems like payroll. Common use cases include generating enrollment confirmation statements, auditing coverage for a specific period, and extracting data for carrier feeds. A typical query pattern involves joining to person and plan tables to list active enrollments.

  • Sample Query: To find all active medical plan enrollments for a person, one would join BEN_ENRT_BNFT to PER_ALL_PEOPLE_F (for person details) and BEN_PL_TYP_F (for plan type), filtering on the plan type code (e.g., 'MEDICAL'), the person identifier, and the current date falling within the coverage dates.
  • Reporting: The table is a primary source for ad-hoc reports on benefit participation rates, plan selection counts, and life event processing outcomes.

Related Objects

As indicated by the foreign key relationships, BEN_ENRT_BNFT is a pivotal parent table. Key related objects include:

  • BEN_ELIG_PER_ELCTBL_CHC: The source election choice that led to this enrollment record.
  • BEN_ENRT_PREM: Stores premium details (amounts, frequencies) specifically calculated for this enrollment benefit.
  • BEN_ENRT_RT: Stores contribution or coverage rate details associated with this enrollment benefit.

These dependencies highlight that BEN_ENRT_BNFT is the anchor for all subsequent financial and coverage calculations related to a specific enrolled benefit.