Project
>
Touchworks
>
User databases
>
Works
>
Tables
> CDS.RecommendationHistory
Touchworks 25.2
[CDS].[RecommendationHistory]
MS_Description
recommendations that are no longer active
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ID
varchar(40)
40
NOT NULL
Key to the RecommendationHistory table
PatientID
varchar(40)
40
NOT NULL
patient identification
PatientName
varchar(50)
50
NULL allowed
patient name optional
PatientMRN
varchar(40)
40
NULL allowed
patient identification
PatientDOB
datetime
8
NULL allowed
Date of Birth
PatientGender
varchar(1)
1
NULL allowed
Gender
Description
varchar(800)
800
NOT NULL
Recommendation Text
Notes
varchar(max)
max
NULL allowed
not used
DateTime
datetime
8
NOT NULL
date and time recommendation received
StatusID
varchar(3)
3
NOT NULL
ACT - should always be ACT. Link to Status.ID
SeverityID
varchar(3)
3
NOT NULL
Severity. Link to Severity.ID
Priority
int
4
NOT NULL
((50))
always 50