Tables [dbo].[JardogsTaskAttachment]
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
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_JardogsTaskAttachment_TaskID: TaskIDForeign Keys FK_JardogsTaskAttachment_TaskID_IDX_Task_ID: [dbo].[IDX_Task].TaskIDTaskID[dbo].[uniqueid]9NOT NULLTask. Link to IDX_Task.ID.
Indexes IDX_JardogsTaskAttachment_FMHTaskIdFMHTaskIdvarchar(255)255NOT NULLFollow My Health Task identifier
AttachmentIdvarchar(255)255NOT NULLFollow My Health attachment Id to reference in the FMH Attachment Viewer api
DateCreateddatetime8NOT NULL(getutcdate())Date entry was created