Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
This time might be used, for example, to play
a forced announcement.
a forced announcement.
NULL
DESCRIPTION
Additional information about the target.
Description
AK-1 NOT NULL
VNAME32
DNIS digits the routing client sends when
addressing this target.
addressing this target.
DNIS
PK, FK NOT NULL
DBINT
Foreign key from the Network Target table.
NetworkTargetID
AK-1, FK NOT NULL
DBINT
Indicates the Network Trunk Group associated
with this peripheral target.
with this peripheral target.
NetworkTrunkGroupID
FK, IE-1 NULL
DBINT
Indicates the Route associated with this
peripheral target.
peripheral target.
RouteID
Persistent_Variable Table
This table is part of the
Central database only.
Stores the current value of persistent user variables. User variables are defined in the
User_Variable table.
User_Variable table.
The CallRouter automatically maintains the Persistent_Variable table.
Related table
(via UserVariableID)
Table 142: Indexes for Persistent_Variable Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Persistent_Variable
UserVariableID, ForeignKey1
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKPersistent_Variable
Fields in Persistent_Variable Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
If the variable is associated with an object type, the key
value of the specific object.
value of the specific object.
ForeignKey1
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used internally
by the ICM/IPCC Enterprise software to track the
record.
by the ICM/IPCC Enterprise software to track the
record.
RecoveryKey
PK, FK NOT NULL
DBINT
Foreign key from the User_Variable table.
UserVariableID
NULL
DESCRIPTION
The value of the variable, if it is a character string.
ValueChar
NULL
DBDATETIME
The value of the variable, if it is a date-time.
ValueDateTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
221
Chapter 2: All Tables
Persistent_Variable Table