Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.CDSClientRequestLog
Touchworks 25.2
[dbo].[CDSClientRequestLog]
MS_Description
Calls made to CDS from Touchworks with all the information sent to CDS and response received from CDS
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the CDSClientRequestLog table.
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Key to the Person Table
UserID
[dbo].[uniqueid]
9
NOT NULL
UserID that triggered CDS request (if applicable). Key to the IDX_User Table
CreatedDTTM
datetime
8
NOT NULL
Date/Time the request to CDS Client was initiated
UpdateDTTM
datetime
8
NULL allowed
Date/Time the request to CDS Client was completed
Status
varchar(40)
40
NULL allowed
Status of request
StatusMessage
varchar(max)
max
NULL allowed
Response message received from CDS
RequestEvent
varchar(50)
50
NULL allowed
Indicates the event that triggered the CDS Request
MOMID
[dbo].[uniqueid]
9
NOT NULL
Unique identifier for a created and stored MOM. Link to MOM.ID.
WIPSessionID
[dbo].[uniqueid]
9
NOT NULL
WIP Session ID
CDSClientRequest
varchar(40)
40
NULL allowed
Specific call made to CDS Client
RecommendationContext
varchar(max)
max
NULL allowed
Information about User and Patient to get recommendations.
ProviderID
[dbo].[uniqueid]
9
NULL allowed
User ID sent to CDS to get the recommendations.
RecommendationXML
varchar(max)
max
NULL allowed
Recommendation Data returned from CDS
RequestedWebServer
varchar(50)
50
NULL allowed
Name of the Webserver which initiated CDS Call
TWDuration
[dbo].[dict_id]
5
NULL allowed
Total Duration taken by Touchworks to get recommendation displayed
CDSDuration
[dbo].[dict_id]
5
NULL allowed
Total Duration taken by CDS to get recommendation back
RecommendationContextCompressed
varbinary(max)
max
NULL allowed
Compressed Recommendation Context Data
RecommendationXMLCompressed
varbinary(max)
max
NULL allowed
Compressed Recommendation XML Data