Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Encounter_Diagnosis_Detail
Touchworks 25.2
[dbo].[Encounter_Diagnosis_Detail]
MS_Description
primary and secondary ICD9 and ICD10 diagnosis codes for an encounter
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
EncounterDiagnosisID
[dbo].[uniqueid]
9
NOT NULL
Diagnosis. Links to Encounter_Diagnosis.ID
ICDDiagnosisCode
varchar(10)
10
NOT NULL
ICD9 or ICD10 Diagnosis Code
ICDDiagnosisType
varchar(5)
5
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