Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 548
   
2-239
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Peripheral_Target Table
Peripheral_Target Table
Each row specifies the peripheral address (network trunk group and DNIS) associated with a route.
Use the PG Explorer tool to add, update, and delete Peripheral_Target records.
Related tables:
 (via RouteID)
 (via NetworkTargetID)
 (via NetworkTrunkGroupID)
Table 2-248 Peripheral_Target Table Constraints
Constraint
Field Name(s)
PK
NetworkTargetID
AK-1
DNIS
NetworkTrunkGroupID
FK
NetworkTargetID
NetworkTrunkGroupID
RouteID
IE-1
RouteID
Table 2-249 Peripheral_Target Table
Field Name
Description
Data Type
Keys and 
Null Option
ChangeStamp
Incremented when the record is changed in the 
central database.
CHANGESTAMP
NOT NULL
DelayBeforeQueue
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.
DBSMALLINT
NOT NULL
Description
Additional information about the target.
DESCRIPTION
NULL
DNIS
DNIS digits the routing client sends when 
addressing this target.
VNAME32
AK-1
NOT NULL
NetworkTargetID
Foreign key from the Network Target table.
DBINT
PK, FK
NOT NULL
NetworkTrunkGroupID
Indicates the Network Trunk Group associated 
with this peripheral target.
DBINT
AK-1, FK
NOT NULL
RouteID
Indicates the Route associated with this peripheral 
target.
DBINT
FK, IE-1
NULL