Results for “cqb_attribute30”

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

Overview

BEN_CBR_QUALD_BNF_RBV is a table within the BEN (Advanced Benefits) product module of Oracle E-Business Suite, present and VALID in both release 12.1.1 and 12.2.2. The object name and the ETRM description — "Cobra Qualified Beneficiaries RBV" — identify it as the repository for Qualified Beneficiary (QB) information captured during Consolidated Omnibus Budget Reconciliation Act (COBRA) processing. In the context of Oracle Advanced Benefits, a qualified beneficiary is a person, other than the covered employee, who may be entitled to continuation of group health coverage following a qualifying event. This table stores the attributes and eligibility-period detail that Advanced Benefits uses when evaluating, enrolling, and rating such beneficiaries.

The "RBV" suffix denotes a row-based view or RBV-style denormalized structure used to hold the effective and multi-row qualified-beneficiary data associated with a COBRA benefit action. The ETRM Data Vault classification heuristic (mined from foreign-key structure) reports this object as standalone. As a modeling suggestion, this indicates the table is not treated as a strict hub or link in a Data Vault sense; it functions as a dependent satellite-style record that hangs off the benefit-action and COBRA qualified-beneficiary entities through its foreign keys.

Key Information Stored

The table contains 50 documented columns. The most significant are:

• CBR_QUALD_BNF_ID — Identifier of the COBRA qualified beneficiary. Together with BENEFIT_ACTION_ID this forms the unique index BEN_CBR_QUALD_BNF_RBV_PK, making both columns the composite business-key candidate.
• BENEFIT_ACTION_ID — The benefit action driving the COBRA event; part of the primary key and a foreign key to BEN_BENEFIT_ACTIONS.
• PERSON_ACTION_ID — Foreign key to BEN_PERSON_ACTIONS, linking the action to the affected person.
• QUALD_BNF_FLAG — Indicates whether the person qualifies as a qualified beneficiary.
• QUALD_BNF_PERSON_ID — The person identifier for the qualified beneficiary.
• CVRD_EMP_PERSON_ID — The covered employee on whose coverage the QB depends.
• BUSINESS_GROUP_ID — The HR business group that owns the record.
• CQB_ATTRIBUTE_CATEGORY and CQB_ATTRIBUTE1 … CQB_ATTRIBUTE30 — Descriptive flexfield (DFF) columns holding COBRA qualified beneficiary context and user-defined attributes.
• CBR_ELIG_PERD_STRT_DT / CBR_ELIG_PERD_END_DT — The COBRA eligibility period start and end dates.
• CBR_INELG_RSN_CD — Reason code for ineligibility.
• PGM_ID, PTIP_ID, PL_TYP_ID — Identifiers for the program, plan type, and plan type variant involved.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — Standard who-audit and optimistic-locking columns.

Common Use Cases and Queries

Typical uses include COBRA qualified-beneficiary reporting, continuation-coverage audits, and reconciliation of QB elections against the benefit action that produced them. A representative join retrieves the QB roster for a benefit action:

• SELECT q.NUM, q.QUALD_BNF_PERSON_ID, q.CBR_ELIG_PERD_STRT_DT, q.CBR_ELIG_PERD_END_DT FROM ben.BEN_CBR_QUALD_BNF_RBV q WHERE q.BENEFIT_ACTION_ID = :action_id AND q.QUALD_BNF_FLAG = 'Y';
• Join to BEN_BENEFIT_ACTIONS on BENEFIT_ACTION_ID, and to BEN_PERSON_ACTIONS on PERSON_ACTION_ID, to trace the event path.
• Query CQB_ATTRIBUTE columns with the DFF category in CQB_ATTRIBUTE_CATEGORY for custom reporting.
• Filter on CBR_INELG_RSN_CD to list ineligible QBs and their reason codes.

Related Objects

• BEN_CBR_QUALD_BNF — Parent COBRA qualified beneficiary entity, joined via CBR_QUALD_BNF_ID.
• BEN_BENEFIT_ACTIONS — Joined via BENEFIT_ACTION_ID; defines the action context.
• BEN_PERSON_ACTIONS — Joined via PERSON_ACTION_ID; the per-person action record.
• PER_ALL_PEOPLE_F — Joined via QUALD_BNF_PERSON_ID and CVRD_EMP_PERSON_ID for person names.
• BEN_PGM_F, BEN_PTIP_F, BEN_PL_TYP_F — Joined via PGM_ID, PTIP_ID, PL_TYP_ID to resolve program and plan type.