Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Intervention_ActionTaken_Mapper
Touchworks 25.2
[dbo].[Intervention_ActionTaken_Mapper]
MS_Description
Related Items for the Intervention on which the actions were taken
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
InterventionID
[dbo].[uniqueid]
9
NOT NULL
Intervention. Link to Intervention_ActuionTaken.ID
(2)
InterventionTypeDE
[dbo].[dict_id]
5
NOT NULL
Type. Link to Intervention_Type_DE.ID
MappedObjectID
[dbo].[uniqueid]
9
NULL allowed
ID of associated item if it is numeric
MappedObjectStringID
varchar(200)
200
NULL allowed
ID of associated item if it is a string. Used for Recommendations
ItemType
varchar(5)
5
NULL allowed
Clinical item type which is linked to Intervention action taken