Search Results cobra_dependent_id




Overview
Explore in AI Chat

Overview

The PER_COBRA_DEPENDENTS_F table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the system of record for tracking which employee dependents are covered under a COBRA (Consolidated Omnibus Budget Reconciliation Act) qualifying event. When an employee experiences a qualifying event, such as termination or reduction in hours, this table records the dependent-level enrollment details, enabling the organization to manage and administer legally mandated continuation of health benefits. Its role is critical for compliance, benefits administration, and generating accurate COBRA eligibility notices.

Key Information Stored

The table is structured as an effective-dated object, using START_DATE and END_DATE columns to maintain a history of dependent coverage status over time. The primary identifier is the COBRA_DEPENDENT_ID. The two most significant foreign key columns define its core relationships: COBRA_COVERAGE_ENROLLMENT_ID links the dependent to a specific COBRA coverage enrollment record for the primary employee, while CONTACT_RELATIONSHIP_ID uniquely identifies the dependent by linking to the system's master list of employee contacts and relationships. The presence of a unique key (PER_COBRA_DEPENDENTS_UK) on these two columns, along with the effective dates, ensures that a dependent cannot be enrolled more than once for the same coverage period.

Common Use Cases and Queries

This table is central to COBRA administration processes. Common use cases include generating a list of all dependents eligible for continuation coverage following a specific qualifying event, auditing dependent enrollment history, and producing data feeds for third-party COBRA administrators. A typical reporting query would join this table to its parent enrollment and contact relationship tables to produce a comprehensible list. For example:

  • Identifying all covered dependents for a given employee's COBRA event: SELECT pcd.COBRA_DEPENDENT_ID, pcr.FULL_NAME FROM PER_COBRA_DEPENDENTS_F pcd JOIN PER_CONTACT_RELATIONSHIPS pcr ON pcd.CONTACT_RELATIONSHIP_ID = pcr.CONTACT_RELATIONSHIP_ID WHERE pcd.COBRA_COVERAGE_ENROLLMENT_ID = <enrollment_id> AND SYSDATE BETWEEN pcd.EFFECTIVE_START_DATE AND pcd.EFFECTIVE_END_DATE;
  • Historical reporting on dependent coverage periods for audit purposes.
  • Integration with benefits and payroll systems to terminate active coverage and initiate COBRA billing.

Related Objects

The PER_COBRA_DEPENDENTS_F table has defined foreign key relationships with two primary parent tables, forming a key part of the COBRA data model.

  • PER_COBRA_COV_ENROLLMENTS: This is the parent table for the employee's overall COBRA coverage enrollment. The relationship is established via the column PER_COBRA_DEPENDENTS_F.COBRA_COVERAGE_ENROLLMENT_ID.
  • PER_CONTACT_RELATIONSHIPS: This master table stores all personal contact information for employees, including their dependents. The relationship is established via the column PER_COBRA_DEPENDENTS_F.CONTACT_RELATIONSHIP_ID, which links to the specific dependent record.

These relationships ensure data integrity, as a dependent cannot be enrolled in COBRA without a valid, pre-existing enrollment record and a defined relationship to the employee.