Search Results ben_elig_dpnt_pk

Overview

The BEN_ELIG_DPNT table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for storing information about eligible dependents. In the context of benefits administration, an eligible dependent is a person, such as a spouse or child, who is qualified to be covered under a participant's benefit plans based on defined eligibility rules. This table is fundamental for managing the enrollment lifecycle, as it establishes the link between a benefits participant and the individuals for whom they can elect coverage. Its data is critical for determining available choices during enrollment events and for maintaining accurate coverage records.

Key Information Stored

The table's primary purpose is to identify and relate dependents within the benefits framework. Its most critical column is the primary key, ELIG_DPNT_ID, which uniquely identifies each eligible dependent record. Other essential foreign key columns define the context of the eligibility. The ELIG_PER_ELCTBL_CHC_ID links the dependent to a specific eligible person and electable choice record, which is the core of the enrollment definition. The PER_IN_LER_ID ties the record to a person in a life event (e.g., hire, marriage), indicating the enrollment event that triggered the eligibility assessment. Finally, the BUSINESS_GROUP_ID anchors the data to the correct organizational unit for security and data partitioning.

Common Use Cases and Queries

This table is primarily accessed for enrollment processing and dependent eligibility reporting. A common use case is to generate a list of all dependents available for enrollment by a specific participant during a given life event. For troubleshooting, one might query to verify that dependent records were correctly created. A typical reporting query would join to related tables to provide a comprehensive view.

Sample Query Pattern:
SELECT bed.elig_dpnt_id,
    bed.per_in_ler_id,
    bed.elig_per_elctbl_chc_id
FROM ben_elig_dpnt bed
WHERE bed.business_group_id = :p_bg_id
AND bed.per_in_ler_id = :p_per_in_ler_id;

Related Objects

The BEN_ELIG_DPNT table maintains documented foreign key relationships with several key benefits and HR tables, as per the provided metadata:

• BEN_ELIG_PER_ELCTBL_CHC: Joined via BEN_ELIG_DPNT.ELIG_PER_ELCTBL_CHC_ID. This is a crucial relationship connecting the eligible dependent to the participant's specific eligibility and election choice record.
• BEN_PER_IN_LER: Joined via BEN_ELIG_DPNT.PER_IN_LER_ID. This links the dependent to the master record of a person involved in a life event, providing the event context.
• HR_ALL_ORGANIZATION_UNITS: Joined via BEN_ELIG_DPNT.BUSINESS_GROUP_ID. This standard HR table provides the business group context for the dependent record.

The table's primary key constraint, BEN_ELIG_DPNT_PK, on the ELIG_DPNT_ID column ensures the integrity of these relationships from the BEN_ELIG_DPNT side.