Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Problem_Link_Alert
Touchworks 25.2
[dbo].[Problem_Link_Alert]
MS_Description
Problem Linkage Alerts
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Problem_Link_Alert table
ItemChildID
[dbo].[uniqueid]
9
NOT NULL
Order instance
ItemType
char(2)
2
NOT NULL
Item Type. PL - Order
OIDDE
[dbo].[dict_id]
5
NOT NULL
Orderable Item. Link to QO_Classification_DE.ID
AlertTypeDE
[dbo].[dict_id]
5
NOT NULL
Alert Type. Link to Alert_Type_DE.ID
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patietn. Link to Person.ID
UserID
[dbo].[uniqueid]
9
NOT NULL
User. Link to IDX_User.ID
(2)
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
AlertDTTM
datetime
8
NULL allowed
(getdate())
Alert time