Technical References

Termination_Call_Variable Table
This table is in the Route category (page 447). To see database rules for these tables, click here
(page 507).
Central database only.
Each row records the value of an expanded call variable for a call handled at a peripheral. If the
expanded call variable is an array, one Termination_Call_Variable row is generated for each
element of the array.
The ICM software generates a Termination_Call_Variable record for each enabled expanded
call variable for every call processed at a peripheral.
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.
Related tables
Expanded_Call_Variable (page 179) (via ExpandedCallVariableID)
Termination_Call_Detail (page 407)(TCDRecoveryKey maps to
Termination_Call_Detail.RecoveryKey)
Table 202: Indexes for Termination_Call_Variable Table
index_keysindex_descriptionindex_name
TCDRecoveryKey,
ExpandedCallVariableID, ArrayIndex
clustered, unique, unique key
located on PRIMARY
XAK1Termination_Call_Variable
DateTimenonclustered located on PRIMARYXIE1Termination_Call_Variable
DbDateTimenonclustered located on PRIMARYXIE2Termination_Call_Variable
RecoveryKeynonclustered, unique, primary key
located on PRIMARY
XPKTermination_Call_Variable
Fields in Termination_Call_Variable Table:
Keys and Null Option:Data Type:Description:Field Name:
AK-2 NOT NULLDBINT
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.
ArrayIndex
IE-1 NOT NULLDBSMALLDATE
The date and time when the call was routed.
DateTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
417
Chapter 2: All Tables
Termination_Call_Variable Table