Search Results ben_elig_per_f

Overview

The BEN_ELIG_PER_F table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module. It serves as a foundational table for managing and tracking participant eligibility. Specifically, it records the fact that a person (participant) is eligible for a particular benefits plan or program. As a date-effective table, denoted by the "_F" suffix and the presence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns, it maintains a historical record of eligibility status over time. This temporal capability is critical for accurate benefits administration, allowing the system to determine a participant's eligibility as of any given date, which is essential for enrollment processing, life event management, and compliance reporting.

Key Information Stored

The table's primary purpose is to establish a link between a participant and their eligible status, with key identifiers forming its structure. The primary key is a composite of ELIG_PER_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, ensuring uniqueness of each eligibility record across time. The ELIG_PER_ID itself is the unique identifier for a specific eligibility record. A critical foreign key relationship exists via the PER_IN_LER_ID column, which links to the BEN_PER_IN_LER table. This connection ties the eligibility record to a specific participant within a Life Event (Life Event Record), a central concept in Advanced Benefits where eligibility is often re-evaluated. The effective date columns define the period during which this eligibility assertion is valid.

Common Use Cases and Queries

This table is central to processes that require validating or listing eligible participants. A common reporting use case is to identify all employees eligible for a specific benefit as of the current date or a historical date for audit purposes. System processes heavily rely on this table during enrollment periods to determine which plans should be offered to an employee. A typical query pattern involves joining BEN_ELIG_PER_F to person tables (like PER_ALL_PEOPLE_F) and benefits definition tables, filtered by effective date.

• Sample SQL Pattern: Selecting current eligibility records for a participant: SELECT * FROM ben_elig_per_f WHERE sysdate BETWEEN effective_start_date AND effective_end_date AND per_in_ler_id = [ID_VALUE].
• Enrollment Engine: The enrollment engine references this table to build a list of available plans for a participant during self-service enrollment.
• Life Event Processing: During life event processing, new rows are inserted into this table to reflect updated eligibility based on the new event.

Related Objects

The most direct and critical relationship for BEN_ELIG_PER_F is with the BEN_PER_IN_LER table, as defined by its foreign key. BEN_PER_IN_LER stores information about participants associated with a life event, making the eligibility record contextually dependent on that life event instance. Furthermore, while not listed in the provided metadata, this table is logically related to core benefits setup tables such as BEN_ELIGY_PRFL (Eligibility Profile) and BEN_PGM_F (Program), often through intermediary entities or the enrollment engine's logic. It may also be referenced by key benefits views that consolidate eligibility data for reporting and application logic.