Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) 产品宣传页
21
Cisco Customer Response Solutions Database Schema
Database Schema
Database Table Details
targetType
Indicates whether the call was queued
for a CSQ or for an agent.
for a CSQ or for an agent.
0 = CSQ
1 = Agent
tinyint
NOT NULL
Primary Key
targetID
Numeric ID of the CSQ or the agent
depending upon the targetType.
depending upon the targetType.
0—Numeric record ID of the CSQ. (See
record ID description in the Contact
Service Queue Table)
record ID description in the Contact
Service Queue Table)
1—Numeric agent ID (see resourceID
description in the Resource Table)
description in the Resource Table)
int
NOT NULL
Primary Key
disposition
Disposition for this leg of the call for
this CSQ.
this CSQ.
•
Abandoned = 1
1
•
Handled by CSQ = 2
•
Dequeued from CSQ = 3
•
Handled by script = 4
•
Handled by another CSQ = 5
tinyint
NULL
metServiceLevel
Call answered within the configured
number of seconds of queue time for
this CSQ.
number of seconds of queue time for
this CSQ.
•
Yes = 1
•
No = 0
bit
NULL
queueTime
Number of seconds the caller spent in
queue for this CSQ and this leg of the
call.
queue for this CSQ and this leg of the
call.
smallint
NULL
1.
For aborted calls, ContactQueueDetail.disposition = 1 and the corresponding
ContactCallDetail.contactDisposition = 4 (aborted).
ContactCallDetail.contactDisposition = 4 (aborted).
Table 1-5
ContactQueueDetail Table Fields (continued)
Field Name
Description
Storage