Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Intervention_ActionTaken
Touchworks 25.2
[dbo].[Intervention_ActionTaken]
MS_Description
Capture events (or) action taken on various intervention types (AUC, CareGuide, POCR and Normative GrowthChart)
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Intervention_ActionTaken table
InterventionTypeDE
[dbo].[dict_id]
5
NOT NULL
Type. Link to Intervention_Type_DE.ID
Intervention
varchar(1000)
1000
NOT NULL
Intervention Name on which the actions were performed
ActionTaken
varchar(max)
max
NOT NULL
Type of Action Taken on Intervention by user
ActionDetail
varchar(max)
max
NULL allowed
Additional details regarding ActionTaken
ActionTakenDTTM
datetime
8
NOT NULL
Date and time when action taken by user on Intervention
UserID
[dbo].[uniqueid]
9
NOT NULL
User. Link to IDX_User.ID
SiteDE
[dbo].[dict_id]
5
NOT NULL
Site. Link to Site_DE.ID
CreatedDTTM
datetime
8
NOT NULL
(getdate())
Date/Time Record was Created