Tables [CDS].[RecommendationHistory]
recommendations that are no longer active
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PKRecommendationHistory: IDIDvarchar(40)40NOT NULLKey to the RecommendationHistory table
Indexes IDX_RecommendationHistory_PatientIDPatientIDvarchar(40)40NOT NULLpatient identification
PatientNamevarchar(50)50NULL allowedpatient  name optional
PatientMRNvarchar(40)40NULL allowedpatient identification
PatientDOBdatetime8NULL allowedDate of Birth
PatientGendervarchar(1)1NULL allowedGender
Descriptionvarchar(800)800NOT NULLRecommendation Text
Notesvarchar(max)maxNULL allowednot used
DateTimedatetime8NOT NULLdate and time recommendation received
StatusIDvarchar(3)3NOT NULLACT - should always be ACT. Link to Status.ID
SeverityIDvarchar(3)3NOT NULLSeverity. Link to Severity.ID
Priorityint4NOT NULL((50))always 50