PAT_ENC_MSP_WC

Description:

This table contains the Worker's Compensation Info part of the Medicare Secondary Payor Information from the Patient (EPT) master file.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_CSN_ID	NUMERIC	No
	A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
2	CONTACT_DATE	DATETIME	No
	The date (calendar format) on which the encounter took place.
3	WORKERS_COMP_YN	VARCHAR	No
	YES if the illness or injury is covered by a workers' compensation claim. May contain organization-specific values: No Category Entries: Yes No
4	WC_ACCDNT_DATE	DATETIME	No
	Injury date of the work related accident.
5	WC_CLAIM_NUMBER	VARCHAR	No
	Worker's compensation claim number.
6	WC_POLICY_NUMBER	VARCHAR	No
	Policy number of the workers' compensation coverage for the accident.
7	WC_EMPLR_NAME	VARCHAR	No
	If the accident occurred at work, enter the place of employment.
8	WC_EMPLR_ADR_1	VARCHAR	No
	Line 1 of worker's compensations' employer's street address.
9	WC_EMPLR_ADR_2	VARCHAR	No
	Line 2 of worker's compensations' employer's street address.
10	WC_EMPLR_CITY	VARCHAR	No
	Worker's compensation employer's city
11	WC_EMPLR_ZIP	VARCHAR	No
	Worker's compensation employer's Zip.
12	WC_PLAN_NAME	VARCHAR	No
	Worker's compensation insurance plan name.
13	WC_PLAN_ADR_1	VARCHAR	No
	Line 1 of the street address for the worker's compensation plan.
14	WC_PLAN_ADR_2	VARCHAR	No
	Line 2 of the street address for the worker's compensation plan.
15	WC_PLAN_CITY	VARCHAR	No
	Insurance company's city.
16	WC_PLAN_ZIP	VARCHAR	No
	Insurance company's ZIP Code