Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Encounter_ItemChild_Verb
Touchworks 25.2
[dbo].[Encounter_ItemChild_Verb]
MS_Description
Links individual actions for a clinical item to and encounter
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
ItemID
[dbo].[uniqueid]
9
NOT NULL
Item. Links to the ID columm on one of the item tables (Item_plan, Item_Medication, etc)
ItemChildID
[dbo].[uniqueid]
9
NOT NULL
Version Identifier for the clinical item. Links to the ID column in one of the child tables (Plan_item, Mdication, Immunization, etc)
Verb
varchar(255)
255
NOT NULL
Action taken
ItemType
char(2)
2
NOT NULL
Item type. (ME - Medication, PL - Non medication order, IM - Immunization, etc)