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