Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Encounter_Workers_Comp
Touchworks 25.2
[dbo].[Encounter_Workers_Comp]
MS_Description
Workers Comp information for the encounter
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
Employeer
varchar(255)
255
NULL allowed
Empolyer
ContactPerson1
varchar(255)
255
NULL allowed
Contact Person
ContactPersonPhone1
varchar(25)
25
NULL allowed
Contact Person Phone
ContactPersonFax1
varchar(25)
25
NULL allowed
Contact Person Fax
DateOfInjury
datetime
8
NULL allowed
Injury Date
InsuranceClassDE
[dbo].[dict_id]
5
NOT NULL
Insurance. Link to Insurance_Class_DE.ID
ContactPerson2
varchar(255)
255
NULL allowed
Contact Person 2
ContactPersonPhone2
varchar(25)
25
NULL allowed
Contact Person 2 Phone
ContactPersonFax2
varchar(25)
25
NULL allowed
Contact Person 2 Fax
CaseManager
varchar(255)
255
NULL allowed
Case Manger Name
CaseManagerPhone
varchar(25)
25
NULL allowed
Case Manager Phone Number
CaseManagerFax
varchar(25)
25
NULL allowed
Case Manager Fax