Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Related tables
(via ExpandedCallVariableID)
(TCDRecoveryKey maps to
Termination_Call_Detail.RecoveryKey)
Table 201: Indexes for Termination_Call_Variable Table
index_keys
index_description
index_name
TCDRecoveryKey,
ExpandedCallVariableID, ArrayIndex
ExpandedCallVariableID, ArrayIndex
clustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Termination_Call_Variable
DateTime
nonclustered located on PRIMARY
XIE1Termination_Call_Variable
DbDateTime
nonclustered located on PRIMARY
XIE2Termination_Call_Variable
RecoveryKey
nonclustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKTermination_Call_Variable
Fields in Termination_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
NULL
varchar(255)
The value of the call variable or array element.
ECCValue
AK-2, FK NOT
NULL
NULL
DBSMALLINT
Identifies the expanded call variable.
ExpandedCallVariableID
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise
software to track the record.
internally by the ICM/IPCC Enterprise
software to track the record.
RecoveryKey
AK-2 NOT NULL
DBFLT8
The date and time when the call was routed.
TCDRecoveryKey
Translation_Route Table
This table is in the
. To see database rules for these tables, click
Each row defines a special route that is used for sending additional information with the call.
When the peripheral receives a call targeted at a translation route, it requests the true route from
the ICM CallRouter process.
When the peripheral receives a call targeted at a translation route, it requests the true route from
the ICM CallRouter process.
Use the Translation Route Explorer or Translation Route Wizard to add, update, and delete
Translation_Route records.
Translation_Route records.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
353
Chapter 2: All Tables
Translation_Route Table