Tables [dbo].[ECR_Inbound_Message_Details]
Each reportability response received from the PHRConnect.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_dbo.ECR_Inbound_Message_Details: IDIDbigint8NOT NULL1 - 1Key to the ECR_Inbound_Message_Details table
Indexes NIX_ECR_Inbound_Message_Details_ECRInboundMessageIDForeign Keys FK_ECR_Inbound_Message_Details_ECRInboundMessageID: [dbo].[ECR_Inbound_Message].ECRInboundMessageIDECRInboundMessageIDbigint8NOT NULLForeign Key to ECR_Inbound_Message table
Indexes NIX_ECR_Inbound_Message_Details_PHRConnectIDPHRConnectIDuniqueidentifier16NOT NULLID for each of the reportability response and is maintained by PHRConnect service.
ResponseJSONnvarchar(max)maxNOT NULLCED data received as a part of the Reportability response.  This will be in the original format, a compressed data.
Check Constraints CK_ECR_Inbound_Message_Details_MessageStatus : ([MessageStatus]='Received' OR [MessageStatus]='Processed' OR [MessageStatus]='Failed' OR [MessageStatus]='Resubmited' OR [MessageStatus]='Duplicate')MessageStatusvarchar(15)15NOT NULL('Received')This is used to indicate whether this message/row is processed and added to patient chart or not. This will be mainly updated by TW Spooler service when it picks up the job for processing. The allowed values for this column are Received, Processed, Failed, Resubmited and Duplicate.
RemovedInPHRConnectbit1NOT NULL((0))Boolean field indicating whether the entry is removed in PHRConnect service. As soon as TW receives a reportability response, it should save it in TW database, also remove it from PHRConnect service.
Indexes NIX_ECR_Inbound_Message_Details_DocumentIDForeign Keys FK_ECR_Inbound_Message_Details_DocumentID: [dbo].[Document].DocumentIDDocumentID[dbo].[uniqueid]9NULL allowedDocument. Link to Document.DocumentID
CreatedDTTMdatetime8NOT NULL(getdate())Created date time
LastUpdatedDTTMdatetime8NOT NULL(getdate())Last Update date time