Tables [dbo].[Referral_Message]
Request and Response information for all the Referral Messages
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Referral_Message_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Referral_Message Table.
Indexes NIX_Referral_Message_ReferralHeaderIDForeign Keys FK_Referral_Message_ReferralHeaderID: [dbo].[Referral_Header].ReferralHeaderIDReferralHeaderID[dbo].[uniqueid]9NOT NULL((0))Referral. Key to the Referral_Header table.
ProviderID[dbo].[uniqueid]9NOT NULL((0))Ordering Provider. Link to Provider.ID
RecipientDirectIDvarchar(250)250NOT NULL('')DirectID of Recipient
RecipientID[dbo].[uniqueid]9NOT NULL((0))Internal ID of the Recipient
RecipientTypechar(1)1NOT NULL('')R for Referring Provider
H for HPD Provider
I for Internal provider
SenderDirectIDvarchar(250)250NOT NULL('')DirectID of Sender
SenderID[dbo].[uniqueid]9NOT NULL((0))Internal ID of the Sender
CommunityID[dbo].[uniqueid]9NOT NULL((0))Community.  Link to CED_Endpoints.ID
MessageTextvarchar(8000)8000NOT NULL('')Message from Sender or Receiver
Instructionsvarchar(2000)2000NOT NULL('')Order Instructions
OrderReasonvarchar(2000)2000NOT NULL('')Referral Order Reason
Foreign Keys FK_Referral_Message_ReferralDocumentID: [dbo].[Referral_Document].ReferralDocumentIDReferralDocumentID[dbo].[uniqueid]9NULL allowedReferral document. Key to the Referral_Document table.
Check Constraints CK_Referral_Message_IsResponseFLAG_Yes_Or_No : ([IsResponseFLAG]='N' OR [IsResponseFLAG]='Y')IsResponseFLAG[dbo].[BOOL]1NOT NULL('N')Y or N based on the Response
ResponseStatuschar(1)1NULL allowed('')A - Accepted and D- Declined
Check Constraints CK_Referral_Message_IsInboundFLAG_Yes_Or_No : ([IsInboundFLAG]='N' OR [IsInboundFLAG]='Y')IsInboundFLAG[dbo].[BOOL]1NOT NULL('N')Y or N - Message is invoked internally or not
CreatedDTTMdatetime8NOT NULL('')Message creation time
MessageSequencesmallint2NOT NULL((0))Sequence of the message sent/Received
IsTOCExportFLAG[dbo].[BOOL]1NOT NULL('N')Transition of care indicator for the e-referral
RecipientSecondaryDirectIDsvarchar(1000)1000NOT NULL('')additional RecipientDirect IDs that may come with an ACDM message
SenderSecondaryDirectIDsvarchar(1000)1000NOT NULL('')additional Sender Direct IDs that may come with an ACDM message