Results for “ben_elig_per_elctbl_chc”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BEN_ELIG_PER_ELCTBL_CHC is a core configuration table in the Oracle Advanced Benefits (BEN) module. It stores the set of electable choices that a participant may select during an enrollment or benefits eligibility cycle. Each row represents a specific electable choice made available to a person-in-life-event context, tying together the participant's eligibility record, the plan-year period, and the population that drives plan eligibility. In effect, the table establishes the bridge between eligibility determination and the actual benefit election a participant can make, covering plans, plan types, options, and dependent coverage designations.

Within a Data Vault modeling heuristic, this object classifies as hub-leaning. It has a single-column surrogate primary key and a dense set of inbound foreign key references from transactional enrollment tables, suggesting it acts as a durable business-key reference point around which enrollment, premium, and rate satellites revolve. Modelers should treat ELIG_PER_ELCTBL_CHC_ID as the stable hub key, with the many descriptive and status columns representing satellite-style attributes.

Key Information Stored

The table is anchored by its surrogate primary key, ELIG_PER_ELCTBL_CHC_ID, enforced by the unique index BEN_ELIG_PER_ELCTBL_CHC_PK. The most significant columns include:

• PER_IN_LER_ID — foreign key to BEN_PER_IN_LER, linking the choice to the participant's life-event eligibility record.
• YR_PERD_ID — foreign key to BEN_YR_PERD, anchoring the choice to a plan-year period.
• PIL_ELCTBL_CHC_POPL_ID — foreign key to BEN_PIL_ELCTBL_CHC_POPL, the eligibility population that governs the choice.
• ELCTBL_FLAG, MNDTRY_FLAG, DFLT_FLAG — control whether the choice is electable, mandatory, or defaulted.
• CRNTLY_ENRD_FLAG, AUTO_ENRT_FLAG, CTFN_RQD_FLAG — indicate current enrollment, automatic enrollment, and whether confirmation is required.
• ALWS_DPNT_DSGN_FLAG — permits dependent designation against the choice.
• COMP_LVL_CD — the compensation level associated with the election.
• PL_ID, PL_TYP_ID, OIPL_ID, PLIP_ID, PTIP_ID — the plan, plan type, option-in-plan, and related identifiers that define what is being elected.
• INTERIM_ELIG_PER_ELCTBL_CHC_ID — self-referencing key for interim eligibility states.
• LAST_UPDATE_DATE, CREATED_BY, OBJECT_VERSION_NUMBER — standard audit and optimistic-locking columns.
• EPE_ATTRIBUTE1 through EPE_ATTRIBUTE30 — a wide descriptive flexfield segment for customer-defined extensions.

The surrogate key is distinct from any business-key candidate; the table documents only the PK unique index, so natural keys are formed by combinations such as participant, plan, and year period.

Common Use Cases and Queries

Typical uses include eligibility reporting, open-enrollment troubleshooting, and reconciliation of electable choices to actual enrollment. A common query joins the table to BEN_PER_IN_LER to retrieve choices for a participant, and to BEN_ENRT_BNFT to compare what was offered against what was elected. For example:

• Identify all mandatory choices not yet elected: filter MNDTRY_FLAG = 'Y' and CRNTLY_ENRD_FLAG = 'N'.
• List plan options available in a given year: join on YR_PERD_ID and PL_ID.
• Audit default elections by selecting DFLT_FLAG = 'Y'.
• Reconcile interim versus final choices via INTERIM_ELIG_PER_ELCTBL_CHC_ID.

Because the table feeds enrollment, premium, and rate processing, it is frequently used in enrollment reconciliation reports and in troubleshooting why a participant cannot see or select a plan.

Related Objects

The following objects reference or are referenced by BEN_ELIG_PER_ELCTBL_CHC and are most significant for integration and reporting:

• BEN_PER_IN_LER — joined on PER_IN_LER_ID; the participant life-event eligibility record.
• BEN_YR_PERD — joined on YR_PERD_ID; the plan-year period.
• BEN_PIL_ELCTBL_CHC_POPL — joined on PIL_ELCTBL_CHC_POPL_ID; the electable choice population.
• BEN_ENRT_BNFT — joined on ELIG_PER_ELCTBL_CHC_ID; actual benefit enrollment.
• BEN_ENRT_PREM and BEN_ENRT_RT — joined on ELIG_PER_ELCTBL_CHC_ID; premium and rate enrollment details.
• BEN_ELIG_DPNT and BEN_ELIG_CVRD_DPNT_F — joined on ELIG_PER_ELCTBL_CHC_ID; dependent eligibility.
• BEN_ELCTBL_CHC_CTFN — joined on ELIG_PER_ELCTBL_CHC_ID; choice confirmation.
• BEN_ELIG_PER_ELCTBL_CHC_RBV and related _RBV views — the runtime business views for reporting.

These relationships make the table a central reference for any Advanced Benefits enrollment data model or reconciliation report.