Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-50
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
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 Unified CCX
system.
system.
The Workflow Task table contains the fields shown in
.
active
Indicates whether the record is active in the Unified CCX
system. A record becomes inactive if a team is deleted or
updated.
system. A record becomes inactive if a team is deleted or
updated.
f = Inactive
t = Active
boolean
NOT NULL
dateInactive
Date this record was deleted.
datetime year to
second
second
NULL
Table 1-29
TeamCSQMapping Table Fields (continued)
Field Name
Description
Storage
Table 1-30
WorkflowTask Table Fields
Field Name
Description
Storage
taskID
Identifier of the task.
decimal(18, 0)
NOT NULL
Primary Key
parentTaskID
Identifier of the parent task, if the task is a subtask.
decimal(18, 0)
NULL
startDateTime
Date and the time that the task started executing.
datetime year to
second
second
NOT NULL
endDateTime
Date and the time that the task completed executing.
datetime year to
second
second
NOT NULL
applicationServerID Unique identifier assigned to each Unified CCX server in
the cluster.
smallint
NOT NULL
Primary Key