Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-84
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Expanded_Call_Variable Table
Expanded_Call_Variable Table
Each row describes an expanded call variable.
Use ICM Configuration Manager to add, update, and delete Expanded_Call_Variable records.
BinData
Optional event binary data.
image
NULL
RecoveryDay
A value used internally by the ICM software to
track virtual time.
track virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to
track virtual time.
track virtual time.
float
AK1, NOT
NULL
NULL
Table 2-71 Event Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-72 Expanded_Call_Variable Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ExpandedCallVariableID
A unique identifier for the call variable.
smallint
PK, NOT NULL
EnterpriseName
An enterprise name for this call variable. This name
must be unique among all expanded call variables
within the business entity.
must be unique among all expanded call variables
within the business entity.
varchar(32)
AK1, NOT
NULL
NULL
MaximumLength
The maximum length of the call variable value: 1 to 210. int
NOT NULL
MaximumArraySize
If the call variable is an array, the maximum number of
elements in the array: 1 to 255.
elements in the array: 1 to 255.
int
NULL
ECCArray
Indicates whether the call variable is an array:
Y = Yes
N = No
N = No
char(1)
NOT NULL
Enabled
Indicates whether the call variable is currently enabled:
Y = Yes
N = No
N = No
char(1)
NOT NULL
GeoTelProvided
Indicates whether the call variable is provided by Cisco:
Y = Yes
N = No
N = No
char(1)
NOT NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
char(1)
NOT NULL
Description
Additional information about the call variable.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL