Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Charge_Diagnosis_Detail
Touchworks 25.2
[dbo].[Charge_Diagnosis_Detail]
MS_Description
primary and secondary (ICD9 and ICD10) charge diagnosis codes
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ChargeDiagnosisID
[dbo].[uniqueid]
9
NOT NULL
Charge Diagnosis. Links to Charge_Diagnosis.ID
ICDDiagnosisCode
varchar(10)
10
NOT NULL
ICD9 or ICD10 Diagnosis Code
ICDDiagnosisType
varchar(10)
10
NOT NULL
Diagnosis Type ('ICD9' or 'ICD10')
Level
smallint
2
NULL allowed
Code Level.
0 - Base DX Code
1- Primary DX Code
2- Secondary DX Code