Tables [dbo].[Referral_Attachment]
Attachments for the Referral Requests and Referral Responses
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Referral_Attachment_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Referral_Attachment table.
Indexes NIX_Referral_Attachment_AttachmentItemID_INC_ReferralMessageID, NIX_Referral_Attachment_ReferralMessageID(2)Foreign Keys FK_Referral_Attachment_ReferralMessageID: [dbo].[Referral_Message].ReferralMessageIDReferralMessageID[dbo].[uniqueid]9NOT NULL((0))Refferal Message. Key to the Referral_Message Table.
Indexes NIX_Referral_Attachment_AttachmentItemID_INC_ReferralMessageIDAttachmentItemID[dbo].[uniqueid]9NOT NULL((0))ItemIDs of each Attachments. This could be Document.ID or Result ActivityHeaderID or RuntimeXMLChunkID based on the attached item type.
AttachmentItemTypechar(3)3NOT NULL('')REF for Referral , SOC - Summary Of Care, RS - Result, DOC - Document
Foreign Keys FK_Referral_Attachment_AttachmentStatusDE: [dbo].[Attachment_Status_DE].AttachmentStatusDEAttachmentStatusDE[dbo].[dict_id]5NOT NULL((0))Attachement Status. Key to the Attachement_Status_DE table.
Titlevarchar(1000)1000NOT NULL('')Name of the Document
Indexes NIX_Referral_Attachment_ReferralDocumentIDForeign Keys FK_Referral_Attachment_ReferralDocumentID: [dbo].[Referral_Document].ReferralDocumentIDReferralDocumentID[dbo].[uniqueid]9NULL allowedReferral Document. Key to the Referral_Document table.
OriginatingDocumentID[dbo].[uniqueid]9NOT NULL((0))Originating DocumentID from Document table.
CustodianNamenvarchar(255)510NOT 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]9NULL allowed((0))Size of the document
LastUpdatedDTTMdatetime8NULL allowed(NULL)Last update date and time