Cisco Cisco IPCC Web Option Technical References
Service_Member Table
. To see database rules for these tables, click
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.
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.
Related tables
(ServiceSkillTargetID maps to Service.SkillTargetID)
(SkillGroupSkillTargetID maps to Skill_Group.SkillTargetID)
Table 192: Indexes for Service_Member Table
index_keys
index_description
index_name
SkillGroupSkillTargetID
nonclustered located on PRIMARY
XIE1Service_Member
ServiceSkillTargetID,
SkillGroupSkillTargetID
SkillGroupSkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKService_Member
Fields in Service_Member Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBSMALLINT
The priority level of the specified service for the specified skill
group:
group:
Priority
• 1 = Primary
• 2= Secondary
Any number of skill entries can be of any priority—not all
need to be entered.
need to be entered.
PK, FK NOT NULL
DBINT
SkillTargetID of the service.
ServiceSkillTargetID
PK, FK NOT NULL
DBINT
SkillTargetID of the skill group that is associated with the
service.
service.
SkillGroupSkillTargetID
Service_Real_Time Table
. To see database rules for these tables, click
Local database only. Contains real time information about each service.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
347
Chapter 2: All Tables
Service_Member Table