Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.JardogsTaskAttachment
Touchworks 25.2
[dbo].[JardogsTaskAttachment]
MS_Description
Stores mapping for Touchworks task, FMH Task , and the attachment ID that TW passes into the FMH Attachment viewer API to display patient's attachment to provider within TW
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
TaskID
[dbo].[uniqueid]
9
NOT NULL
Task. Link to IDX_Task.ID.
FMHTaskId
varchar(255)
255
NOT NULL
Follow My Health Task identifier
AttachmentId
varchar(255)
255
NOT NULL
Follow My Health attachment Id to reference in the FMH Attachment Viewer api
DateCreated
datetime
8
NOT NULL
(getutcdate())
Date entry was created