Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Referral_Header table. |
| CurrentReferralMessageID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Current Referral messageID. Link to Referral_Message.ID |
 | ReferralNumberEXT | varchar(500) | 500 | NOT 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') Check Constraints CK_Referral_Header_IsInboundReferralFLAG_Yes_Or_No : ([IsInboundReferralFLAG]='N' OR [IsInboundReferralFLAG]='Y')](../../../../Images/c-constraint.png) | IsInboundReferralFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Y or N - Request invoked from Internally or Externally. |
 ![Foreign Keys FK_Referral_Header_PatientID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Referral_Header_PatientID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Patient. Key to the Person Table |
| CreatedDTTM | datetime | 8 | NOT NULL | | ('') | Create time |
| OrganizationID | [dbo].[dict_id] | 5 | NULL allowed | | | Organization. Link to Organization.ID |
| InternalReferralFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Internal Referral Indicator |
![Foreign Keys FK_Referral_header_DirectMessageTypeDE_Direct_Message_Type_DE_ID: [dbo].[Direct_Message_Type_DE].DirectMessageTypeDE Foreign Keys FK_Referral_header_DirectMessageTypeDE_Direct_Message_Type_DE_ID: [dbo].[Direct_Message_Type_DE].DirectMessageTypeDE](../../../../Images/fk.png) | DirectMessageTypeDE | numeric(8,0) | 5 | NULL allowed | | | Direct Message Type. Link to Direct_Message_Type_DE.ID |