Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.UnverifiedItem_Problem
Touchworks 25.2
[dbo].[UnverifiedItem_Problem]
MS_Description
Unverified Probem
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
UnverifiedItemID
[dbo].[uniqueid]
9
NOT NULL
Unverified Item Identifier. Link to Unverified_Item.ID
OnsetFuzzyWhen
varchar(50)
50
NULL allowed
Onset Fuzzy date
OnsetFuzzySortAs
datetime
8
NULL allowed
Onset date
OnsetFuzzySpecificity
char(1)
1
NULL allowed
Onset Date Type
'D' - Date
'F' - Fuzzy Date
ProblemDescription
varchar(600)
600
NULL allowed
Problem Description
ResolvedFuzzyWhen
varchar(50)
50
NULL allowed
Resolved Fuzzy date
ResolvedFuzzySortAs
datetime
8
NULL allowed
Resolved Date
ResolvedFuzzySpecificity
char(1)
1
NULL allowed
Resolved Date Type
'D' - Date
'F' - Fuzzy Date
ICD9DiagnosisCode
[dbo].[code]
10
NULL allowed
Imported problem's ICD9DiagnosisCode
ICD10DiagnosisCode
[dbo].[code]
10
NULL allowed
Imported problem's ICD10DiagnosisCode
Snomed3CODE
varchar(18)
18
NOT NULL
Imported problem's Snomed code
ClinicalSeverityDE
[dbo].[dict_id]
5
NOT NULL
((0))
Clinical Severity. Link to Clinical_Severity_DE.ID.
ManagedBy
varchar(80)
80
NOT NULL
('')
Managed By Provider
ImpressionText
varchar(2000)
2000
NOT NULL
('')
Impression Text