Tables [CDS].[Recommendation]
table of active recommendations
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PKRecommendation: IDIDvarchar(40)40NOT NULLKey to the Recommendation table
Indexes IDX_Recommendation_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
Indexes IDX_Recommendation_StatusIDForeign Keys FKRecommendationStatus: [CDS].[Status].StatusIDStatusIDvarchar(3)3NOT NULL('ACT')Status. Link to Status.ID. ACT - should always be ACT
Indexes IDX_Recommendation_SeverityIDForeign Keys FKRecommendationSeverity: [CDS].[Severity].SeverityIDSeverityIDvarchar(3)3NOT NULL('MED')Severity. Link to Severity.ID
Priorityint4NOT NULL((50))always 50