Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-144
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Enterprise_Skill_Group Table
Enterprise_Skill_Group Table
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 2-139 Enterprise_Skill_Group Table Constraints
Constraint
Field Name(s)
PK
EnterpriseSkillGroupID
AK-1
EnterpriseName
EntityID
EntityID
FK
EntityID
Table 2-140 Enterprise_Skill_Group Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
Description
Additional information about the enterprise skill
group.
group.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for this enterprise skill group.
This name must be unique among all enterprise
skill groups within the business entity.
This name must be unique among all enterprise
skill groups within the business entity.
VNAME32
AK-1
NOT NULL
EnterpriseSkillGroupID
Unique identifier for this enterprise skill group.
DBINT
PK
NOT NULL
EntityID
If partitioning is enabled, indicates the business
entity to which the enterprise skill group belongs.
entity to which the enterprise skill group belongs.
DBINT
AK-1, FK
NOT NULL