Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Keys and Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of calls to this service handled within
the peripheral service level since midnight.
ServiceLevelCallsToday
NULL
DBFLT4
ICM service level for the peripheral for the
current half-hour interval.
ServiceLevelHalf
NULL
DBFLT4
ICM service level for the peripheral since
midnight.
ServiceLevelToday
NULL
DBINT
Indicates the current failure state of the
peripheral. To see the list of status codes, click
.
Status
NULL
DBINT
Unused.
UserControl
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 NetworkTargetID)
 (via NetworkTrunkGroupID)
Table 141: Indexes for Peripheral_Target Table
index_keys
index_description
index_name
NetworkTrunkGroupID, DNIS
nonclustered, unique, unique key
located on PRIMARY
XAK1Peripheral_Target
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.
DelayBeforeQueue
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
220
Chapter 2: -  All Tables
Peripheral_Target Table