Cisco Cisco IP Contact Center Release 4.6.2 Technical References
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
Option
EnterpriseAgentGroupID
Identifies the enterprise agent group.
int
PK, FK, IE1,
NOT NULL
NOT NULL
SkillTargetID
Identifies an Agent that is a member of the enterprise
agent group.
agent group.
int
PK, FK, IE2,
NOT NULL
NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-65 Enterprise_Route Table
Field Name
Description
Data Type
Keys and Null
Option
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.
which this enterprise route belongs.
int
AK1, FK, NOT
NULL
NULL
EnterpriseName
An enterprise name for this enterprise route. This name
must be unique among all enterprise routes within the
business entity.
must be unique among all enterprise routes within the
business entity.
varchar(32)
AK1, NOT
NULL
NULL
Description
Additional information about the enterprise route.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL