Search Results per_sched_cobra_payments_pk

Overview

The table PER_SCHED_COBRA_PAYMENTS is a core transactional data store within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically for the management of Consolidated Omnibus Budget Reconciliation Act (COBRA) benefits. Its primary role is to record and track the payment schedule for COBRA continuation coverage premiums. When a qualified beneficiary elects COBRA coverage, the system generates one or more payment records in this table, detailing the amounts due and their corresponding due dates. This table is critical for ensuring compliance with COBRA regulations, enabling the generation of billing notices, and tracking payment statuses for administrative reporting.

Key Information Stored

The table stores the financial schedule for each COBRA coverage enrollment. Key columns, as indicated by the primary and foreign keys, include:

• SCHEDULED_COBRA_PAYMENT_ID: The unique primary key identifier for each payment schedule record.
• COBRA_COVERAGE_ENROLLMENT_ID: A foreign key linking the payment to a specific COBRA enrollment in the PER_COBRA_COV_ENROLLMENTS table. This column is part of a unique key constraint (PER_SCHED_COBRA_PAYMENTS_UK2) with DATE_DUE, ensuring no duplicate payment dates for a single enrollment.
• DATE_DUE: The calendar date on which the premium payment is required.
• BUSINESS_GROUP_ID: A foreign key to HR_ALL_ORGANIZATION_UNITS, securing the data within the appropriate business group or legal entity as per Oracle HRMS's multi-org security model.

While the provided metadata does not list all columns, typical data in such a table would also include the payment amount, a status flag (e.g., 'PENDING', 'PAID', 'OVERDUE'), and possibly fields for recording actual payment receipt.

Common Use Cases and Queries

This table is central to COBRA billing and compliance operations. Common use cases include generating dunning notices for overdue payments, producing reports on accounts receivable for COBRA premiums, and validating payment history during coverage termination events. A typical reporting query might join this table to enrollment and beneficiary information to list all upcoming or overdue payments.

SELECT scp.scheduled_cobra_payment_id,
       scp.date_due,
       scp.amount_due,
       pce.enrollment_date,
       ppf.full_name beneficiary_name
FROM   per_sched_cobra_payments scp,
       per_cobra_cov_enrollments pce,
       per_all_people_f ppf
WHERE  scp.cobra_coverage_enrollment_id = pce.cobra_coverage_enrollment_id
AND    pce.person_id = ppf.person_id
AND    scp.date_due BETWEEN SYSDATE AND SYSDATE + 30
AND    scp.payment_status = 'PENDING'
AND    ppf.effective_end_date > SYSDATE;

Related Objects

PER_SCHED_COBRA_PAYMENTS has defined relationships with several key HR objects, forming a critical part of the COBRA data model.

• PER_COBRA_COV_ENROLLMENTS: This is the primary parent table, via the foreign key on COBRA_COVERAGE_ENROLLMENT_ID. It holds the master record of the beneficiary's election of COBRA coverage.
• HR_ALL_ORGANIZATION_UNITS: The relationship via BUSINESS_GROUP_ID anchors the payment data to the correct organizational context for security and reporting.
• Primary Key: PER_SCHED_COBRA_PAYMENTS_PK (on SCHEDULED_COBRA_PAYMENT_ID).
• Unique Key: PER_SCHED_COBRA_PAYMENTS_UK2 (on COBRA_COVERAGE_ENROLLMENT_ID, DATE_DUE).