Project
>
Touchworks
>
User databases
>
Works
>
Tables
> CDS.RecommendationSourceHistory
Touchworks 25.2
[CDS].[RecommendationSourceHistory]
MS_Description
indentifies the rule(s) and participant(s) that triggered the recommendation. Child of recommendations in the history table
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ID
bigint
8
NOT NULL
Key to the RecommendationSourceHistory table
(2)
RecommendationID
varchar(40)
40
NOT NULL
Recommendation. Link to RecommendationHistory.ID
RuleID
varchar(40)
40
NOT NULL
rule id that triggered recommendation
RuleName
varchar(50)
50
NOT NULL
name of rule that triggered recommendation
RuleSetID
varchar(40)
40
NULL allowed
deprecated
RuleSetName
varchar(50)
50
NULL allowed
deprecated
RuleAgentID
varchar(40)
40
NOT NULL
id of the rule agent that returned recommendation
RuleAgentName
varchar(50)
50
NOT NULL
name of agent
SubscriptionSource
varchar(50)
50
NOT NULL
always program measure
PatientID
varchar(40)
40
NULL allowed
id of the patient from recommendation
ProviderID
varchar(40)
40
NULL allowed
participant id that triggered recommendation
EncounterID
varchar(40)
40
NULL allowed
encounter id
DateTime
datetime
8
NOT NULL
date time recommendation triggered
StatusID
varchar(3)
3
NOT NULL
status. Link to Source.StatusID
RuleVersion
int
4
NOT NULL
((1))
version of the rule that triggered recommendation