Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.1
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Download
Page of 404
 
2-79
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Enterprise_Agent_Group_Member Table
Related tables:
Business Entity (via EntityID)
Enterprise Agent Group Member (via EnterpriseAgentGroupID)
Enterprise_Agent_Group_Member Table
Maps agents to enterprise agent groups.
Use ICM Configuration Manager to add or delete Enterprise_Agent_Group_Member records.
Related tables:
Agent (via SkillTargetID)
Enterprise Agent Group (via EnterpriseAgentGroupID)
Enterprise_Route Table
Each row defines an enterprise-wide route composed of routes from different peripherals.
Use ICM Configuration Manager to add, update, and delete Enterprise_Route records.
Table 2-64 Enterprise_Agent_Group_Member Table
Field Name
Description
Data Type
Keys and Null 
Option
EnterpriseAgentGroupID
Identifies the enterprise agent group.
int
PK, FK, IE1, 
NOT NULL
SkillTargetID
Identifies an Agent that is a member of the enterprise 
agent group.
int
PK, FK, IE2, 
NOT NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL
Table 2-65 Enterprise_Route Table
Field Name
Description
Data Type
Keys and Null 
Option
EnterpriseRouteID
Unique identifier for this enterprise route.
int
PK, NOT NULL
EntityID
If partitioning is enabled, indicates the business entity to 
which this enterprise route belongs.
int
AK1, FK, NOT 
NULL
EnterpriseName
An enterprise name for this enterprise route. This name 
must be unique among all enterprise routes within the 
business entity.
varchar(32)
AK1, NOT 
NULL
Description
Additional information about the enterprise route.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL