Cisco Cisco IP Contact Center Release 4.6.1 Technische Referenzen
Table 214: Indexes for User_Variable Table
index_keys
index_description
index_name
ObjectType, VariableName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1User_Variable
UserVariableID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKUser_Variable
Fields in User_Variable Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NOT NULL
DBSMALLINT
Indicates the type of the variable:
DataType
• 0 = Long
• 1 = Float
• 2 = Char
• 3 = Date
NULL
DESCRIPTION
Additional information about the variable.
Description
NOT NULL
DBCHAR
Not currently used.
Instance
AK-1 NOT NULL
DBSMALLINT
The type of object with which the variable is
associated. For the list of values, click
associated. For the list of values, click
ObjectType
NOT NULL
DBCHAR
Indicates whether to preserve the value of the
variable between script invocations. Stored as a
character:
variable between script invocations. Stored as a
character:
Persistent
• Y = yes
• N = no
NOT NULL
DBSMALLINT
Not currently used.
ReportingMethod
PK NOT NULL
DBINT
A unique identifier for the variable.
UserVariableID
AK-1 NOT NULL
VNAME32
The name of the variable. User variable names must
begin with "user".
begin with "user".
VariableName
Version Table
This table is in the
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
366
Chapter 2: - All Tables
Version Table