Project
>
Touchworks
>
User databases
>
WorksCDSAggregatorArchive
>
Tables
> CDS.RecommendationAssertionHistory
Touchworks 25.2
[CDS].[RecommendationAssertionHistory]
MS_Description
table of assertions associated to recommendation history
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ID
varchar(40)
40
NOT NULL
Key to the RecommendationAssertionHistory table
RecommendationID
varchar(40)
40
NOT NULL
Recommendation. Link to RecommendationHistory.ID
Description
varchar(800)
800
NOT NULL
description of the assertion returned
Notes
varchar(max)
max
NULL allowed
NA
TypeID
varchar(3)
3
NOT NULL
Assertion type: MDT (missing data), CMP (composite), OOR (out of range). Link to DistositionType.ID
CodeSet
varchar(50)
50
NOT NULL
code set type
Code
varchar(50)
50
NOT NULL
code
NegationInd
bit
1
NOT NULL
((0))
NA
SectionType
int
4
NOT NULL
((0))
type identifier to tell what the assertion is to be used for
CompositionType
int
4
NULL allowed
NA