Tables [dbo].[ECR_Inbound_Message]
Context of each of the Response from the PHR Connect Service to TW. The PHRConnect Service treats each Response by PHR Connect to TW as one operation and identifies it a GUID called MessageOperationID. MessageOperationID is used for tracking and troubleshooting the TW and PHRConnect interactions.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_dbo.ECR_Inbound_Message: IDIDbigint8NOT NULL1 - 1Key to the ECR_Inbound_Message table
Indexes NIX_ECR_Inbound_Message_MessageOperationIDMessageOperationIDuniqueidentifier16NOT NULLGUID received from the PHRConnect service and it identifies each response from the PHRConnect. This is useful for troubleshooting the issues in TW-PHRConnect interaction.
DeletedPHRConnectIDsnvarchar(max)maxNULL allowedList of PHRConnectIDs that are deleted at PHRConnect service
CreatedDTTMdatetime8NOT NULL(getdate())Created date time