Search Results ben_elig_per_elctbl_chc




Overview
Explore in AI Chat

Overview

The BEN_ELIG_PER_ELCTBL_CHC table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module, versions 12.1.1 and 12.2.2. It serves as the transactional repository for recording the specific benefit choices an eligible participant (employee or other person) elects during an enrollment event. The table's role is to persist the final, validated selections made by a participant from the available electable choices defined in the system, forming a critical link between eligibility determination and the actual enrollment results. It is the central record of a participant's election, upon which subsequent coverage, rates, and premiums are calculated.

Key Information Stored

The table's primary purpose is to track a participant's elected choice. Its structure is defined by key identifier columns that establish relationships to other critical benefit entities. The primary key is ELIG_PER_ELCTBL_CHC_ID, a unique system-generated identifier for each election record. Fundamental foreign keys include PER_IN_LER_ID, which links the election to the specific participant's life event record (BEN_PER_IN_LER), and YR_PERD_ID, which ties it to the enrollment period (BEN_YR_PERD). The PIL_ELCTBL_CHC_POPL_ID column references the specific population of electable choices (BEN_PIL_ELCTBL_CHC_POPL) from which this election was made. The table also supports interim or draft elections through the INTERIM_ELIG_PER_ELCTBL_CHC_ID column, which can recursively point to another record within the same table.

Common Use Cases and Queries

This table is central to post-enrollment reporting and audit processes. Common use cases include generating summary reports of elections by benefit plan, validating elections against business rules, and troubleshooting enrollment issues. A typical query would join this table to participant and plan information to list all elections for a given enrollment period. For example:

  • Identifying all elections for a participant in a specific period: SELECT * FROM BEN_ELIG_PER_ELCTBL_CHC chc, BEN_PER_IN_LER ler WHERE chc.PER_IN_LER_ID = ler.PER_IN_LER_ID AND ler.PERSON_ID = <person_id> AND chc.YR_PERD_ID = <period_id>;
  • Auditing the linkage from election to final enrolled benefits: SELECT chc.ELIG_PER_ELCTBL_CHC_ID, bnft.ENRT_BNFT_ID FROM BEN_ELIG_PER_ELCTBL_CHC chc JOIN BEN_ENRT_BNFT bnft ON bnft.ELIG_PER_ELCTBL_CHC_ID = chc.ELIG_PER_ELCTBL_CHC_ID;

Related Objects

The BEN_ELIG_PER_ELCTBL_CHC table is a central hub with extensive foreign key relationships, as documented in the ETRM. Key parent tables it references include BEN_PER_IN_LER (via PER_IN_LER_ID), BEN_YR_PERD (via YR_PERD_ID), and BEN_PIL_ELCTBL_CHC_POPL (via PIL_ELCTBL_CHC_POPL_ID). Crucially, it is the parent table for numerous child objects that store derived enrollment data, including:

  • BEN_ENRT_BNFT: Stores the final enrolled benefits, joined on ELIG_PER_ELCTBL_CHC_ID.
  • BEN_ENRT_RT: Stores enrollment rates, joined on ELIG_PER_ELCTBL_CHC_ID.
  • BEN_ENRT_PREM: Stores enrollment premiums, joined on ELIG_PER_ELCTBL_CHC_ID.
  • BEN_ELIG_CVRD_DPNT_F and BEN_ELIG_DPNT: Store records for eligible covered dependents, joined on ELIG_PER_ELCTBL_CHC_ID.
  • BEN_ELCTBL_CHC_CTFN: Stores certifications related to the elected choice, joined on ELIG_PER_ELCTBL_CHC_ID.
It also maintains a recursive relationship with itself via the INTERIM_ELIG_PER_ELCTBL_CHC_ID column for tracking interim election states.