Cisco Cisco IP Contact Center Release 4.6.1 Technical References
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.
peripherals. Use ICM Configuration Manager to add, update, and delete Enterprise_Skill_Group
records.
Related Tables
(via EntityID)
(via EnterpriseSkillGroupID)
Table 86: Indexes for Enterprise_Skill_Group Table
index_keys
index_description
index_name
EntityID, EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Enterprise_Skill_Group
EnterpriseSkillGroupID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKEnterprise_Skill_Group
Fields in Enterprise_Skill_Group Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the enterprise skill
group.
group.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for this enterprise skill
group. This name must be unique among all
enterprise skill groups within the business entity.
group. This name must be unique among all
enterprise skill groups within the business entity.
EnterpriseName
PK NOT NULL
DBINT
Unique identifier for this enterprise skill group.
EnterpriseSkillGroupID
AK-1, FK NOT NULL
DBINT
If partitioning is enabled, indicates the business
entity to which the enterprise skill group
belongs.
entity to which the enterprise skill group
belongs.
EntityID
Enterprise_Skill_Group_Member Table
This table is one of the
. For database rules click
It maps skill groups to enterprise skill groups. Use ICM Configuration Manager to add or delete
Enterprise_Skill_Group_Member records
Enterprise_Skill_Group_Member records
Related tables
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
141
Chapter 2: All Tables
Enterprise_Skill_Group Table