Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 620
Related tables
 (via SkillTargetID)
Table 86: Indexes for Enterprise_Service_Member Table
index_keys
index_description
index_name
SkillTargetID
nonclustered located on PRIMARY
XIE1Enterprise_Service_Member
EnterpriseServiceID, SkillTargetID
clustered, 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 NULL
DBINT
Foreign key from the Enterprise Service table.
EnterpriseServiceID
PK, FK, IE-1 NOT NULL
DBINT
Foreign Key from the Service table.
SkillTargetID
Enterprise_Skill_Group Table
This table is one of the 
. For database rules click 
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
 (via EntityID)
 (via EnterpriseSkillGroupID)
Table 87: Indexes for Enterprise_Skill_Group Table
index_keys
index_description
index_name
EntityID, EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1Enterprise_Skill_Group
EnterpriseSkillGroupID
clustered, 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 NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
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