Project
>
Touchworks
>
User databases
>
Works
>
Tables
> CDS.Recommendation
Touchworks 25.2
[CDS].[Recommendation]
MS_Description
table of active recommendations
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ID
varchar(40)
40
NOT NULL
Key to the Recommendation 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')
Status. Link to Status.ID. ACT - should always be ACT
SeverityID
varchar(3)
3
NOT NULL
('MED')
Severity. Link to Severity.ID
Priority
int
4
NOT NULL
((50))
always 50