Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Alert_Deferral
Touchworks 25.2
[dbo].[Patient_Alert_Deferral]
MS_Description
Deferred Patient Alert from Patient Query
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient ID. Link to Person.ID
QueryID
[dbo].[uniqueid]
9
NOT NULL
Query. Link to Query.ID
StartDTTM
datetime
8
NOT NULL
Start Date and Time
EndDTTM
datetime
8
NOT NULL
End Date and Time
UserID
[dbo].[uniqueid]
9
NOT NULL
User. Link to IDX_User.ID
DeferralReason
varchar(255)
255
NOT NULL
Alert Deferred Reason