Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 548
   
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.
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
MRDomainID
Foreign key from the Media_Routing_Domain 
table.
DBINT
PK
NOT NULL
PeripheralID
The ICM ID of the peripheral with which this row 
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.
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 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.
DBSMALLINT
NOT NULL
Table 2-349 Service_Member Table Constraints
Constraint
Field Name(s)
PK
ServiceSkillTargetID
SkillGroupSkillTargetID
FK
ServiceSkillTargetID
SkillGroupSkillTargetID
IE-1
SkillGroupSkillTargetID