Technical References

Keys and Null Option:Data Type:Description:Field Name:
AK-1 NOT NULLVNAME32
An enterprise name for this enterprise skill group. This name
must be unique among all enterprise skill groups within the
business entity.
EnterpriseName
PK NOT NULLDBINT
Unique identifier for this enterprise skill group.
EnterpriseSkillGroupID
AK-1, FK NOT NULLDBINT
If partitioning is enabled, indicates the business entity to which
the enterprise skill group belongs.
EntityID
Enterprise_Skill_Group_Member Table
This table is one of the Enterprise tables (page 443). For database rules click here (page 506).
It maps skill groups to enterprise skill groups. Use ICM Configuration Manager to add or delete
Enterprise_Skill_Group_Member records
Related tables
Enterprise Skill Group (page 176) (via EnterpriseSkillGroupID)
Skill Group (page 364) (via SkillTargetID)
Table 88: Indexes for Enterprise_Skill_Group_Member Table
index_keysindex_descriptionindex_name
SkillTargetIDnonclustered located on PRIMARYXIE1Enterprise_Skill_Group_Mem
EnterpriseSkillGroupID, SkillTargetIDclustered, unique, primary key
located on PRIMARY
XPKEnterprise_Skill_Members
Fields in Enterprise_Skill_Group_Member Table:
Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
Foreign Key from the Enterprise Skill Group table.
EnterpriseSkillGroupID
PK, FK, IE-1 NOT NULLDBINT
Foreign Key from the Skill Group table.
SkillTargetID
Event Table
This table is in the System category (page 460). To see database rules for these tables, click here
(page 511).
Central database only.
Contains system events generated by the ICM software.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
177
Chapter 2: All Tables
Enterprise_Skill_Group_Member Table