Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.ECR_Document_Mapping
Touchworks 25.2
[dbo].[ECR_Document_Mapping]
MS_Description
ECR Request and Response Document IDs
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
bigint
8
NOT NULL
1 - 1
Key to the ECR_Document_Mapping Table
MessageID
uniqueidentifier
16
NOT NULL
GUID received from the PHR Connect Message
RequestDocumentID
[dbo].[uniqueid]
9
NULL allowed
Document ID of the ECR Request document imported into dbo.Document table
ResponseDocumentID
[dbo].[uniqueid]
9
NULL allowed
Document ID of the ECR Response document imported into dbo.Document table
CreatedDTTM
datetime
8
NOT NULL
(getdate())
Created Date time
LastUpdatedDTTM
datetime
8
NOT NULL
(getdate())
Last Updated Date time