/mcpTable 389: Fields in 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 varchar(255) Incremented when the record is changed in the central database. ConfigParam NULL DBDATETIME Records the date and time when the record was added/updated. DateTimeStamp NOT NULL DBCHAR Deleted Flag. Stored as a character: • Y = Yes • N = No Deleted NULL DESCRIPTION Additional information about the service. Description NULL DBINT A unique identifier that identifies a department in CCDM/CCMP deployment. DepartmentID AK-1 NOT NULL VNAME32 An enterprise name for the service. This name must be unique among all the services in the enterprise. EnterpriseName NULL VTELNO10 The extension number for the skill group (used by the Definity ECS ACD). Extension FK NOT NULL DBINT The Media Routing Domain associated with this service. MRDomainID AK-2, FK NOT NULL DBSMALLINT Foreign key from the Peripheral table. PeripheralID NOT NULL VNAME32 Service name as known at the peripheral. PeripheralName AK-2 NOT NULL DBINT Service number as known at the peripheral. This field together with PeripheralID form an alternate unique key. PeripheralNumber Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 453 All Tables Service