Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
2-430
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
User_Variable Table
User_Variable Table
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.
(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.
Table 2-395 User_Variable Table Constraints
Constraint
Field Name(s)
PK
UserVariableID
AK-1
ObjectType
VariableName
VariableName
Table 2-396 User_Variable Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
DataType
Indicates the type of the variable:
0 = Long
1 = Float
2 = Char
3 = Date
1 = Float
2 = Char
3 = Date
DBSMALLINT
NOT NULL
Description
Additional information about the variable.
DESCRIPTION
NULL
Instance
Not currently used.
DBCHAR
NOT NULL
ObjectType
The type of object with which the variable is
associated:
associated:
0
=
Unknown
1
=
Service
2
=
Skill Group
3
=
Agent
4
=
Translation Route
5
=
Agent Administration Group
6
=
Announcement
7
=
Call Type
8
=
Enterprise Service
9
=
Enterprise Skill Group
10
=
Region
11
=
Dialed Number
12
=
Logical Interface Controller
13
=
Physical Interface Controller
14
=
Peripheral
15
=
Routing Client
DBSMALLINT
AK-1
NOT NULL