Tables [CDS].[RecommendationAssertion]
table of assertions associated to recommendation
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PKRecommendationAssertion: IDIDvarchar(40)40NOT NULLKey to the RecommendationAssertion table
Indexes IDX_RecommendationAssertion_RecommendationIDForeign Keys FKRecommendationAssertionRecommendation: [CDS].[Recommendation].RecommendationIDRecommendationIDvarchar(40)40NOT NULLRecommendation. Link to Recommendation.ID
Descriptionvarchar(800)800NOT NULLdescription of the assertion returned
Notesvarchar(max)maxNULL allowedNA
Indexes IDX_RecommendationAssertion_TypeIDForeign Keys FKRecommendationAssertionRecommendationType: [CDS].[RecommendationType].TypeIDTypeIDvarchar(3)3NOT NULLAssertion type: MDT (missing data), CMP (composite), OOR (out of range). Link to RecommendationType.ID
CodeSetvarchar(50)50NOT NULLcode set type
Codevarchar(50)50NOT NULLcode
NegationIndbit1NOT NULL((0))NA
SectionTypeint4NOT NULL((0))type identifier to tell what the assertion is to be used for
CompositionTypeint4NULL allowedNA