Project
>
Touchworks
>
User databases
>
Works
>
Tables
> CDS.RecommendationAssertion
Touchworks 25.2
[CDS].[RecommendationAssertion]
MS_Description
table of assertions associated to recommendation
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ID
varchar(40)
40
NOT NULL
Key to the RecommendationAssertion table
RecommendationID
varchar(40)
40
NOT NULL
Recommendation. Link to Recommendation.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 RecommendationType.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