Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-201
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Service Table
Service Table
Each row describes a service available at a peripheral.
Use the Service Explorer tool to add, update, and delete Service records.
Table 2-166 Service Table
Field Name
Description
Data Type
Keys and Null
Option
Option
SkillTargetID
An identifier that is unique among all skill targets
in the enterprise.
in the enterprise.
int
PK, FK, NOT
NULL
NULL
ScheduleID
Identifies an imported schedule associated with
the service.
the service.
int
FK, NULL
PeripheralID
Foreign key from the Peripheral table.
smallint
AK2, FK, NOT
NULL
NULL
EnterpriseName
An enterprise name for the service. This name
must be unique among all the services in the
enterprise.
must be unique among all the services in the
enterprise.
varchar(32)
AK1, NOT
NULL
NULL
PeripheralNumber
Service number as known at the peripheral. This
field together with PeripheralID form an alternate
unique key.
field together with PeripheralID form an alternate
unique key.
int
AK2, NOT
NULL
NULL
PeripheralName
Service name as known at the peripheral.
varchar(32)
NOT NULL
PeripheralServiceLevelType
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:
PeriphServiceLevel fields of Service Real Time
and Service Half Hour tables. Valid Aspect types
are:
1 = Service Level 1
2 = Service Level 2
3 = Service Level 3
4 = Service Level as Calculated by Call Center.
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.
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).
must be 4 (calculated by the peripheral).
smallint
NOT NULL