Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Leaflet
11
Cisco Customer Response Solutions Database Schema
Database Schema
Database Table Details
A ContactCallDetail record contains detailed information about the call or leg. At
least one such record exists for each call.
least one such record exists for each call.
Table 1-4
ContactCallDetail 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