/mcpTable 233: Fields in Logical_Interface_Controller Table Keys and NULL Option Data Type Description Name NOT NULL DBCHAR Indicate pg to generate all peripheral related historical data based on the ACD time. Default: 'N' ACDTimeEnabled NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NOT NULL DBSMALLINT The type of client the controller provides the interface for. ClientType NULL varchar(255) String containing information, such as logon information, specific to the interface controller device. For example: -rtuser UserName -rtpswd Password ConfigParam NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NOT NULL DBCHAR Deleted Flag. Stored as a character: • Y = Yes • N = No Deleted NULL DESCRIPTION Additional information about the controller. Description AK-1 NOT NULL VNAME32 An enterprise name for the controller. This name must be unique for all logical controllers in the enterprise. EnterpriseName YES DBINT The value indicates PG to calculate historical data at that interval. Default: 30 HistoricalReportingInterval PK NOT NULL DBSMALLINT Unique identifier for this logical controller. LogicalControllerID NOT NULL DBSMALLINT The Interface Controller type: • 2 = PG • 3 = NIC LogicalControllerType NULL varchar(32) The address for CTI Server as IP:port (either in dotted-numeric or name format). PrimaryCtiAddress NULL varchar(32) The address for the backup CTI Server as IP:port (either in dotted-numeric or name format) SecondaryCtiAddress Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 289 All Tables Logical_Interface_Controller