Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Foreign key from the Route table.
RouteID
Enterprise_Service Table
This table is one of the
. For database rules click
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.
Use ICM Configuration Manager to add, update, and delete Enterprise_Service records.
Related tables
(via EntityID)
(via EnterpriseServiceID)
Table 85: Indexes for Enterprise_Service Table
index_keys
index_description
index_name
EntityID, EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Enterprise_Service
EnterpriseServiceID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKEnterprise_Service
Fields in Enterprise_Service Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the enterprise service.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for this enterprise service. This name must
be unique among all enterprise services within the business entity.
be unique among all enterprise services within the business entity.
EnterpriseName
PK NOT NULL
DBINT
Unique identifier for this enterprise service.
EnterpriseServiceID
AK-1, FK NOT NULL
DBINT
If partitioning is enabled, indicates the business entity to which
the enterprise service belongs.
the enterprise service belongs.
EntityID
Enterprise_Service_Member Table
This table is one of the
. For database rules click
It maps services to enterprise services. Use ICM Configuration Manager to add or delete
Enterprise_Service_Member records.
Enterprise_Service_Member records.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
175
Chapter 2: All Tables
Enterprise_Service Table