Cisco Cisco IPCC Web Option Technical References

PK, FK NOT
NULL

DBSMALLINT

Identifier for the peripheral.

PeripheralID

AK-1 NOT NULL

DBFLT8

A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.

RecoveryKey

NULL

DBINT

Number of calls to the peripheral abandoned within the service
level threshold during the half- hour interval.

ServiceLevelAbandToHalf

NULL

DBINT

Number of calls to the peripheral that had a service level event
during the half- hour interval.

ServiceLevelCallsOfferedToHalf

NULL

DBINT

Number of calls to the peripheral answered within the service
level threshold during the half- hour interval.

ServiceLevelCallsToHalf

NULL

DBFLT4

The ICM software service level for the peripheral during the
half- hour interval.

ServiceLevelToHalf

NULL

DBINT

Service Level Type used to calculate Service level for this
interval.

ServiceLevelType

PK NOT NULL

DBINT

The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).

TimeZone

NULL

DBINT

The total of PeripheralRealTime. CallsInProgress at all sample
points during the half-hour period. For example, if there are 3

TotalCallsInProgressSamples

samples, and the number of calls in progress at those points in
time are 20, 25 and 15, then TotalCallsInProgressSamples is 60.

Peripheral_Monitor Table

. To see database

rules for these tables, click 

Each row describes an entity to be monitored on a peripheral. Currently this table applies only
to the Alcatel 4400, Siemens ACD, the Nortel DMS-100, the Meridian ACD in enhanced CTI
mode, and to the Avaya DEFINITY ECS with station monitoring enabled.

Use the PG Explorer tool to add, update, and delete Peripheral_Monitor records.

 (via PeripheralID)

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)