Results for “per_cobra_coverage_benefits_f”

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

Overview

PER_COBRA_COVERAGE_BENEFITS_F is a core Human Resources (PER) table in Oracle EBS 12.1.1 and 12.2.2, owned by the HR schema. It stores the details of individual benefits that an employee (or qualified beneficiary) either accepts or rejects as part of their Consolidated Omnibus Budget Reconciliation Act (COBRA) coverage. COBRA applies primarily to US-based legislations, and this table captures the benefit-level decisions associated with an employee's COBRA enrollment, forming the transactional record of what each participant elects to continue after a qualifying event.

From a data-modeling perspective, the provided metadata classifies this object heuristically as a link table. This is a modeling suggestion derived from its foreign key structure: it serves to associate a COBRA enrollment with a specific benefit element (ELEMENT_TYPE_ID), making it a junction-style entity between enrollments and benefit plan elements. It follows the standard EBS "_F" date-tracked table convention, carrying EFFECTIVE_START_DATE and EFFECTIVE_END_DATE for temporal versioning.

Key Information Stored

The table contains 35 documented columns. The most significant are summarized below, distinguishing the surrogate key from business-key candidates.

• COBRA_COVERAGE_BENEFIT_ID — The primary surrogate identifier for each benefit record, the leading column of the primary key.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date-effective range columns enabling historical tracking (datetrack) of benefit elections.
• BUSINESS_GROUP_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, identifying the business group (enterprise) owning the record.
• COBRA_COVERAGE_ENROLLMENT_ID — Foreign key to PER_COBRA_COV_ENROLLMENTS, linking the benefit line to its parent COBRA enrollment.
• ELEMENT_TYPE_ID — Identifier of the benefit/earnings element being elected or waived.
• ACCEPT_REJECT_FLAG — Indicates whether the participant accepted or rejected the specific benefit.
• COVERAGE_AMOUNT — Monetary value or elected coverage amount for the benefit.
• COVERAGE_TYPE — Categorization of the coverage (for example plan or tier type).
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — The standard EBS descriptive flexfield (DFF) columns for extensible, customer-defined attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard EBS audit (WHO) columns.

Two unique indexes act as business-key candidates. The primary key PER_COBRA_COVERAGE_BENEFIT_PK is composed of (COBRA_COVERAGE_BENEFIT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE). The alternate unique key PER_COBRA_COVERAGE_BENEFIT_UK2 is composed of (COBRA_COVERAGE_ENROLLMENT_ID, ELEMENT_TYPE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE), ensuring one benefit election per enrollment and element within a date range.

Common Use Cases and Queries

Typical scenarios include reporting on COBRA benefit elections, auditing accept/reject decisions, and reconciling coverage amounts for premium billing. A common query pattern joins the benefit lines to their parent enrollment:

• Listing all benefits elected for a given COBRA enrollment by joining on COBRA_COVERAGE_ENROLLMENT_ID = PER_COBRA_COV_ENROLLMENTS.COBRA_COVERAGE_ENROLLMENT_ID, filtered by ACCEPT_REJECT_FLAG.
• Date-effective reporting using a WHERE clause on SYSDATE or a parameter between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to retrieve the current active election.
• Aggregating COVERAGE_AMOUNT by ELEMENT_TYPE_ID for billing or premium summaries across a business group (BUSINESS_GROUP_ID).
• Audit reporting by inspecting the WHO columns to trace record creation and modification.

Standard EBS date-tracked access rules apply; queries should always constrain the effective date range to avoid returning multiple historical versions of the same benefit line.

Related Objects

The FK/PK metadata identifies the principal related objects, which should be used for join and referential planning:

• PER_COBRA_COV_ENROLLMENTS — Parent enrollment table joined via COBRA_COVERAGE_ENROLLMENT_ID; this is the primary transactional parent.
• HR_ALL_ORGANIZATION_UNITS — Business group reference joined via BUSINESS_GROUP_ID.
• PER_COBRA_COVERAGE_BENEFIT_PK — Primary key constraint on this table.
• PER_COBRA_COVERAGE_BENEFIT_UK2 — Alternate unique key enforcing enrollment/element uniqueness per date range.
• PER_COBRA_COVERAGE_BENEFITS_F (DFF) — The descriptive flexfield context defined over the ATTRIBUTE columns.

Downstream reporting and COBRA administration processes typically depend on this table in combination with its parent enrollment table and the benefit element definitions, making PER_COBRA_COVERAGE_ENROLLMENT_ID the most frequently used join column in practical queries.