Search Results ben_cbr_per_in_ler




Overview
Explore in AI Chat

Overview

The BEN_CBR_PER_IN_LER table resides in the BEN schema and belongs to the Advanced Benefits (BEN) module of Oracle E-Business Suite. Its documented purpose is to store life events that may make a participant eligible for COBRA benefits in a United States legislative context. In practice, the table functions as an intersection object that associates a person-level life event with a COBRA qualified benefit, while also recording the business group (organization) that owns the record and an extensive set of configuration attributes.

In Data Vault modeling terms, the heuristic classification mined from the foreign key structure identifies this object as a link. The relationships it maintains — to BEN_CBR_QUALD_BNF, BEN_PER_IN_LER, and HR_ALL_ORGANIZATION_UNITS — together with its role of resolving a qualified benefit against a participant life event, are characteristic of a link table that captures the conditions under which COBRA eligibility is triggered. The table includes EBS standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and an OBJECT_VERSION_NUMBER for optimistic locking, which is consistent with a transactional link populated through concurrent processing.

Key Information Stored

The physical schema documents 44 columns. The most significant are:

  • CBR_PER_IN_LER_ID — Surrogate primary key, enforced by unique index BEN_CBR_PER_IN_LER_PK. It is the single-column business-key candidate documented for this table.
  • PER_IN_LER_ID — Foreign key to BEN_PER_IN_LER, identifying the participant life event being evaluated.
  • CBR_QUALD_BNF_ID — Foreign key to BEN_CBR_QUALD_BNF, identifying the COBRA qualified benefit tied to the event.
  • BUSINESS_GROUP_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, indicating the owning business group.
  • INIT_EVT_FLAG — Indicates whether the associated life event is treated as an initial event for COBRA purposes.
  • CNT_NUM — A count or sequence number maintained by the process that generates the COBRA event.
  • PRVS_ELIG_PERD_END_DT — The end date of the previous eligibility period, used to measure continuity and timing of COBRA eligibility.
  • CRP_ATTRIBUTE_CATEGORY and CRP_ATTRIBUTE1–30 — A descriptive flexfield container holding 30 configurable attribute segments plus the category, allowing extensible capture of legislative or plan-specific data.
  • OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit and concurrency control columns.

The surrogate key is therefore CBR_PER_IN_LER_ID, while the documented unique index confirms it as the only business-key candidate; the remaining columns are foreign keys, flags, dates, or flexfield segments.

Common Use Cases and Queries

Functional and technical consultants query this table when validating why a terminated participant was offered COBRA coverage, when reporting COBRA-qualifying events for compliance, or when extracting data for a benefits data warehouse.

A typical join returns the life event description and the qualified benefit name:

  • SELECT p.CBR_PER_IN_LER_ID, p.PER_IN_LER_ID, p.CBR_QUALD_BNF_ID, p.INIT_EVT_FLAG, p.PRVS_ELIG_PERD_END_DT FROM BEN.BEN_CBR_PER_IN_LER p WHERE p.BUSINESS_GROUP_ID = :p_business_group_id;
  • JOIN BEN.BEN_PER_IN_LER l ON l.PER_IN_LER_ID = p.PER_IN_LER_ID
  • JOIN BEN.BEN_CBR_QUALD_BNF q ON q.CBR_QUALD_BNF_ID = p.CBR_QUALD_BNF_ID

Reporting queries commonly filter on INIT_EVT_FLAG to isolate initial qualifying events, order by CREATION_DATE to audit processing runs, and use the CRP_ATTRIBUTE flexfield columns for plan-specific reporting. Because the table participates in a link pattern, set-based queries should always constrain on BUSINESS_GROUP_ID to preserve multi-tenancy isolation across business groups.

Related Objects

  • BEN_PER_IN_LER — Parent table of participant life events, joined on PER_IN_LER_ID.
  • BEN_CBR_QUALD_BNF — Stores COBRA qualified benefits, joined on CBR_QUALD_BNF_ID.
  • HR_ALL_ORGANIZATION_UNITS — Business group definition, joined on BUSINESS_GROUP_ID.
  • BEN_CBR_PER_IN_LER_RBV — A view that references this table via CBR_PER_IN_LER_ID and is commonly used for reporting.
  • BEN_CBR_PER_IN_LER_PK — Primary key unique index on CBR_PER_IN_LER_ID.

These objects form the core COBRA eligibility data model around the participant life event and qualified benefit link.