Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-230
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Peripheral_Half_Hour Table
Peripheral_Half_Hour Table
Central database only.
Each row contains statistics for a specific peripheral for a specific half- hour interval.
Table 2-242 Peripheral_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
DateTime
MRDomainID
PeripheralID
TimeZone
MRDomainID
PeripheralID
TimeZone
AK-1
RecoveryKey
FK
MRDomainID
PeripheralID
PeripheralID
IE-1
DbDateTime
Table 2-243 Peripheral_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ActiveCTIServerTimeToHalf
Number of seconds the associated CTI Server was
active during the half- hour interval.
active during the half- hour interval.
DBINT
NULL
ActivePeripheralDataTimeToHalf
Number of seconds the associated Peripheral
Gateway was able to provide peripheral data
services to the CallRouter during the half- hour
interval.
Gateway was able to provide peripheral data
services to the CallRouter during the half- hour
interval.
DBINT
NULL
ActivePeripheralTimeToHalf
Number of seconds the associated Peripheral
Gateway’s connections to the peripheral were in
the Active state during the half- hour interval.
Gateway’s connections to the peripheral were in
the Active state during the half- hour interval.
DBINT
NULL
ActiveRoutingClientTimeToHalf
Number of seconds the associated Peripheral
Gateway was able to provide routing client
support to the CallRouter during the half- hour
interval.
Gateway was able to provide routing client
support to the CallRouter during the half- hour
interval.
DBINT
NULL
CallsOfferedToHalf
Total number of incoming ACD calls and internal
ACD calls offered to the peripheral during the
half-hour interval.
ACD calls offered to the peripheral during the
half-hour interval.
DBINT
NULL
DateTime
Central Controller date and time at the start of the
half- hour interval.
half- hour interval.
DBSMALLDATE
PK
NOT NULL
DbDateTime
The current date and time stamp when the records
are written to the HDS database. The logger
database has NULL for this column.
are written to the HDS database. The logger
database has NULL for this column.
DBDATETIME
IE-1
NULL