Tables [dbo].[Referral_Header]
Header level table to store referral Request and Response for each Referral Order
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Referral_Header_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Referral_Header table.
CurrentReferralMessageID[dbo].[uniqueid]9NOT NULL((0))Current Referral messageID. Link to Referral_Message.ID
Indexes NIX_Referral_Header_ReferralNumberEXTReferralNumberEXTvarchar(500)500NOT NULL('')GUID for the individual Referral Order. This is sent to the external source and is returned as part of the Response.
Check Constraints CK_Referral_Header_IsInboundReferralFLAG_Yes_Or_No : ([IsInboundReferralFLAG]='N' OR [IsInboundReferralFLAG]='Y')IsInboundReferralFLAG[dbo].[BOOL]1NOT NULL('N')Y or N - Request invoked from Internally or Externally.
Indexes NIX_ReferralHeader_PatientIDForeign Keys FK_Referral_Header_PatientID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULL((0))Patient. Key to the Person Table
CreatedDTTMdatetime8NOT NULL('')Create time
OrganizationID[dbo].[dict_id]5NULL allowedOrganization. Link to Organization.ID
InternalReferralFLAG[dbo].[BOOL]1NOT NULL('N')Internal Referral Indicator
Foreign Keys FK_Referral_header_DirectMessageTypeDE_Direct_Message_Type_DE_ID: [dbo].[Direct_Message_Type_DE].DirectMessageTypeDEDirectMessageTypeDEnumeric(8,0)5NULL allowedDirect Message Type. Link to Direct_Message_Type_DE.ID