Tables [dbo].[CDSClientRequestLog]
Calls made to CDS from Touchworks with all the information sent to CDS and response received from CDS
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PKCDSClientRequestLog: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the CDSClientRequestLog table.
Indexes nix_CDSClientRequestLog_PatientIDForeign Keys Fk_CDSClientRequestLog_PatientID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Key to the Person Table
Foreign Keys Fk_CDSClientRequestLog_UserID: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLUserID that triggered CDS request (if applicable). Key to the IDX_User Table
Indexes nix_CDSClientRequestLog_CreatedDTTMCreatedDTTMdatetime8NOT NULLDate/Time the request to CDS Client was initiated
UpdateDTTMdatetime8NULL allowedDate/Time the request to CDS Client was completed
Indexes nix_CDSClientRequestLog_CreatedDTTMStatusvarchar(40)40NULL allowedStatus of request
StatusMessagevarchar(max)maxNULL allowedResponse message received from CDS
Indexes nix_CDSClientRequestLog_CreatedDTTMRequestEventvarchar(50)50NULL allowedIndicates the event that triggered the CDS Request
MOMID[dbo].[uniqueid]9NOT NULLUnique identifier for a created and stored MOM. Link to MOM.ID.
WIPSessionID[dbo].[uniqueid]9NOT NULLWIP Session ID
Indexes nix_CDSClientRequestLog_CreatedDTTMCDSClientRequestvarchar(40)40NULL allowedSpecific call made to CDS Client
RecommendationContextvarchar(max)maxNULL allowedInformation about User and Patient to get recommendations.
ProviderID[dbo].[uniqueid]9NULL allowedUser ID sent to CDS to get the recommendations.
RecommendationXMLvarchar(max)maxNULL allowedRecommendation Data returned from CDS
RequestedWebServervarchar(50)50NULL allowedName of the Webserver which initiated CDS Call
TWDuration[dbo].[dict_id]5NULL allowedTotal Duration taken by Touchworks to get recommendation displayed
CDSDuration[dbo].[dict_id]5NULL allowedTotal Duration taken by CDS to get recommendation back
RecommendationContextCompressedvarbinary(max)maxNULL allowedCompressed Recommendation Context Data
RecommendationXMLCompressedvarbinary(max)maxNULL allowedCompressed Recommendation XML Data