Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 620
index_keys
index_description
index_name
RouteID
nonclustered located on PRIMARY
XIE1Peripheral_Target
NetworkTargetID
clustered, unique, primary key
located on PRIMARY
XPKPeripheral_Target
Fields in Peripheral_Target Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULL
DBSMALLINT
The number of seconds the peripheral waits before queuing an
incoming call to an agent. This time might be used, for
example, to play a forced announcement.
DelayBeforeQueue
NULL
DESCRIPTION
Additional information about the target.
Description
AK-1 NOT NULL
VNAME32
DNIS digits the routing client sends when 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.
NetworkTrunkGroupID
FK, IE-1 NULL
DBINT
Indicates the Route associated with this 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.
The CallRouter automatically maintains the Persistent_Variable table.
Related table
 (via UserVariableID)
Table 143: Indexes for Persistent_Variable Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Persistent_Variable
UserVariableID, ForeignKey1
clustered, unique, primary key
located on PRIMARY
XPKPersistent_Variable
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
262
Chapter 2:  All Tables
Persistent_Variable Table