Tables [dbo].[Patient_Chart_Alert]
Chart Alerts displayed in the patient banner
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Patient_Chart_Alert: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Patient_Chart_Alert Table
Foreign Keys FK_Patient_Chart_Alert_Created_By_ID: [dbo].[IDX_User].CreatedByIDCreatedByID[dbo].[uniqueid]9NOT NULLUserID of creating user. Link to IDX_User.ID
Foreign Keys FK_Patient_Chart_Alert_Last_Updated_By_ID: [dbo].[IDX_User].LastUpdatedByIDLastUpdatedByID[dbo].[uniqueid]9NOT NULLUserID of last editting user. Link to IDX_User.ID
Indexes NIX_Patient_Chart_Alert_PatientID_INC_ChartAlert_IsInactiveFLAGForeign Keys FK_Patient_Chart_Alert_Patient_ID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient Alert Exists On. Link to Person.ID
Indexes TWstat_Patient_Chart_Alert_ChartAlertDEForeign Keys FK_Patient_Chart_Alert_Chart_Alert_DE: [dbo].[Chart_Alert_DE].ChartAlertDEChartAlertDE[dbo].[dict_id]5NOT NULLChart Alert Dictionary Entry. Link to Chart_Alert_DE.ID
Indexes NIX_Patient_Chart_Alert_PatientID_INC_ChartAlert_IsInactiveFLAGChartAlertvarchar(70)70NOT NULLChart Alert Text
StartDTTMdatetime8NOT NULLAlert Start Effective Datetime
EndDTTMdatetime8NOT NULLAlert End Effective Datetime
Indexes NIX_Patient_Chart_Alert_PatientID_INC_ChartAlert_IsInactiveFLAG, TWstat_Patient_Chart_Alert_IsInactiveFLAG(2)Check Constraints CK_Patient_Chart_Alert_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLActive/Inactive indicator for the Alert
ChartAlertDetailsvarchar(7500)7500NOT NULLNOT USED
AlertSequencesmallint2NOT NULL((0))Sequence for Alerts to be diplsyed on UI.
QODEID[dbo].[dict_id]5NULL allowedResultable item that create the alert
ItemID[dbo].[uniqueid]9NULL allowedResult that created the alert. Link to Item_Result.ID