Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

Page of 404
 
2-146
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Peripheral_Target Table
Related table:
Peripheral (via PeripheralID)
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.
CurrentHalfHour
Date and time at the start of the current half-hour 
interval.
datetime
NULL
UserControl
Unused.
int
NULL
CallsRoutedHalf
Number of calls routed to the peripheral during 
the current half-hour interval.
int
NULL
CallsRoutedToday
Number of calls routed to the peripheral since 
midnight.
int
NULL
CTIServerOnline
Indicates the state of the CTI Server, if any, 
associated with the peripheral: 
0 = Off-line
1 = On-line
int
NULL
Table 2-122 Peripheral_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-123 Peripheral_Target Table
Field Name
Description
Data Type
Keys and Null 
Option
NetworkTargetID
Foreign key from the Network Target table.
int
PK, FK, NOT 
NULL
NetworkTrunkGroupID
Indicates the Network Trunk Group associated with this 
peripheral target.
int
AK1, FK, NOT 
NULL
RouteID
Indicates the Route associated with this peripheral target. int
FK, NULL
DNIS
DNIS digits the routing client sends when addressing this 
target.
varchar(32)
AK1, 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.
smallint
NOT NULL
Description
Additional information about the target.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL