McDewey

Storage Description Field Name Varchar(20, 0) NOT NULL Receiving protocol that is used to communicate with the channel provider. receiveprotocol int NOT NULL 16-bit port number that is used to communicate with the channel provider for receiving the channel type. receiveserverport Lvarchar(400) Description of the channel provider. description Boolean NOT NULL Indicates whether the record is currently active or not. A record becomes inactive if the record is deleted or updated from the system. f = Inactive t = Active active datetime year to second If the active field is "f", this field indicates the date and time that the record became inactive. dateinactive Lvarchar(25) Indicates whether Enable/Disable option is selected for SOCKS Proxy in Mail server configuration page. proxytype boolean NOT NULL Indicates if HTTP proxy is used to connect to the mail server. Default value: f usehttpproxy Lvarchar(50) Indicates the mail server type. The default is microsoft. mailservertype Related Topics ContactServiceQueue , on page 47 ChatProblemStatement Database table name: ChatProblemStatement This table contains the associated problem statements and tag ids for each chat widget. Chat widget is the widget that enables the Unified CCX Administrator to create a chat interface for the end user. Table 19: ChatProblemStatement Table Fields Storage Description Field Name int NOT NULL Primary Key Unique ID for each chat widget. It is the foreign key which associates this table with the chatwidget table. wdID Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 26 Database Schema ChatProblemStatement