Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Unified Contact Center Enterprise 9.0(2)
  5. Technical References

Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

Download
Page of 548
   
2-414
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2      Table Details
Termination_Call_Variable Table
Termination_Call_Variable Table
Central database only.
Each row records the value of an expanded call variable for a call 
 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.
Related tables:
 (via ExpandedCallVariableID)
 (TCDRecoveryKey maps to Termination_Call_Detail.RecoveryKey)
Table 2-369 Termination_Call_Variable Table Constraints
Constraint
Field Name(s)
AK-1
RecoveryKey
AK-2
ArrayIndex
ExpandedCallVariableID
TCDRecoveryKey
IE-1
DateTime
IE-2
DbDateTime
Table 2-370 Termination_Call_Variable Table
Field Name
Description
Data Type
Keys and 
Null Option
ArrayIndex
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.
DBINT
AK-2
NOT NULL
DateTime
The date and time when the call was routed.
DBSMALLDATE
IE-1
NOT 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.
DBDATETIME
IE-2
NULL
ECCValue
The value of the call variable or array element.
varchar(255)
NULL
ExpandedCallVariableID
Identifies the expanded call variable.
DBSMALLINT
AK-2, FK
NOT NULL
RecoveryKey
A unique ID assigned to each record and used 
internally by the ICM/IPCC Enterprise software to 
track the record.
DBFLT8
AK-1
NOT NULL
TCDRecoveryKey
The RecoveryKey value from the associated 
Termination_Call_Detail row.
DBFLT8
AK-2
NOT NULL