Project
>
Touchworks
>
User databases
>
Works
>
Tables
> CDS.AppliedRecommendationDisposition
Touchworks 25.2
[CDS].[AppliedRecommendationDisposition]
MS_Description
Audit of the disposition returned for a recommendation
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
int
4
NOT NULL
1 - 1
Identity column
RecommendationID
varchar(40)
40
NOT NULL
Recommendation. Link to Recommendation.ID
AppliedProviderID
varchar(40)
40
NULL allowed
participant id of applied disposition
AppliedUserID
varchar(40)
40
NULL allowed
user id of applied disposition
DispositionTypeID
varchar(3)
3
NOT NULL
from disposition type used to identity what type of disp was applied. Link to DispositionType.ID
DispositionID
int
4
NOT NULL
recommendation disposition. Link to recommendationdisposition.ID
SourceID
varchar(3)
3
NOT NULL
reason dispon applied, Link to DispositionSource.ID
PatientID
varchar(40)
40
NULL allowed
if disposition was setup on patient id, patient id of the associated disposition configuration
ProviderID
varchar(40)
40
NULL allowed
if disposition was setup on provider id, provider id of the associated disposition configuration
UserID
varchar(40)
40
NULL allowed
if disposition was setup on user id, user id of the associated disposition configuration
EncounterID
varchar(40)
40
NULL allowed
if disposition was setup on encounter id, encounter id of the associated disposition configuration
Since
datetime
8
NOT NULL
date disposition was configured
Until
datetime
8
NULL allowed
date disposition will expire
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
description of disposition reason
Comment
varchar(max)
max
NULL allowed
comment associated to disposition