Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.ECR_Reportability_Response_Details
Touchworks 25.2
[dbo].[ECR_Reportability_Response_Details]
MS_Description
Individual data elements present in the eCR Reportability Response XML
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
bigint
8
NOT NULL
1 - 1
Key to the ECR_Reportability_Response_Details table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Person.ID
SubmittingProviderID
[dbo].[uniqueid]
9
NOT NULL
Submitting Provider. Link to Person.ID
ReportabilityPriorityID
[dbo].[dict_id]
5
NOT NULL
Priority. Link to ECR_Reportability_Priority_DE.ID
DetermineReportabilityID
[dbo].[dict_id]
5
NOT NULL
Determine Reportability. Link to ECR_Determine_Reportability_DE.ID
DocumentID
[dbo].[uniqueid]
9
NULL allowed
Document. Link to Document.DocumentID
CreatedDTTM
datetime
8
NOT NULL
(getdate())
Create time