Technical References

Business Entity (page 73) (via EntityID)
Enterprise Route Member (page 174) (via EnterpriseRouteID)
Table 83: Indexes for Enterprise_Route Table
index_keysindex_descriptionindex_name
EnterpriseName, EntityIDclustered, unique, unique key
located on PRIMARY
XAK1Enterprise_Route
EnterpriseRouteIDnonclustered, unique, primary key
located on PRIMARY
XPKEnterprise_Route
Fields in Enterprise_Route Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the enterprise route.
Description
AK-1 NOT NULLVNAME32
An enterprise name for this enterprise route. This name must be
unique among all enterprise routes within the business entity.
EnterpriseName
PK NOT NULLDBINT
Unique identifier for this enterprise route.
EnterpriseRouteID
AK-1, FK NOT NULLDBINT
If partitioning is enabled, indicates the business entity to which
this enterprise route belongs.
EntityID
Enterprise_Route_Member Table
This table is one of the Enterprise tables (page 443). For database rules click here (page 506).
It maps routes to enterprise routes. Use ICM Configuration Manager to add, update, and delete
Enterprise_Route_Member records.
Related Table
Enterprise Route (page 173) (via EnterpriseRouteID)
Table 84: Indexes for Enterprise_Route_Member Table
index_keysindex_descriptionindex_name
EnterpriseRouteID, RouteIDclustered, unique, primary key
located on PRIMARY
XPKEnterprise_Route_Member
Fields in Enterprise_Route_Member Table:
Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
Foreign key from the Enterprise_Route table.
EnterpriseRouteID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
174
Chapter 2: All Tables
Enterprise_Route_Member Table