Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
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.
interval.
datetime
NULL
UserControl
Unused.
int
NULL
CallsRoutedHalf
Number of calls routed to the peripheral during
the current half-hour interval.
the current half-hour interval.
int
NULL
CallsRoutedToday
Number of calls routed to the peripheral since
midnight.
midnight.
int
NULL
CTIServerOnline
Indicates the state of the CTI Server, if any,
associated with the peripheral:
associated with the peripheral:
0 = Off-line
1 = On-line
1 = On-line
int
NULL
Table 2-122 Peripheral_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-123 Peripheral_Target Table
Field Name
Description
Data Type
Keys and Null
Option
Option
NetworkTargetID
Foreign key from the Network Target table.
int
PK, FK, NOT
NULL
NULL
NetworkTrunkGroupID
Indicates the Network Trunk Group associated with this
peripheral target.
peripheral target.
int
AK1, FK, NOT
NULL
NULL
RouteID
Indicates the Route associated with this peripheral target. int
FK, NULL
DNIS
DNIS digits the routing client sends when addressing this
target.
target.
varchar(32)
AK1, NOT
NULL
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.
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.
database.
int
NOT NULL