Results for “per_cobra_coverage_statuses_v”
20 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.PER_COBRA_COVERAGE_STATUSES_V view is a Human Resources (PER) reporting and user-interface object that exposes COBRA coverage status records together with their decodable status meaning. It belongs to the Consolidated Omnibus Budget Reconciliation Act (COBRA) feature set within Oracle EBS Human Resources, which governs the continuation of health coverage for qualifying beneficiaries following a loss of employment or a reduction in hours. The view is classified as VALID in the APPS schema and its documented purpose is to support the application user interface, meaning it is typically consumed by Oracle Forms, OAF pages, and related UI components rather than by high-volume batch processing.
Its principal value to reporting and integration lies in the STATUS_TYPE_MEANING column, which is not stored on the underlying COBRA coverage status entity but is instead resolved at query time from the HR_LOOKUPS lookup view. This makes the view a convenient single source for status descriptions without requiring the caller to write an explicit join to HR_LOOKUPS. The same definition is present in both Oracle EBS 12.1.1 and 12.2.2; no structural differences between the releases are documented.
Underlying Base Objects
The view is defined over three referenced objects: HR_API (PACKAGE), HR_LOOKUPS (VIEW), and PER_COBRA_COVERAGE_STATUSES (SYNONYM). The view text joins HR_LOOKUPS to PER_COBRA_COVERAGE_STATUSES with the following predicate:
- HR_LOOKUPS.LOOKUP_TYPE = 'US_COBRA_STATUS'
- PER_COBRA_COVERAGE_STATUSES.COBRA_COVERAGE_STATUS_TYPE = HR_LOOKUPS.LOOKUP_CODE
PER_COBRA_COVERAGE_STATUSES is referenced in the FROM clause as a synonym. In the APPS schema this synonym resolves to the underlying PER schema table that stores individual COBRA coverage status rows, including the status type code, effective date, comments, and the standard 20 developer attributes. HR_LOOKUPS is the public lookup view that exposes lookup codes and meanings for all lookup types. HR_API is documented as a referenced object and supplies the business-group and COBRA integration logic used when status records are created or maintained by the UI. Because the meaning is derived from a lookup, the STATUS_TYPE_MEANING text reflects the current meaning of the US_COBRA_STATUS lookup code and may change if the lookup is modified.
Key Columns
- ROW_ID — the ROWID of the underlying PER_COBRA_COVERAGE_STATUSES row, provided for UI row identification.
- COBRA_COVERAGE_STATUS_ID — primary identifier of the COBRA coverage status record.
- BUSINESS_GROUP_ID — the business group to which the status record belongs; exposed as BUSINESS_GROUP_ID + 0 in the view text.
- COBRA_COVERAGE_ENROLLMENT_ID — the COBRA enrollment to which the status applies.
- COBRA_COVERAGE_STATUS_TYPE — the lookup code from the US_COBRA_STATUS lookup type identifying the status.
- STATUS_TYPE_MEANING — the translated meaning of the status type, resolved from HR_LOOKUPS. This is the column most frequently queried by users and reports that need a readable status description.
- EFFECTIVE_DATE — the date from which the status is effective.
- COMMENTS — free-text remarks recorded against the status.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — descriptive flexfield segments for extensibility.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard audit columns.
Common Use Cases and Queries
The view is commonly queried to produce COBRA status reports and to populate interactive UI regions without an explicit lookup join. A typical query follows:
SELECT ccsv.cobra_coverage_status_id,
ccsv.cobra_coverage_enrollment_id,
ccsv.cobra_coverage_status_type,
ccsv.status_type_meaning,
ccsv.effective_date
FROM apps.per_cobra_coverage_statuses_v ccsv
WHERE ccsv.business_group_id = :p_business_group_id
ORDER BY ccsv.effective_date DESC;
Because the view is an equi-join to HR_LOOKUPS, only status rows whose COBRA_COVERAGE_STATUS_TYPE matches an active US_COBRA_STATUS lookup code are returned; status records with orphaned or inactive lookup codes are silently excluded. Queries for audit or data-cleanup purposes should therefore compare the view against PER_COBRA_COVERAGE_STATUSES directly to identify status rows whose lookup code is missing. As the view is documented as supporting the user interface, it is intended for interactive and reporting use rather than high-volume batch extraction.
-
Used to support user interface
APPS.PER_COBRA_COVERAGE_STATUSES_V·↳ HR_API·↳ HR_LOOKUPS·↳ PER_COBRA_COVERAGE_STATUSES·Explore PER module →
-
Used to support user interface
APPS.PER_COBRA_COVERAGE_STATUSES_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_LOOKUPS·Explore PER module →
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
VIEW: APPS.HR_LOOKUPS 12.1.1
-
VIEW: APPS.HR_LOOKUPS 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person