Cisco Cisco E-Mail Manager Unity Integration Option Références techniques
2-334
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Service_Member Table
Related tables:
(via MRDomainID)
(via PeripheralID)
Service_Member Table
The Service Member table maps skill groups to services. Each service contains one or more member skill
groups. Each skill group can be a member of one or more services.
groups. Each skill group can be a member of one or more services.
Use the Service Explorer tool to add, update, and delete Service_Member records.
Table 2-348 Service_Level_Threshold Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
MRDomainID
Foreign key from the Media_Routing_Domain
table.
table.
DBINT
PK
NOT NULL
PeripheralID
The ICM ID of the peripheral with which this row
is associated.
is associated.
DBSMALLINT
PK, FK
NOT NULL
ServiceLevelThreshold
The default value of the ServiceLevelThreshold
field for services associated with this peripheral
and media routing domain.
field for services associated with this peripheral
and media routing domain.
DBSMALLINT
NOT NULL
ServiceLevelType
The default value for the ServiceLevelType field
for each service associated with this peripheral
and media routing domain. This value indicates
how the ICM software calculates the service level.
for each service associated with this peripheral
and media routing domain. This value indicates
how the ICM software calculates the service level.
For IPCC Enterprise the value of this field is
always 1 (ignore abandoned calls) for
CallManager peripherals. This is because calls to
a CallManager peripheral have no service
associated with them while they are queued, and
therefore calls abandoned while queued cannot
affect the computation of service level for a
CallManager service.
always 1 (ignore abandoned calls) for
CallManager peripherals. This is because calls to
a CallManager peripheral have no service
associated with them while they are queued, and
therefore calls abandoned while queued cannot
affect the computation of service level for a
CallManager service.
DBSMALLINT
NOT NULL
Table 2-349 Service_Member Table Constraints
Constraint
Field Name(s)
PK
ServiceSkillTargetID
SkillGroupSkillTargetID
SkillGroupSkillTargetID
FK
ServiceSkillTargetID
SkillGroupSkillTargetID
SkillGroupSkillTargetID
IE-1
SkillGroupSkillTargetID