Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-202
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Service Table
Related tables:
Enterprise Service Member (via SkillTargetID)
Media Routing Domain (via MRDomainID)
Peripheral (via PeripheralID)
Route (via SkillTargetID)
Schedule (via ScheduleID)
Service Array Member (SkillTargetID maps to Service_Array_Member.ServiceSkillTargetID)
ServiceLevelType
Indicates how the ICM software calculates the
service level for the service:
service level for the service:
0 = Use the default specified for the associated
peripheral.
peripheral.
1 = Ignore Abandoned Calls. (Remove the
abandoned calls from the calculation.)
abandoned calls from the calculation.)
2 = Abandoned Calls have Negative Impact.
(Treat the abandoned calls as though they
exceeded the service level threshold.)
(Treat the abandoned calls as though they
exceeded the service level threshold.)
3 = Abandoned Calls have Positive Impact.
(Treat the abandoned calls as through they were
answered within the service level threshold.)
(Treat the abandoned calls as through they were
answered within the service level threshold.)
Note
Regardless of which calculation you
choose, the ICM software always tracks
separately the number of calls abandoned
before the threshold expired.
choose, the ICM software always tracks
separately the number of calls abandoned
before the threshold expired.
smallint
NOT NULL
ServiceLevelThreshold
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.
ICM service level. If this field is negative, the
value of the ServiceLevelThreshold field in the
Peripheral table is used.
smallint
NOT NULL
Extension
The extension number for the skill group (used by
the Definity ECS ACD).
the Definity ECS ACD).
varchar(10)
NULL
ConfigParam
A string of parameters the ICM software sends to
the peripheral to initialize the service.
the peripheral to initialize the service.
varchar(255)
NULL
Description
Additional information about the service.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
char(1)
NOT NULL
MRDomainID
The Media Routing Domain associated with this
service.
service.
int
FK NOT NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
int
NOT NULL
Table 2-166 Service Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option