Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Leaflet
Database Schema
Database Table Details
62
Cisco Customer Response Solutions Database Schema
Related Tables
•
(csqID maps to contactServiceQueueID, and
via profileID)
•
(via ProfileID)
•
(via teamID and profileID)
WorkflowTask
Database table name: WorkflowTask
A WorkflowTask record contains information about a task or a subtask that runs
on the Cisco CRS system.
on the Cisco CRS system.
The Workflow Task table contains the fields shown in
.
Table 1-28
WorkflowTask Table Fields
Field Name
Description
Storage
taskID
Identifier of the task.
decimal(18)
NOT NULL
Primary Key
parentTaskID
Identifier of the parent task, if the task is
a subtask.
a subtask.
decimal(18)
NULL
applicationServerID Unique identifier assigned to each
Cisco CRS server in the cluster.
smallint
NOT NULL
Primary Key
startDateTime
Date and the time that the task started
executing.
executing.
datetime
NOT NULL
endDateTime
Date and the time that the task
completed executing.
completed executing.
datetime
NOT NULL