Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 404
 
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
SkillTargetID
An identifier that is unique among all skill targets 
in the enterprise.
int
PK, FK, NOT 
NULL
ScheduleID
Identifies an imported schedule associated with 
the service.
int
FK, NULL
PeripheralID
Foreign key from the Peripheral table.
smallint
AK2, FK, NOT 
NULL
EnterpriseName
An enterprise name for the service. This name 
must be unique among all the services in the 
enterprise.
varchar(32)
AK1, NOT 
NULL
PeripheralNumber
Service number as known at the peripheral. This 
field together with PeripheralID form an alternate 
unique key.
int
AK2, NOT 
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:
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).
smallint
NOT NULL