Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Chart_Alert
Touchworks 25.2
[dbo].[Patient_Chart_Alert]
MS_Description
Chart Alerts displayed in the patient banner
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Patient_Chart_Alert Table
CreatedByID
[dbo].[uniqueid]
9
NOT NULL
UserID of creating user. Link to IDX_User.ID
LastUpdatedByID
[dbo].[uniqueid]
9
NOT NULL
UserID of last editting user. Link to IDX_User.ID
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient Alert Exists On. Link to Person.ID
ChartAlertDE
[dbo].[dict_id]
5
NOT NULL
Chart Alert Dictionary Entry. Link to Chart_Alert_DE.ID
ChartAlert
varchar(70)
70
NOT NULL
Chart Alert Text
StartDTTM
datetime
8
NOT NULL
Alert Start Effective Datetime
EndDTTM
datetime
8
NOT NULL
Alert End Effective Datetime
(2)
IsInactiveFLAG
[dbo].[BOOL]
1
NOT NULL
Active/Inactive indicator for the Alert
ChartAlertDetails
varchar(7500)
7500
NOT NULL
NOT USED
AlertSequence
smallint
2
NOT NULL
((0))
Sequence for Alerts to be diplsyed on UI.
QODEID
[dbo].[dict_id]
5
NULL allowed
Resultable item that create the alert
ItemID
[dbo].[uniqueid]
9
NULL allowed
Result that created the alert. Link to Item_Result.ID