Tables [CDS].[RecommendationSource]
indentifies the rule(s) and participant(s) that triggered the recommendation
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PKRecommendationSource: IDIDbigint8NOT NULL1 - 1Key to the RecommendationSource table
Indexes IDX_RecommendationSource_Recommendation, IDX_RecommendationSource_RuleID(2)Foreign Keys FKRecommendationSourceRecommendation: [CDS].[Recommendation].RecommendationIDRecommendationIDvarchar(40)40NOT NULLRecommendation. Link to Recommendation.ID
Indexes IDX_RecommendationSource_Recommendation, IDX_RecommendationSource_RuleID(2)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_RecommendationSource_PatientIDPatientIDvarchar(40)40NULL allowedid of the patient from recommendation
Indexes IDX_RecommendationSource_PatientIDProviderIDvarchar(40)40NULL allowedparticipant id that triggered recommendation
EncounterIDvarchar(40)40NULL allowedencounter id
DateTimedatetime8NOT NULLdate time recommendation triggered
Foreign Keys FKRecommendationSourceSourceStatus: [CDS].[SourceStatus].StatusIDStatusIDvarchar(3)3NOT NULL('ACT')Status. Link to Source.StatusID
RuleVersionint4NOT NULL((1))version of the rule that triggered recommendation