Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.FDAMedicalDevices
Touchworks 25.2
[dbo].[FDAMedicalDevices]
MS_Description
Medical devices Master
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the FDAMedicalDevices table
DeviceID
varchar(30)
30
NOT NULL
Medical device Identifier
DeviceXMLCompressed
varbinary(max)
max
NOT NULL
Device XML in compressed format
CreateDTTM
datetime
8
NOT NULL
Created date and time
LastUpdateDTTM
datetime
8
NOT NULL
Last updated date and time