Search Results per_cobra_cov_enrollments




Overview
Explore in AI Chat

Overview

The PER_COBRA_COV_ENROLLMENTS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for managing enrollments under the Consolidated Omnibus Budget Reconciliation Act (COBRA). This U.S. federal mandate requires employers to offer continued health benefit coverage to employees and their dependents after a qualifying event, such as termination or reduction in hours. The table's primary role is to store and track each distinct COBRA enrollment instance, linking the eligible person, their associated benefits, and the administrative lifecycle of the coverage. It is fundamental to the COBRA administration functionality within Oracle HRMS.

Key Information Stored

The table stores the master record for a COBRA enrollment, with key columns defining its scope and status. The primary identifier is the COBRA_COVERAGE_ENROLLMENT_ID. Each enrollment is tied to a specific BUSINESS_GROUP_ID, ensuring data is partitioned by the organization's legal entity. The table links to the eligible person or dependent via the CONTACT_RELATIONSHIP_ID, which references the PER_CONTACT_RELATIONSHIPS table. Administrative details are captured, including the COBRA coverage PERIOD_TYPE (e.g., monthly) and critical dates such as the election date, coverage start date, and coverage end date. The table acts as a parent for detailed records stored in related tables for benefits, dependents, payments, and status history.

Common Use Cases and Queries

This table is central to COBRA reporting, compliance tracking, and operational processes. Common use cases include generating eligibility notices, tracking election responses, managing premium payments, and auditing coverage periods. A typical query might join this table to related objects to produce a comprehensive enrollment report. For example, to list all active COBRA enrollments with their associated benefits, one might use a SQL pattern such as:

  • SELECT pcce.cobra_coverage_enrollment_id,
  • pcce.coverage_start_date,
  • pcr.full_name,
  • pccbf.benefit_name
  • FROM per_cobra_cov_enrollments pcce,
  • per_contact_relationships pcr,
  • per_cobra_coverage_benefits_f pccbf
  • WHERE pcce.contact_relationship_id = pcr.contact_relationship_id
  • AND pcce.cobra_coverage_enrollment_id = pccbf.cobra_coverage_enrollment_id
  • AND SYSDATE BETWEEN pcce.coverage_start_date AND NVL(pcce.coverage_end_date, SYSDATE);

Related Objects

As indicated by its foreign key relationships, PER_COBRA_COV_ENROLLMENTS is a pivotal hub within the COBRA data model. It is referenced as a parent table by several key transactional tables: PER_COBRA_COVERAGE_BENEFITS_F stores the specific benefits enrolled under the coverage; PER_COBRA_DEPENDENTS_F holds information on covered dependents; PER_COBRA_COVERAGE_STATUSES tracks the history of status changes (e.g., elected, terminated); and PER_SCHED_COBRA_PAYMENTS manages the payment schedule for premiums. Furthermore, it references master tables like PER_TIME_PERIOD_TYPES for the coverage period and HR_ALL_ORGANIZATION_UNITS for the business group context.