Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.ICD10_Diagnosis_DE
Touchworks 25.2
[dbo].[ICD10_Diagnosis_DE]
MS_Description
ICD10 diagnosis codes
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[dict_id]
5
NOT NULL
1 - 1
Key to ICD10_Diagnosis_DE table
EnterpriseEntryID
[dbo].[uniqueid]
9
NOT NULL
Key to the dictionary_Entry table. This is a unique identifier across all dictionaries.
DefinitionSetID
[dbo].[dict_id]
5
NOT NULL
Dictionary Subset as defined in the Dict_Definition_Set table.
Entry
[dbo].[dict_id]
5
NOT NULL
Entry number within the Definition Set
(3)
EntryCode
[dbo].[code]
10
NOT NULL
Entry Code. This is the actual ICD10 code
(3)
EntryName
[dbo].[name]
255
NOT NULL
Entry Name
(3)
EntryMnemonic
[dbo].[code]
10
NOT NULL
Entry Mnemonic
(3)
IsInactiveFLAG
[dbo].[BOOL]
1
NOT NULL
Is the entry inactive (Y/N)?
IsEnforcedFLAG
[dbo].[BOOL]
1
NOT NULL
Is the entry Enforced (Y/N)? Enforced entries can not be modified by the application.
(3)
IsCurrentFLAG
[dbo].[BOOL]
1
NOT NULL
Is the entry Current (Y/N)?
EffectiveDT
datetime
8
NULL allowed
Effective Date. This is the last edited date.
InjuryTypeReqFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Is an Injury Type Required? Y or N (For billing purposes)
Specificity
tinyint
1
NOT NULL
((0))
Specificity value
BillingStartDate
datetime
8
NULL allowed
Billing Start Date
BillingEndDate
datetime
8
NULL allowed
Billing End Date
ObsoleteDate
datetime
8
NULL allowed
Term valid to date