Cisco Cisco IPCC Web Option Technical References
2-82
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Enterprise_Skill_Group_Member Table
Related tables:
Business Entity (via EntityID)
Enterprise Skill Group Member (via EnterpriseSkillGroupID)
Enterprise_Skill_Group_Member Table
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 (via EnterpriseSkillGroupID)
Skill Group (via SkillTargetID)
Event Table
Central database only.
Contains system events generated by the ICM software.
Table 2-70 Enterprise_Skill_Group_Member Table
Field Name
Description
Data Type
Keys and Null
Option
Option
EnterpriseSkillGroupID
Foreign Key from the Enterprise Skill Group table.
int
PK, FK, NOT
NULL
NULL
SkillTargetID
Foreign Key from the Skill Group table.
int
PK, FK, NOT
NULL
NULL
Table 2-71 Event Table
Field Name
Description
Data Type
Keys and Null
Option
Option
CentralControllerVirtualTime
Virtual Time event was processed at the Central
Controller.
Controller.
int
NOT NULL
CentralControllerFileTime
File Time event was processed at the Central
Controller.
Controller.
datetime
IE1, NOT NULL
CentralControllerTimeZone
Time zone at the Central Controller. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
int
NOT NULL
VersionNum
EMS version number.
smallint
NOT NULL