Cisco Cisco IP Contact Center Release 4.6.1 Referências técnicas
Route_Call_Variable Table
This table is in the
This table can become very large. Running custom reporting queries against it while it is on the
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
Central database only.
Each row records the value of an expanded call variable for a call routed by the ICM software.
If the expanded call variable is an array, one Route_Call_Variable row is generated for each
element of the array.
If the expanded call variable is an array, one Route_Call_Variable row is generated for each
element of the array.
The ICM software generates a Route_Call_Variable record for each enabled expanded call
variable for every routing request it processes.
variable for every routing request it processes.
Related tables
(via ExpandedCallVariableID)
(RCDRecoveryKey maps to Route_Call_Detail.RecoveryKey)
Table 159: Indexes for Route_Call_Variable Table
index_keys
index_description
index_name
RCDRecoveryKey,
ExpandedCallVariableID, ArrayIndex
ExpandedCallVariableID, ArrayIndex
clustered, unique, unique key located
on PRIMARY
on PRIMARY
XAK1Route_Call_Variable
DateTime
nonclustered located on PRIMARY
XIE1Route_Call_Variable
DbDateTime
nonclustered located on PRIMARY
XIE2Route_Call_Variable
RecoveryKey
nonclustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKRoute_Call_Variable
Fields in Route_Call_Variable Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
AK-2 NOT NULL
DBINT
If the expanded call variable is an array, this
identifies the array element: 0 to N-1, where N
is the size of the array.
identifies the array element: 0 to N-1, where N
is the size of the array.
ArrayIndex
IE-1 NOT NULL
DBSMALLDATE
The date and time when the call was routed.
DateTime
IE-2 NULL
DBDATETIME
The current date and time stamp when the
records are written to the HDS database. The
logger database has NULL for this column.
records are written to the HDS database. The
logger database has NULL for this column.
DbDateTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
241
Chapter 2: All Tables
Route_Call_Variable Table