Cisco Cisco IPCC Web Option Technical References
2-289
Cisco ICM Software Database Schema Handbook
78-11677-04
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-194 User_Variable Table
Field Name
Description
Data Type
Keys and Null
Option
Option
UserVariableID
A unique identifier for the variable.
int
PK, FK, NOT
NULL
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
16
=
Trunk Group
17
=
Route
18
=
Peripheral Target
19
=
Label
20
=
Master Script
21
=
Script Table
22
=
Script Table Column
23
=
Script
24 = Schedule
25 = ICR View
26 = View Column
27 = Network Trunk Group
28 = Service Array
29 = Application Gateway
30 = Device Target
31 = User Variable
32 = User Formula
25 = ICR View
26 = View Column
27 = Network Trunk Group
28 = Service Array
29 = Application Gateway
30 = Device Target
31 = User Variable
32 = User Formula
smallint
AK1, NOT
NULL
NULL