Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Referral_Attachment
Touchworks 25.2
[dbo].[Referral_Attachment]
MS_Description
Attachments for the Referral Requests and Referral Responses
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Referral_Attachment table.
(2)
ReferralMessageID
[dbo].[uniqueid]
9
NOT NULL
((0))
Refferal Message. Key to the Referral_Message Table.
AttachmentItemID
[dbo].[uniqueid]
9
NOT NULL
((0))
ItemIDs of each Attachments. This could be Document.ID or Result ActivityHeaderID or RuntimeXMLChunkID based on the attached item type.
AttachmentItemType
char(3)
3
NOT NULL
('')
REF for Referral , SOC - Summary Of Care, RS - Result, DOC - Document
AttachmentStatusDE
[dbo].[dict_id]
5
NOT NULL
((0))
Attachement Status. Key to the Attachement_Status_DE table.
Title
varchar(1000)
1000
NOT NULL
('')
Name of the Document
ReferralDocumentID
[dbo].[uniqueid]
9
NULL allowed
Referral Document. Key to the Referral_Document table.
OriginatingDocumentID
[dbo].[uniqueid]
9
NOT NULL
((0))
Originating DocumentID from Document table.
CustodianName
nvarchar(255)
510
NOT NULL
('')
name of the custodian for any document send via a Direct message. This will typically be the name of the organization where the CED originated
DocumentSize
[dbo].[uniqueid]
9
NULL allowed
((0))
Size of the document
LastUpdatedDTTM
datetime
8
NULL allowed
(NULL)
Last update date and time