Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Problem_ICDCode
Touchworks 25.2
[dbo].[Problem_ICDCode]
MS_Description
Table to Link ICD codes to Problems.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ProblemID
[dbo].[uniqueid]
9
NOT NULL
Key to the Problem table
ICDCodeType
varchar(10)
10
NOT NULL
ICD Code Type (ICD9CM or ICD10CM)
Level
tinyint
1
NOT NULL
Linked Level
0 - Primary code
1 - Additional Primary code
2 - Secondary code
ICDCode
varchar(10)
10
NOT NULL
ICD Code