Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-147
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Persistent_Variable Table
Related tables:
Route (via RouteID)
Network Target (via NetworkTargetID)
Network Trunk Group (via NetworkTrunkGroupID)
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:
User Variable (via UserVariableID)
Person Table
Provides primary identification and authentication for all system users, including both agents and
administrators.
administrators.
Table 2-124 Persistent_Variable Table
Field Name
Description
Data Type
Keys and Null
Option
Option
UserVariableID
Foreign key from the User_Variable table.
int
PK, NOT NULL
ForeignKey
If the variable is associated with an object type, the
key value of the specific object.
key value of the specific object.
int
PK, NOT NULL
ValueInt
The value of the variable, if it is an integer.
int
NULL
ValueFloat
The value of the variable, if it is a floating point
number.
number.
real
NULL
ValueChar
The value of the variable, if it is a character string.
varchar(255)
NULL
ValueDateTime
The value of the variable, if it is a date-time.
date
NULL
RecoveryKey
A value used internally by the ICM software to track
the time the record is created.
the time the record is created.
float
AK1, NOT
NULL
NULL
Table 2-125 Person Table
Field Name
Description
Data Type
Keys and Null
Option
Option
PersonID
A unique identifier.
int
PK, NOT NULL
FirstName
The person’s first name.
varchar(32)
AK1, NOT
NULL
NULL