Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) 产品宣传页
23
Cisco Customer Response Solutions Database Schema
Database Schema
Database Table Details
Table 1-6
ContactRoutingDetail Table Fields
Field Name
Description
Storage
sessionID
Identifier that the system assigned to the
call. This identifier remains the same
for all legs of the call.
call. This identifier remains the same
for all legs of the call.
decimal(18)
NOT NULL
Primary Key
sessionSeqNum
Session sequence number that the
system assigned to the call or the leg.
Each leg of a call is assigned a new
sequence number.
system assigned to the call or the leg.
Each leg of a call is assigned a new
sequence number.
smallint
NOT NULL
Primary Key
nodeID
Unique identifier assigned to each
server in the cluster.
server in the cluster.
smallint
NOT NULL
Primary Key
profileID
Identifier of the Cisco CRS profile that
is associated with this record.
is associated with this record.
int
NOT NULL
Primary Key
qIndex
A new qIndex is created whenever the
Unified CCX call is conferenced to a
Unified CCX route point.
Unified CCX call is conferenced to a
Unified CCX route point.
tinyint
NOT NULL
Primary Key
origPriority
Priority level assigned to the call or the
leg when it was first queued.
leg when it was first queued.
Null if a priority was not assigned.
tinyint
NULL
finalPriority
Priority level of the call or the leg when
it ended.
it ended.
Null if a priority was not assigned.
tinyint
NULL