Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Order_Result_Review
Touchworks 25.2
[dbo].[Order_Result_Review]
MS_Description
This table holds the reviewed status of the Order / Result. When an edit happens the Status is set to U
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
PlanItemID
[dbo].[uniqueid]
9
NOT NULL
Order. Link to Plan_Item.ID
UserID
[dbo].[uniqueid]
9
NOT NULL
User. Link to IDX_User.ID
Status
char(1)
1
NOT NULL
Status Code R - Reviewed, U - Unreviewed
ReviewedDTTM
datetime
8
NULL allowed
Date Reviewed / Edited
RoutingListFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Flag for a Routing List (Y/N) associated to the Order
CCListFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Flag for a CC List (Y/N) associated to the Order