Cisco Cisco IPCC Web Option Technical References
2-144
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Peripheral_Real_Time Table
Peripheral_Real_Time Table
Local database only.
Each row describes the current state of a specific peripheral. The real- time client creates a Peripheral
Real Time row for each peripheral in the system and updates that row every 10 seconds.
Real Time row for each peripheral in the system and updates that row every 10 seconds.
Table 2-122 Peripheral_Real_Time Table
Field Name
Description
Data Type
Keys and Null
Option
Option
PeripheralID
Identifier for the peripheral.
smallint
PK, FK, NOT
NULL
NULL
MRDomainID
The identifier for the Media Routing Domain
associated with this peripheral.
associated with this peripheral.
int
PK2, NOT
NULL
NULL
DateTime
The date and time that this data was last updated. datetime
NOT NULL
PeripheralTimeZone
The time zone at the peripheral. The value is the
offset in minutes from GMT.
offset in minutes from GMT.
int
NULL
Status
The current failure state of the peripheral:
0 = normal operation
1 - 31 = failures that do not affect functionality
32 - 63 = degraded operation (call routing still
possible)
64 - 127 = failures that prevent call routing
1 - 31 = failures that do not affect functionality
32 - 63 = degraded operation (call routing still
possible)
64 - 127 = failures that prevent call routing
int
NULL
Online
Current on-line state of the peripheral as
determined by the Central Controller:
determined by the Central Controller:
0 = off-line
1 = on-line
1 = on-line
int
NOT NULL
PeripheralTimeOffset
Difference in seconds between the peripheral’s
time and the Central Controller’s time.
time and the Central Controller’s time.
int
NOT NULL
CallsInProgress
Number of calls currently in progress at the
peripheral.
peripheral.
int
NULL
AgentsLoggedOn
Number of agents currently logged on to the
peripheral.
peripheral.
int
NULL
CallsOfferedHalf
Number of calls offered to the peripheral during
the current half-hour interval.
the current half-hour interval.
int
NULL
CallsOfferedToday
Number of calls offered to the peripheral since
midnight.
midnight.
int
NULL
ServiceLevelCallsOfferedHalf
Total number of calls to the peripheral that had
a service level event during the current half-hour
interval.
a service level event during the current half-hour
interval.
int
NULL
ServiceLevelCallsOfferedToday
Total number of calls to the peripheral that had
a service level event since midnight.
a service level event since midnight.
int
NULL
ServiceLevelAbandHalf
Total number of calls to the peripheral
abandoned within the ICM service level
threshold during the current half-hour interval.
abandoned within the ICM service level
threshold during the current half-hour interval.
int
NULL