Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 404
 
2-81
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Enterprise_Service_Member Table
Related tables:
Business Entity (via EntityID)
Enterprise Service Member (via EnterpriseServiceID)
Enterprise_Service_Member Table
Maps services to enterprise services.
Use ICM Configuration Manager to add or delete Enterprise_Service_Member records.
Related tables:
Enterprise Service (via EnterpriseServiceID)
Service (via SkillTargetID)
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.
Table 2-68 Enterprise_Service_Member Table
Field Name
Description
Data Type
Keys and Null 
Option
EnterpriseServiceID
Foreign key from the Enterprise Service table.
int
PK, FK, NOT 
NULL
SkillTargetID
Foreign Key from the Service table.
int
PK, FK, NOT 
NULL
Table 2-69 Enterprise_Skill_Group Table
Field Name
Description
Data Type
Keys and Null 
Option
EnterpriseSkillGroupID
Unique identifier for this enterprise skill group.
int
PK, NOT NULL
EntityID
If partitioning is enabled, indicates the business entity to 
which the enterprise skill group belongs.
int
AK1, FK, NOT 
NULL
EnterpriseName
An enterprise name for this enterprise skill group. This 
name must be unique among all enterprise skill groups 
within the business entity.
varchar(32)
AK1, NOT 
NULL
Description
Additional information about the enterprise skill group.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL