Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Order_Activity_Header
Touchworks 25.2
[dbo].[Order_Activity_Header]
MS_Description
Activity Header table for Medication and Non-Medication orders
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
Key to the Order_Activity_Header table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Person.ID
(2)
VisitID
[dbo].[uniqueid]
9
NOT NULL
Visit. Link to Visit.ID.
CreateDTTM
datetime
8
NOT NULL
Date/Time that the entry was added/created
HasSecurityFLAG
[dbo].[BOOL]
1
NOT NULL
Security (Y/N). No longer used.
ActivityType
varchar(10)
10
NOT NULL
Activity Type (Order)
(2)
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
ParentID
[dbo].[uniqueid]
9
NOT NULL
Parent. No longer used.
ActivityTypeDE
[dbo].[dict_id]
5
NOT NULL
Activity Type. Link to Activity_Type_DE.ID
CMSVersion
smallint
2
NOT NULL
CMS Version. Currently 4.
(2)
CurrentOrderActivityID
[dbo].[uniqueid]
9
NOT NULL
(0)
Current Activity row. Link to Order_Activity.OrderActivityID.