Search Results ben_per_in_ler

Overview

The BEN_PER_IN_LER 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 primary transactional record for tracking a person (employee, contingent worker, or other participant) who is experiencing a life event. A life event, or Life Event Reason (LER), is a qualifying occurrence—such as marriage, birth of a child, or a change in employment status—that triggers an opportunity for benefits enrollment or changes. This table acts as the central hub for a life event instance, linking the person, the specific life event reason, and the subsequent enrollment processes. Its existence is fundamental to the event-driven enrollment architecture of Advanced Benefits.

Key Information Stored

The primary identifier for a life event instance is the PER_IN_LER_ID column, which is the primary key (BEN_PER_IN_LER_PK). A critical foreign key in this table is PTNL_LER_FOR_PER_ID, which links to the BEN_PTNL_LER_FOR_PER table. This relationship associates the person's life event record with the specific potential life event that was detected for them, connecting the transactional record back to the system's initial identification of the qualifying event. While the provided ETRM excerpt does not list all columns, typical columns in such a table would include identifiers for the person (PERSON_ID), the life event reason (LER_ID), effective dates (EFFECTIVE_DATE), the process status, and the associated benefits batch (BNFT_BATCH_ID).

Common Use Cases and Queries

This table is central to reporting, auditing, and troubleshooting the life event and enrollment lifecycle. Common use cases include generating reports of all life events processed within a specific period, investigating enrollment errors by tracing from a person's record to their specific life event instance, and reconciling data during benefits administration. A fundamental query pattern retrieves life event details for a person or a batch.

• Identifying life events for a person: SELECT * FROM ben_per_in_ler WHERE person_id = <person_id> ORDER BY effective_date;
• Joining to view life event reasons: SELECT pil.*, plf.ler_id FROM ben_per_in_ler pil, ben_ptnl_ler_for_per plf WHERE pil.ptnl_ler_for_per_id = plf.ptnl_ler_for_per_id;
• Troubleshooting a specific enrollment batch: SELECT count(*), process_status FROM ben_per_in_ler WHERE bnft_batch_id = <batch_id> GROUP BY process_status;

Related Objects

The BEN_PER_IN_LER table has extensive relationships, as indicated by its numerous foreign key dependencies. It is the parent table for a wide array of benefits transactional tables, underscoring its pivotal role. Key child tables include:

• BEN_BATCH_LER_INFO: Links life event instances to the processing batch.
• BEN_PRTT_ENRT_RSLT_F: Stores the final enrollment results stemming from the life event.
• BEN_ELIG_PER_F / BEN_ELIG_CVRD_DPNT_F: Record eligibility determinations for the person and dependents based on the life event.
• BEN_ELIG_PER_ELCTBL_CHC: Holds eligible choice options for the person.
• BEN_PL_BNF_F / BEN_PRTT_PREM_F / BEN_PRTT_RT_VAL: Store calculated benefits, premiums, and rates resulting from elections made during the life event.
• BEN_BNFT_PRVDD_LDGR_F: Tracks the benefits provided ledger entries.

Its primary parent relationship is with BEN_PTNL_LER_FOR_PER, which supplies the PTNL_LER_FOR_PER_ID.