Search Results ben_cbr_quald_bnf




Overview
Explore in AI Chat

Overview

BEN_CBR_QUALD_BNF is a table in the BEN (Advanced Benefits) product schema within Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. The table identifies participants who have experienced a COBRA (US Consolidated Omnibus Budget Reconciliation Act) qualifying life event. COBRA requires that employers offer continuation of group health coverage to qualified beneficiaries following specific events — termination of employment, reduction in hours, divorce, death of a covered employee, and similar triggers. This table records the qualified beneficiary designation arising from such an event and links it to the participant's eligibility records for the continuation period.

The object is documented as VALID in the ETRM repository. Its physical structure carries 49 columns, an explicit primary key constraint (BEN_CBR_QUALD_BNF_PK on CBR_QUALD_BNF_ID), and a foreign key to HR_ALL_ORGANIZATION_UNITS through BUSINESS_GROUP_ID, which anchors the record to a specific business group for multi-organization filtering and security. The heuristic Data Vault classification for this object is satellite-leaning: its structure suggests it operates as a descriptive satellite attached to a core participant/event hub rather than as an independent hub or a pure link. This classification is a modeling suggestion only, derived from the foreign-key topology, and should not be treated as a normative architectural statement.

Key Information Stored

The table's most significant columns include the following. Note that the descriptive attribute block (CQB_ATTRIBUTE1 through CQB_ATTRIBUTE30, with CQB_ATTRIBUTE_CATEGORY) is a standard Oracle EBS descriptive-flexfield pattern and is typically not used for core processing logic, though it is available for customer extensions.

  • CBR_QUALD_BNF_ID — surrogate primary key, the unique business-key candidate documented in BEN_CBR_QUALD_BNF_PK. All foreign keys from dependent tables reference this column.
  • QUALD_BNF_PERSON_ID — the person identified as the qualified beneficiary under COBRA. This is the central business identifier for the row and is distinct from the surrogate primary key.
  • BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS; scopes the record to a business group and drives security and multi-org filtering.
  • QUALD_BNF_FLAG — indicator of qualified beneficiary status.
  • CBR_ELIG_PERD_STRT_DT and CBR_ELIG_PERD_END_DT — the COBRA eligibility (continuation) period start and end dates, essential for coverage-window reporting.
  • CBR_INELG_RSN_CD — the reason code describing why a participant is ineligible for the benefit if applicable.
  • CVRD_EMP_PERSON_ID — the covered employee (the person whose event generated COBRA rights).
  • PGM_ID, PTIP_ID, PL_TYP_ID — program, plan-in-program, and plan-type identifiers that tie the qualified beneficiary to a specific benefit offering.
  • OBSOLETE — flag indicating the row is no longer active.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — standard who-columns and optimistic locking.

Common Use Cases and Queries

Typical reporting scenarios include producing a COBRA-eligible population list, validating that continuation periods do not overlap plan enrollment, and auditing the business-group security of qualified beneficiary rows. A representative query joining to the participant/event table and to the organization unit follows:

SELECT q.CBR_QUALD_BNF_ID, q.QUALD_BNF_PERSON_ID, q.CBR_ELIG_PERD_STRT_DT, q.CBR_ELIG_PERD_END_DT, q.CBR_INELG_RSN_CD, l.PERSON_ID, o.NAME
FROM BEN.BEN_CBR_QUALD_BNF q
JOIN BEN.BEN_CBR_PER_IN_LER l ON l.CBR_QUALD_BNF_ID = q.CBR_QUALD_BNF_ID
JOIN HR.HR_ALL_ORGANIZATION_UNITS o ON o.ORGANIZATION_ID = q.BUSINESS_GROUP_ID
WHERE q.OBSOLETE = 'N' AND q.BUSINESS_GROUP_ID = :bg_id;

Extract/reporting processes frequently read this table alongside the RBV (row-by-value) views, and integration with payroll or carrier feeds typically filters on CBR_ELIG_PERD_STRT_DT to identify newly qualified beneficiaries in a given period.

Related Objects

  • BEN_CBR_PER_IN_LER — the primary child table; joins via BEN_CBR_PER_IN_LER.CBR_QUALD_BNF_ID = BEN_CBR_QUALD_BNF.CBR_QUALD_BNF_ID. It is the main consumer of the primary key.
  • BEN_CBR_PER_IN_LER_RBV — row-by-value view referencing CBR_QUALD_BNF_ID, used in Oracle's RBV reporting pattern.
  • BEN_CBR_QUALD_BNF_RBV — the row-by-value view of this table itself, exposing the documented columns for reporting.
  • HR_ALL_ORGANIZATION_UNITS — parent organization table for the BUSINESS_GROUP_ID foreign key; the join is on ORGANIZATION_ID = BUSINESS_GROUP_ID.

These four objects constitute the documented relationship footprint. Additional BEN COBRA and benefit-enrollment tables may depend on the qualified beneficiary row through PGM_ID, PTIP_ID, or PL_TYP_ID, but those relationships are not enumerated in the ETRM metadata and should be validated against the site's own data model.