Technical References

Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
Foreign key from the Route table.
RouteID
Enterprise_Service Table
This table is one of the Enterprise tables (page 443). For database rules click here (page 506).
Each row defines an enterprise-wide service composed of services from different peripherals.
Use ICM Configuration Manager to add, update, and delete Enterprise_Service records.
Related tables
Business Entity (page 73) (via EntityID)
Enterprise Service Member (page 175) (via EnterpriseServiceID)
Table 85: Indexes for Enterprise_Service Table
index_keysindex_descriptionindex_name
EntityID, EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Enterprise_Service
EnterpriseServiceIDclustered, unique, primary key
located on PRIMARY
XPKEnterprise_Service
Fields in Enterprise_Service 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 service.
Description
AK-1 NOT NULLVNAME32
An enterprise name for this enterprise service. This name must
be unique among all enterprise services within the business entity.
EnterpriseName
PK NOT NULLDBINT
Unique identifier for this enterprise service.
EnterpriseServiceID
AK-1, FK NOT NULLDBINT
If partitioning is enabled, indicates the business entity to which
the enterprise service belongs.
EntityID
Enterprise_Service_Member Table
This table is one of the Enterprise tables (page 443). For database rules click here (page 506).
It maps services to enterprise services. Use ICM Configuration Manager to add or delete
Enterprise_Service_Member records.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
175
Chapter 2: All Tables
Enterprise_Service Table