Project
>
Touchworks
>
User databases
>
Works
>
Tables
> CDS.RecommendationTypeDisposition
Touchworks 25.2
[CDS].[RecommendationTypeDisposition]
MS_Description
tracks dispositions associated to an assertion
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
int
4
NOT NULL
1 - 1
Key to the RecommendationTypeDisposition table
PatientID
varchar(40)
40
NULL allowed
patient identification
ProviderID
varchar(40)
40
NULL allowed
participant to apply disposition
UserID
varchar(40)
40
NULL allowed
user to apply disposition
Since
datetime
8
NOT NULL
(CONVERT([datetime],floor(CONVERT([float],getdate(),(0))),(0)))
entered date
Until
datetime
8
NULL allowed
end date
TypeID
varchar(3)
3
NOT NULL
assertion type. Link to RecommendationType.ID
CodeSet
varchar(50)
50
NOT NULL
assertion code set to apply disposition
Code
varchar(50)
50
NOT NULL
assertion code to apply disposition
SeverityID
varchar(3)
3
NULL allowed
NA. Link to Severity.ID
EncounterID
varchar(40)
40
NULL allowed
encounter to apply disposition
StatusID
varchar(3)
3
NOT NULL
disposition status. link to Status.ID
DispositionReasonID
int
4
NULL allowed
Disposition Reason. Link to DispositionReason.ID
ReasonDescription
varchar(200)
200
NULL allowed
disposition reason
NegationInd
bit
1
NOT NULL
((0))
na
Comment
varchar(max)
max
NULL allowed
optional user comment