Technical References

Service_Member Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
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.
Related tables
Service (page 325) (ServiceSkillTargetID maps to Service.SkillTargetID)
Skill Group (page 364) (SkillGroupSkillTargetID maps to Skill_Group.SkillTargetID)
Table 192: Indexes for Service_Member Table
index_keysindex_descriptionindex_name
SkillGroupSkillTargetIDnonclustered located on PRIMARYXIE1Service_Member
ServiceSkillTargetID,
SkillGroupSkillTargetID
clustered, unique, primary key
located on PRIMARY
XPKService_Member
Fields in Service_Member Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBSMALLINT
The priority level of the specified service for the specified skill
group:
Priority
• 1 = Primary
• 2= Secondary
Any number of skill entries can be of any priority—not all
need to be entered.
PK, FK NOT NULLDBINT
SkillTargetID of the service.
ServiceSkillTargetID
PK, FK NOT NULLDBINT
SkillTargetID of the skill group that is associated with the
service.
SkillGroupSkillTargetID
Service_Real_Time Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
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