Cisco Cisco IPCC Web Option Technical References

Page of 404
 
2-290
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
User_Variable Table
Related tables:
Persistent Variable (via UserVariableID)
ObjectType 
(continued)
33  =  Network VRU Script
34  =  Scheduled Target
35  =  Network VRU
36  =  Skill Group Member
37  =  Expanded Call Variable
38  =  Agent Team
39  =  Campaign
40  =  Dialer
41  =  Import Rule
42  =  Query Rule
43  =  Campaign Query Rule
44  =  Dialer Port Map
45  =  Message Category
46  =  Message Destination
47  =  Response Template
smallint
AK1, NOT 
NULL
VariableName
The name of the variable. User variable names must 
begin with "user".
varchar(32)
AK1, NOT 
NULL
Description
Additional information about the variable.
varchar(255)
NULL
Persistent
Indicates whether to preserve the value of the 
variable between script invocations. Stored as a 
character: 
Y = yes
N = no
char(1)
NOT NULL
DataType
Indicates the type of the variable:
0 = Long
1 = Float
2 = Char
3 = Date
smallint
NOT NULL
Instance
Not currently used.
char(1)
NOT NULL
ReportingMethod
Not currently used.
smallint
NOT NULL
ChangeStamp
Incremented when the record is changed in the 
central database.
int
NOT NULL
Table 2-194 User_Variable Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option