Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Injury_Information
Touchworks 25.2
[dbo].[Injury_Information]
MS_Description
Special Billing Details
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
(2)
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Injury_Information table
(2)
PlaceofInjuryDE
[dbo].[dict_id]
5
NOT NULL
Location of injury - links to Place_of_injury_DE.ID
InjuryTypeDE
[dbo].[dict_id]
5
NOT NULL
Special Billing (Workers Comp, Auto, etc) - links to Injury_Type_DE.ID
InjuryDT
datetime
8
NOT NULL
Date of Injury
(2)
Comment
[dbo].[message]
255
NOT NULL
General comment field
EncounterID
[dbo].[uniqueid]
9
NOT NULL
(0)
EncounterID linked to this injury - links to Encounter.ID
AccountDescription
varchar(255)
255
NULL allowed
General description of account tied to this injury (Comp, Auto Claim, etc)
AccountNumber
varchar(20)
20
NULL allowed
Account number tied to this injury