Technical References

Related tables
Route Call Variable (page 283) (via ExpandedCallVariableID)
Termination Call Variable (page 417) (via ExpandedCallVariableID)
Table 90: Indexes forExpanded_Call_Variable Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Expanded_Call_Variable
ExpandedCallVariableIDclustered, 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 NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y= Yes
• N = No
NULLDESCRIPTION
Additional information about the call variable.
Description
NOT NULLDBCHAR
Indicates whether the call variable is an array:
ECCArray
• Y= Yes
• N = No
NOT NULLDBCHAR
Indicates whether the call variable is currently enabled:
Enabled
• Y = Yes
• N = No
AK-1 NOT NULLVNAME32
An enterprise name for this call variable. This name must be unique
among all expanded call variables within the business entity.
EnterpriseName
PK NOT NULLDBSMALLINT
A unique identifier for the call variable.
ExpandedCallVariableID
NOT NULLDBCHAR
Indicates whether the call variable is provided by Cisco:
GeoTelProvided
• Y= Yes
• N= No
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
180
Chapter 2: All Tables
Expanded_Call_Variable Table