Tables [CDS].[RecommendationSourceHistory]
indentifies the rule(s) and participant(s) that triggered the recommendation.  Child of recommendations in the history table
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PKRecommendationSourceHistory: IDIDbigint8NOT NULLKey to the RecommendationSourceHistory table
Indexes IDX_RecommendationSourceHistory_PatientEncounter, IDX_RecommendationSourceHistory_Recommendation(2)Foreign Keys FKRecommendationSourceHistoryRecommendationHistory: [CDS].[RecommendationHistory].RecommendationIDRecommendationIDvarchar(40)40NOT NULLRecommendation. Link to RecommendationHistory.ID
RuleIDvarchar(40)40NOT NULLrule id that triggered recommendation
RuleNamevarchar(50)50NOT NULLname of rule that triggered recommendation
RuleSetIDvarchar(40)40NULL alloweddeprecated
RuleSetNamevarchar(50)50NULL alloweddeprecated
RuleAgentIDvarchar(40)40NOT NULLid of the rule agent that returned recommendation
RuleAgentNamevarchar(50)50NOT NULLname of agent
SubscriptionSourcevarchar(50)50NOT NULLalways program measure
Indexes IDX_RecommendationSourceHistory_PatientEncounterPatientIDvarchar(40)40NULL allowedid of the patient from recommendation
Indexes IDX_RecommendationSourceHistory_PatientEncounterProviderIDvarchar(40)40NULL allowedparticipant id that triggered recommendation
Indexes IDX_RecommendationSourceHistory_PatientEncounterEncounterIDvarchar(40)40NULL allowedencounter id
Indexes IDX_RecommendationSourceHistory_PatientEncounterDateTimedatetime8NOT NULLdate time recommendation triggered
StatusIDvarchar(3)3NOT NULLstatus. Link to Source.StatusID
RuleVersionint4NOT NULL((1))version of the rule that triggered recommendation