Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-140
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Enterprise_Route Table
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.
Related tables:
(via EntityID)
(via EnterpriseRouteID)
Table 2-131 Enterprise_Route Table Constraints
Constraint
Field Name(s)
PK
EnterpriseRouteID
AK-1
EnterpriseName
EntityID
EntityID
FK
EntityID
Table 2-132 Enterprise_Route Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
Description
Additional information about the enterprise route. DESCRIPTION
NULL
EnterpriseName
An enterprise name for this enterprise route. This
name must be unique among all enterprise routes
within the business entity.
name must be unique among all enterprise routes
within the business entity.
VNAME32
AK-1
NOT NULL
EnterpriseRouteID
Unique identifier for this enterprise route.
DBINT
PK
NOT NULL
EntityID
If partitioning is enabled, indicates the business
entity to which this enterprise route belongs.
entity to which this enterprise route belongs.
DBINT
AK-1, FK
NOT NULL