Search Results per_cobra_coverage_benefit_uk2




Overview
Explore in AI Chat

Overview

The table PER_COBRA_COVERAGE_BENEFITS_F is a core data object within the Oracle E-Business Suite Human Resources (HR) module, specifically supporting COBRA (Consolidated Omnibus Budget Reconciliation Act) administration. It functions as a detailed transactional repository for managing individual benefits associated with a COBRA coverage enrollment. Its primary role is to track each specific benefit plan that a qualified beneficiary (e.g., a former employee) has the option to accept or reject when electing COBRA continuation coverage. As a date-tracked table (indicated by the '_F' suffix and the EFFECTIVE_START_DATE/EFFECTIVE_END_DATE columns), it maintains a full history of changes to the benefit's status and details over time, which is critical for compliance and audit purposes.

Key Information Stored

The table stores the linkage between a COBRA enrollment and the specific benefits available under that enrollment. Key columns include the surrogate primary key COBRA_COVERAGE_BENEFIT_ID and the effective date pair (EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) that defines the record's validity. The foreign key COBRA_COVERAGE_ENROLLMENT_ID ties the benefit record to a specific enrollment in the PER_COBRA_COV_ENROLLMENTS table. The ELEMENT_TYPE_ID column identifies the precise benefit plan or element (such as medical, dental, or vision insurance) being offered. The BUSINESS_GROUP_ID, a standard HRMS column, links the data to the appropriate organizational security context. Additional columns, implied by the table's purpose, would typically store the beneficiary's election status (accept/reject), election date, and potentially cost information.

Common Use Cases and Queries

This table is central to generating COBRA election notices, managing ongoing coverage, and producing compliance reports. A common operational query would retrieve all active benefits for a specific COBRA enrollment to process a monthly invoice or confirm coverage details. For reporting, analysts often join this table with enrollment and person tables to generate summaries of election rates by benefit type or to audit election timelines. A typical SQL pattern involves filtering on the current effective date and joining to the element definitions:

  • SELECT pcob.cobra_coverage_enrollment_id, petf.element_name, pcob.effective_start_date FROM hr.per_cobra_coverage_benefits_f pcob, pay_element_types_f petf WHERE pcob.element_type_id = petf.element_type_id AND SYSDATE BETWEEN pcob.effective_start_date AND pcob.effective_end_date AND pcob.cobra_coverage_enrollment_id = :enrollment_id;

Data maintenance use cases include inserting a new record when a benefit is added to an enrollment or end-dating a record when a beneficiary drops a specific benefit.

Related Objects

PER_COBRA_COVERAGE_BENEFITS_F has defined foreign key relationships with several critical HR tables, forming the backbone of COBRA data integrity.

  • PER_COBRA_COV_ENROLLMENTS: This is the direct parent table. The join is made on PER_COBRA_COVERAGE_BENEFITS_F.COBRA_COVERAGE_ENROLLMENT_ID = PER_COBRA_COV_ENROLLMENTS.COBRA_COVERAGE_ENROLLMENT_ID. This relationship ensures every recorded benefit is attached to a valid COBRA enrollment event.
  • HR_ALL_ORGANIZATION_UNITS: The table is linked via PER_COBRA_COVERAGE_BENEFITS_F.BUSINESS_GROUP_ID. This enforces multi-org security, scoping the COBRA benefit data within the correct business group.
  • PAY_ELEMENT_TYPES_F: While not listed in the provided foreign keys, the ELEMENT_TYPE_ID column is a foreign key to this table, which defines the benefit plan (e.g., Medical Plan A). This is essential for describing the specific coverage being offered.

The table's primary keys (PER_COBRA_COVERAGE_BENEFIT_PK and PER_COBRA_COVERAGE_BENEFIT_UK2) ensure unique identification of records and prevent duplicate benefit entries for the same enrollment and element within a given date range.