Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Keys and Null
Option:
Data Type:
Description:
Field Name:
NOT NULL
DBSMALLINT
EMS version number.
VersionNum
Expanded_Call_Variable Table
Each row describes an expanded call variable. Use ICM Configuration Manager to add, update,
and delete Expanded_Call_Variable records.
Related tables
 (via ExpandedCallVariableID)
 (via ExpandedCallVariableID)
Table 89: Indexes forExpanded_Call_Variable Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1Expanded_Call_Variable
ExpandedCallVariableID
clustered, unique, primary key
located on PRIMARY
XPKExpanded_Call_Variable
Fields in Expanded_Call_Variable Table:
Keys and Null
Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
ChangeStamp
NOT NULL
DBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y= Yes
• N = No
NULL
DESCRIPTION
Additional information about the call variable.
Description
NOT NULL
DBCHAR
Indicates whether the call variable is an array:
ECCArray
• Y= Yes
• N = No
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
144
Chapter 2: -  All Tables
Expanded_Call_Variable Table