Technical References
Keys and Null
Option:
Data Type:Description:Field Name:
NULLVTELNO10
The extension number for the skill group (used by the Definity ECS
ACD).
Extension
FK NOT NULLDBINT
The Media Routing Domain associated with this service.
MRDomainID
AK-2, FK NOT
NULL
DBSMALLINT
Foreign key from the Peripheral table.
PeripheralID
NOT NULLVNAME32
Service name as known at the peripheral.
PeripheralName
AK-2 NOT NULLDBINT
Service number as known at the peripheral. This field together with
PeripheralID form an alternate unique key.
PeripheralNumber
NOT NULLDBSMALLINT
Type of service level calculation to be used in the
PeriphServiceLevel fields of Service Real Time and Service Half
Hour tables. Valid Aspect types are:
PeripheralServiceLevelType
• 1 = Service Level 1
• 2 = Service Level 2
• 3 = Service Level 3
• 4 = Service Level as Calculated by Call Center.
If this field is 0 for a service, the ICM software assumes the default
specified for the associated peripheral.
If the peripheral is not an Aspect ACD, the type must be 4
(calculated by the peripheral)
FK, IE-1 NULLDBINT
Identifies an imported schedule associated with the service.
ScheduleID
NOT NULLDBINT
The service level threshold, in seconds, for the ICM service level.
If this field is negative, the value of the ServiceLevelThreshold
field in the Peripheral table is used.
ServiceLevelThreshold
NOT NULLDBSMALLINT
For Non-IPCC Enterprise, indicates how the ICM software
calculates the service level for the service:
ServiceLevelType
• 0 = Use the default specified for the associated peripheral.
• 1 = Ignore Abandoned Calls. (Remove the abandoned calls from
the calculation.)
• 2 = Abandoned Calls have Negative Impact. (Treat the abandoned
calls as though they exceeded the service level threshold.)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
327
Chapter 2: All Tables
Service Table