Cisco Cisco IPCC Web Option Technical References
2-142
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Enterprise_Service Table
Enterprise_Service Table
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:
(via EntityID)
(via EnterpriseServiceID)
Table 2-135 Enterprise_Service Table Constraints
Constraint
Field Name(s)
PK
EnterpriseServiceID
AK-1
EnterpriseName
EntityID
EntityID
FK
EntityID
Table 2-136 Enterprise_Service 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
service.
service.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for this enterprise service.
This name must be unique among all enterprise
services within the business entity.
This name must be unique among all enterprise
services within the business entity.
VNAME32
AK-1
NOT NULL
EnterpriseServiceID
Unique identifier for this enterprise service.
DBINT
PK
NOT NULL
EntityID
If partitioning is enabled, indicates the business
entity to which the enterprise service belongs.
entity to which the enterprise service belongs.
DBINT
AK-1, FK
NOT NULL