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.