Tables [CDS].[RecommendationAssertionHistory]
table of assertions associated to recommendation history
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PKRecommendationAssertionHistory: IDIDvarchar(40)40NOT NULLKey to the RecommendationAssertionHistory table
Indexes IDX_RecommendationAssertionHistory_RecommendationIDForeign Keys FKRecommendationAssertionHistoryRecommendationHistory: [CDS].[RecommendationHistory].RecommendationIDRecommendationIDvarchar(40)40NOT NULLRecommendation. Link to RecommendationHistory.ID
Descriptionvarchar(800)800NOT NULLdescription of the assertion returned
Notesvarchar(max)maxNULL allowedNA
TypeIDvarchar(3)3NOT NULLAssertion type: MDT (missing data), CMP (composite), OOR (out of range). Link to DistositionType.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