Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
Note: The SupervisorAgent field for this agent must be Y.
PK, FK NOT NULL
DBINT
The identifier for the user.
UserGroupID
Note: The UserGroupType for this user must be U.
User_Variable Table
This table is part of the
Contains the definitions of user variables. You can optionally associate a variable with an object
type (such as service or skill group). The ICM software then creates an instance of the variable
for each object of that type (for example, for each service or each skill group). You can set and
reference variables within scripts. If a variable is persistent, its value is stored in the
Persistent_Variable table.
type (such as service or skill group). The ICM software then creates an instance of the variable
for each object of that type (for example, for each service or each skill group). You can set and
reference variables within scripts. If a variable is persistent, its value is stored in the
Persistent_Variable table.
Use the User Variable list tool to create, update, and delete definitions of user variables.
Related table
(via UserVariableID)
Table 215: 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.
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
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
431
Chapter 2: All Tables
User_Variable Table