COVERAGE_SPONSOR

Description: |
This table contains information about who is sponsoring this coverage for the subscriber, such as current employment. Changes to this information are tracked over time for informational purposes, though just the latest values are actively used. Each row in this table for a coverage represents one date range with the values of the sponsor information fields effective during that date range.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CVG_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CVG_ID | NUMERIC | No |
The unique ID of the coverage record for this row. This column is frequently used to link to the COVERAGE table.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | SPONSR_EFF_FROM_DT | DATETIME | No |
Covered through (I CVG 206) and Employer Size (I CVG 207) are tracked over time since they can affect filing order and MSP logic. When either of those items are changed, a new line is added to this related group using today's date for this item and the new values for the other two items.
4 | COVERED_THROUGH_C_NAME | VARCHAR | No |
Covered through current employment, retirement, COBRA, or other. Affects filing order calculation and is used for Medicare Secondary Payor.
May contain organization-specific values: Yes
Category Entries:
Other
Current Employment
Retirement
COBRA / Continuation of Benefits
5 | EMPLOYER_SIZE_C_NAME | VARCHAR | No |
Number of employees for the employer that sponsors this coverage. Used as part of Medicare Secondary Payor determination.
May contain organization-specific values: No
Category Entries:
1-19 Employees
20-99 Employees
100+ Employees
6 | SPONSOR_EFF_TO_DT | DATETIME | No |
Covered through (I CVG 206) and Employer Size (I CVG 207) are tracked over time since they can affect filing order and MSP logic. When either of those items are changed, a new line is added to this related group, and the previous line is given yesterday's date as the effective to date.