Technical References

Keys and Null Option:Data Type:Description:Field Name:
Note: The SupervisorAgent field for this agent must be Y.
PK, FK NOT NULLDBINT
The identifier for the user.
UserGroupID
Note: The UserGroupType for this user must be U.
User_Variable Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
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.
Use the User Variable list tool to create, update, and delete definitions of user variables.
Related table
Persistent Variable (page 262) (via UserVariableID)
Table 215: Indexes for User_Variable Table
index_keysindex_descriptionindex_name
ObjectType, VariableNamenonclustered, unique, unique key
located on PRIMARY
XAK1User_Variable
UserVariableIDclustered, unique, primary key
located on PRIMARY
XPKUser_Variable
Fields in User_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 NULLDBSMALLINT
Indicates the type of the variable:
DataType
• 0 = Long
• 1 = Float
• 2 = Char
• 3 = Date
NULLDESCRIPTION
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