ID for each of the reportability response and is maintained by PHRConnect service.
ResponseJSON
nvarchar(max)
max
NOT NULL
CED data received as a part of the Reportability response. This will be in the original format, a compressed data.
MessageStatus
varchar(15)
15
NOT 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.
RemovedInPHRConnect
bit
1
NOT 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.