Technical References

Related tables
Enterprise Service (page 175) (via EnterpriseServiceID)
Service (page 325) (via SkillTargetID)
Table 86: Indexes for Enterprise_Service_Member Table
index_keysindex_descriptionindex_name
SkillTargetIDnonclustered located on PRIMARYXIE1Enterprise_Service_Member
EnterpriseServiceID, SkillTargetIDclustered, unique, primary key
located on PRIMARY
XPKEnterprise_Service_Members
Fields in Enterprise_Service_Member Table:
Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
Foreign key from the Enterprise Service table.
EnterpriseServiceID
PK, FK, IE-1 NOT NULLDBINT
Foreign Key from the Service table.
SkillTargetID
Enterprise_Skill_Group Table
This table is one of the Enterprise tables (page 443). For database rules click here (page 506).
Each row defines an enterprise-wide skill group composed of skill groups from different
peripherals. Use ICM Configuration Manager to add, update, and delete Enterprise_Skill_Group
records.
Related Tables
Business Entity (page 73) (via EntityID)
Enterprise Skill Group Member (page 177) (via EnterpriseSkillGroupID)
Table 87: Indexes for Enterprise_Skill_Group Table
index_keysindex_descriptionindex_name
EntityID, EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Enterprise_Skill_Group
EnterpriseSkillGroupIDclustered, unique, primary key
located on PRIMARY
XPKEnterprise_Skill_Group
Fields in Enterprise_Skill_Group Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the enterprise skill group.
Description
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
176
Chapter 2: All Tables
Enterprise_Skill_Group Table