Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Encounter_ItemChild
Touchworks 25.2
[dbo].[Encounter_ItemChild]
MS_Description
Links Clinical Item events with and Encounter
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
(3)
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
ItemID
[dbo].[uniqueid]
9
NOT NULL
Item. Link to the ID column of one of the item tables (Item_plan, Item_medication, etc.)
(2)
ItemChildID
[dbo].[uniqueid]
9
NOT NULL
Version identifier of the clinical item. Link to the ID column one of the item child tables (Plan_Item, Medication, Immunization, Result, etc.)
(2)
ItemType
char(2)
2
NOT NULL
Item Type. (ME - Medication, PL - Non medication order, AL - Allergy, etc.)
(2)
EncounterDTTM
datetime
8
NOT NULL
Encounter date and time
(3)
VerbList
varchar(255)
255
NOT NULL
List of actions that occured on this encounter for this item