Cisco Cisco IP Contact Center Release 4.6.1 Références techniques
Keys and
Null Option:
Null Option:
Data Type:
Description:
Field Name:
PK NOT
NULL
NULL
DBSMALLDATE
Central Controller date and time at the start of
the half- hour interval.
the half- hour interval.
DateTime
IE-1 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.
records are written to the HDS database. The
logger database has NULL for this column.
DbDateTime
NULL
DBINT
The maximum number of calls in progress at
any sample point during the reporting period.
any sample point during the reporting period.
MaxCallsInProgress
This is implemented as the highest value of
PeripheralRealTime.CallsInProgress
encountered during the above sampling.
PeripheralRealTime.CallsInProgress
encountered during the above sampling.
PK, FK NOT
NULL
NULL
DBINT
The ID for the Media Routing Domain
associated with this peripheral.
associated with this peripheral.
MRDomainID
NULL
DBINT
The number of calls-in-progress sample periods.
NumberOfSamples
PK, FK NOT
NULL
NULL
DBSMALLINT
Identifier for the peripheral.
PeripheralID
AK-1 NOT
NULL
NULL
DBFLT8
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software
to track the record.
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.
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.
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.
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.
peripheral during the half- hour interval.
ServiceLevelToHalf
NULL
DBINT
Service Level Type used to calculate Service
level for this interval.
level for this interval.
ServiceLevelType
PK NOT
NULL
NULL
DBINT
The time zone for the date and time. The value
is the offset in minutes from UTC (formerly
called GMT).
is the offset in minutes from UTC (formerly
called GMT).
TimeZone
NULL
DBINT
The total of PeripheralRealTime.
CallsInProgress at all sample points during the
CallsInProgress at all sample points during the
TotalCallsInProgressSamples
half-hour period. For example, if there are 3
samples, and the number of calls in progress at
those points in time are 20, 25 and 15, then
TotalCallsInProgressSamples is 60.
samples, and the number of calls in progress at
those points in time are 20, 25 and 15, then
TotalCallsInProgressSamples is 60.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
215
Chapter 2: All Tables
Peripheral_Half_Hour Table