Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.MedicalDevice_Header
Touchworks 25.2
[dbo].[MedicalDevice_Header]
MS_Description
Medical device Header table
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
Key to the MedicalDevice_Header table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID
CurrentMedicalDeviceID
[dbo].[uniqueid]
9
NOT NULL
Current instance of the medical device. Link to MedicalDevice.ID
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
CreatedByID
[dbo].[uniqueid]
9
NOT NULL
Provider who added the Medical device into the patient Chart
CreateDTTM
datetime
8
NOT NULL
Date and time of Medical device added into the patient Chart
LastUpdateDTTM
datetime
8
NOT NULL
Last updated date and time
ItemType
char(2)
2
NOT NULL
('MD')
Item type 'MD' for medical device
HasAnnotationFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Has Annotation present for the Medical device?