/mcpTable 186: Fields in Enterprise_Route_Member Table Keys and NULL Option Data Type Description Name PK, FK NOT NULL DBINT Foreign key from the Enterprise_Route table. EnterpriseRouteID PK, FK NOT NULL DBINT Foreign key from the Route table. RouteID Enterprise_Service This table is one of the Enterprise tables (see Enterprise, on page 621). For database rules see Enterprise Tables, on page 699. Each row defines an enterprise-wide service composed of services from different peripherals. Use Unified ICM Configuration Manager to add, update, and delete Enterprise_Service records. Related Tables Business_Entity, on page 107 (via EntityID) Enterprise_Service_Member, on page 254 (via EnterpriseServiceID) Table 187: Indexes for Enterprise_Service Table index_keys index_description index_name EntityID, EnterpriseName nonclustered, unique, unique key located on PRIMARY XAK1Enterprise_Service EnterpriseServiceID clustered, unique, primary key located on PRIMARY XPKEnterprise_Service Table 188: Fields in Enterprise_Service Table Keys and NULL Option Data Type Description Name NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NULL DESCRIPTION Additional information about the enterprise service. Description Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 253 All Tables Enterprise_Service