Project
>
Touchworks
>
User databases
>
Works
>
Tables
> CDS.RecommendationPartyHistory
Touchworks 25.2
[CDS].[RecommendationPartyHistory]
MS_Description
Parties associated with the recommendation history that detail the sponsor, author and source of the recommendation. Source is used to track where the logic for the rule was derived
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ID
int
4
NOT NULL
Key to the RecommendationPartyHistory table
RecommendationID
varchar(40)
40
NOT NULL
Recommendation. Link to RecommendationHistory.ID
Name
varchar(50)
50
NOT NULL
name of the party associated to rule
RoleID
varchar(3)
3
NOT NULL
Role. Link to Role.ID
URI
varchar(max)
max
NULL allowed
url of the party