Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Termination_Call_Variable Table

This table is in the 

. To see database rules for these tables, click 

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.

 (via ExpandedCallVariableID)

(TCDRecoveryKey maps to

Termination_Call_Detail.RecoveryKey)

TCDRecoveryKey,
ExpandedCallVariableID, ArrayIndex

clustered, unique, unique key
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

XPKTermination_Call_Variable

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.

ArrayIndex

IE-1 NOT NULL

DBSMALLDATE

The date and time when the call was routed.

DateTime

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)