Cisco Cisco IPCC Web Option Technical References
2-240
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Persistent_Variable Table
Persistent_Variable Table
Central database only.
Stores the current value of persistent user variables. User variables are defined in the User_Variable
table.
table.
The CallRouter automatically maintains the Persistent_Variable table.
Related tables:
(via UserVariableID)
Table 2-250 Persistent_Variable Table Constraints
Constraint
Field Name(s)
PK
ForeignKey1
UserVariableID
UserVariableID
AK-1
RecoveryKey
FK
UserVariableID
Table 2-251 Persistent_Variable Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ForeignKey1
If the variable is associated with an object type,
the key value of the specific object.
the key value of the specific object.
DBINT
PK
NOT NULL
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL
UserVariableID
Foreign key from the User_Variable table.
DBINT
PK, FK
NOT NULL
ValueChar
The value of the variable, if it is a character string. DESCRIPTION
NULL
ValueDateTime
The value of the variable, if it is a date-time.
DATETIME
NULL
ValueFloat
The value of the variable, if it is a floating point
number.
number.
DBFLT8
NULL
ValueInt
The value of the variable, if it is an integer.
DBINT
NULL