Search Results ben_elig_cvrd_dpnt_f

Overview

The BEN_ELIG_CVRD_DPNT_F table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module, specifically in versions 12.1.1 and 12.2.2. It serves as a foundational table for managing and tracking eligible covered dependents in the benefits enrollment process. As a date-effective table, it maintains a historical record of dependent eligibility, allowing the system to accurately reflect eligibility statuses over time. Its primary role is to store the relationship between a participant's benefit election choices and the specific dependents who are eligible for coverage under those elections, forming a critical link in the benefits data model.

Key Information Stored

The table's structure is designed to support date-effective tracking and relational integrity. The primary key is a composite of ELIG_CVRD_DPNT_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, which uniquely identifies each record and its period of validity. Two critical foreign key columns establish essential relationships: ELIG_PER_ELCTBL_CHC_ID links to the BEN_ELIG_PER_ELCTBL_CHC table, connecting the dependent to a specific eligibility profile and election choice made by a participant. PER_IN_LER_ID links to the BEN_PER_IN_LER table, associating the record with a participant's specific life event (e.g., hire, marriage) that may trigger eligibility. Together, these columns store the core data point: which dependent is eligible for coverage under a particular election during a defined timeframe.

Common Use Cases and Queries

This table is central to benefits administration reporting and data validation. Common use cases include generating lists of all dependents currently eligible for a specific benefit plan, auditing enrollment history for a dependent, and verifying coverage during a life event. A typical query would join this table to dependent person tables (via PER_IN_LER) and election tables to produce a coverage report. For example, to find all active eligible dependents for a given election choice, a query would filter on EFFECTIVE_END_DATE = TO_DATE('4712/12/31','YYYY/MM/DD') (the Oracle EBS end date) and join to BEN_ELIG_PER_ELCTBL_CHC. Data from this table is also critical for downstream processes like generating benefit statements or interfacing with external carriers.

Related Objects

The table's integrity is maintained through defined foreign key relationships, as documented in the ETRM metadata. It references two key parent tables:

• BEN_ELIG_PER_ELCTBL_CHC: Joined via the column BEN_ELIG_CVRD_DPNT_F.ELIG_PER_ELCTBL_CHC_ID. This links the covered dependent record to the participant's specific eligibility and election choice.
• BEN_PER_IN_LER: Joined via the column BEN_ELIG_CVRD_DPNT_F.PER_IN_LER_ID. This links the record to the participant's life event record, providing context for the eligibility period.

These relationships are fundamental for constructing accurate joins in reports and ensuring data consistency across the benefits enrollment lifecycle.