Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Referral_Message Table. |
 ![Foreign Keys FK_Referral_Message_ReferralHeaderID: [dbo].[Referral_Header].ReferralHeaderID Foreign Keys FK_Referral_Message_ReferralHeaderID: [dbo].[Referral_Header].ReferralHeaderID](../../../../Images/fk.png) | ReferralHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Referral. Key to the Referral_Header table. |
| ProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Ordering Provider. Link to Provider.ID |
| RecipientDirectID | varchar(250) | 250 | NOT NULL | | ('') | DirectID of Recipient |
| RecipientID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Internal ID of the Recipient |
| RecipientType | char(1) | 1 | NOT NULL | | ('') | R for Referring Provider H for HPD Provider I for Internal provider |
| SenderDirectID | varchar(250) | 250 | NOT NULL | | ('') | DirectID of Sender |
| SenderID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Internal ID of the Sender |
| CommunityID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Community. Link to CED_Endpoints.ID |
| MessageText | varchar(8000) | 8000 | NOT NULL | | ('') | Message from Sender or Receiver |
| Instructions | varchar(2000) | 2000 | NOT NULL | | ('') | Order Instructions |
| OrderReason | varchar(2000) | 2000 | NOT NULL | | ('') | Referral Order Reason |
![Foreign Keys FK_Referral_Message_ReferralDocumentID: [dbo].[Referral_Document].ReferralDocumentID Foreign Keys FK_Referral_Message_ReferralDocumentID: [dbo].[Referral_Document].ReferralDocumentID](../../../../Images/fk.png) | ReferralDocumentID | [dbo].[uniqueid] | 9 | NULL allowed | | | Referral document. Key to the Referral_Document table. |
![Check Constraints CK_Referral_Message_IsResponseFLAG_Yes_Or_No : ([IsResponseFLAG]='N' OR [IsResponseFLAG]='Y') Check Constraints CK_Referral_Message_IsResponseFLAG_Yes_Or_No : ([IsResponseFLAG]='N' OR [IsResponseFLAG]='Y')](../../../../Images/c-constraint.png) | IsResponseFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Y or N based on the Response |
| ResponseStatus | char(1) | 1 | NULL allowed | | ('') | A - Accepted and D- Declined |
![Check Constraints CK_Referral_Message_IsInboundFLAG_Yes_Or_No : ([IsInboundFLAG]='N' OR [IsInboundFLAG]='Y') Check Constraints CK_Referral_Message_IsInboundFLAG_Yes_Or_No : ([IsInboundFLAG]='N' OR [IsInboundFLAG]='Y')](../../../../Images/c-constraint.png) | IsInboundFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Y or N - Message is invoked internally or not |
| CreatedDTTM | datetime | 8 | NOT NULL | | ('') | Message creation time |
| MessageSequence | smallint | 2 | NOT NULL | | ((0)) | Sequence of the message sent/Received |
| IsTOCExportFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Transition of care indicator for the e-referral |
| RecipientSecondaryDirectIDs | varchar(1000) | 1000 | NOT NULL | | ('') | additional RecipientDirect IDs that may come with an ACDM message |
| SenderSecondaryDirectIDs | varchar(1000) | 1000 | NOT NULL | | ('') | additional Sender Direct IDs that may come with an ACDM message |