Results for “per_cobra_coverage_benefits_x”

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

Overview

PER_COBRA_COVERAGE_BENEFITS_X is an APPS-owned date-effective (X) view in the Oracle E-Business Suite Human Resources (PER) product family, documented across ETRM releases 12.1.1 and 12.2.2. It presents Consolidated Omnibus Budget Reconciliation Act (COBRA) coverage benefit records — the individual benefit elections and amounts that qualified beneficiaries retain after a qualifying event such as termination of employment. The view filters the underlying base table so that only rows whose effective date range contains the current system date (TRUNC(SYSDATE)) are returned, making it the standard reporting interface for "as of today" COBRA coverage data.

Because of this effective-date restriction, the view is intended for transactional reporting, concurrent program data sources, and integration extracts where the caller expects exactly one active version of each COBRA coverage benefit record. Historical or future-dated coverage rows must be retrieved from the base table rather than this view. The view is relevant to the search term "coverage_amount" because that column is exposed directly and represents the elected or employer-contributed monetary amount of the COBRA coverage.

Underlying Base Objects

The view is defined over a single documented base object, PER_COBRA_COVERAGE_BENEFITS_F (referenced through a synonym). The "_F" suffix denotes the base (non-translated, full) table that stores all dated rows for COBRA coverage benefits, including their EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. The "_X" view is a thin projection of that table: it selects the same column list without transformation and applies only the date-effective WHERE clause:

• PER_COBRA_COVERAGE_BENEFITS_F — the sole referenced table, holding every effective-dated COBRA coverage benefit row.
• PER_COBRA_COVERAGE_BENEFITS_X — the runtime view that returns only the row(s) currently in effect.

The status of the view is VALID, so it can be queried directly by reporting tools, PL/SQL, and EBS concurrent programs with no compilation concerns.

Key Columns

• COBRA_COVERAGE_BENEFIT_ID — primary identifier for the coverage benefit record.
• COBRA_COVERAGE_ENROLLMENT_ID — links the benefit line to its parent COBRA coverage enrollment.
• ELEMENT_TYPE_ID — identifies the payroll/benefit element type associated with the coverage, tying the record to compensation setup.
• COVERAGE_AMOUNT — the monetary amount of the COBRA coverage; this is the column most frequently referenced in reporting and extracts.
• COVERAGE_TYPE — classifies the coverage (for example, the benefit or plan category).
• ACCEPT_REJECT_FLAG — indicates whether the beneficiary accepted or declined the coverage.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-effective boundaries used by the view's filter predicate.
• BUSINESS_GROUP_ID — the HR business group, providing organizational partitioning.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — descriptive flexfield segments for customer-specific data.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include verifying current COBRA coverage amounts for a beneficiary, reconciling accepted coverage against payroll element entries, and extracting active coverage for interfaces. The following queries illustrate standard usage:

• Retrieve all active COBRA coverage benefits for a business group:

SELECT cobra_coverage_benefit_id, cobra_coverage_enrollment_id, element_type_id, coverage_type, coverage_amount, accept_reject_flag FROM per_cobra_coverage_benefits_x WHERE business_group_id = :p_business_group_id;

• Isolate accepted coverage with a specific amount for audit:

SELECT cobra_coverage_enrollment_id, coverage_type, coverage_amount FROM per_cobra_coverage_benefits_x WHERE accept_reject_flag = 'A' AND coverage_amount > 0;

• Join to enrollment-level data to report beneficiary coverage amounts:

SELECT b.cobra_coverage_benefit_id, b.coverage_amount, b.coverage_type FROM per_cobra_coverage_benefits_x b, per_cobra_coverage_enrollments_x e WHERE b.cobra_coverage_enrollment_id = e.cobra_coverage_enrollment_id;

Because the view always evaluates TRUNC(SYSDATE), callers requiring date-parameterized results should query PER_COBRA_COVERAGE_BENEFITS_F with explicit effective-date predicates.