Project
>
Touchworks
>
User databases
>
WorksCDSAggregatorArchive
>
Tables
> CDS.RecommendationReferenceHistory
Touchworks 25.2
[CDS].[RecommendationReferenceHistory]
MS_Description
References associated with the recommendationHistory where additional information can be found on the recommendation
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ID
int
4
NOT NULL
Key to the RecommendationReferenceHistory table
RecommendationID
varchar(40)
40
NOT NULL
Recommendation. Link to RecommendationHistory.ID
Description
varchar(max)
max
NOT NULL
description of the link to find additional information
Uri
varchar(max)
max
NULL allowed
url of the party
Name
varchar(200)
200
NULL allowed
NA