McDewey

Storage Description Field Name nvarchar (50) NOT NULL Name of the calendar. name DATETIME YEAR TO DAY NOT NULL Date of the special day. caldate boolean NOT NULL Indicates whether the record is currently active or not. f = Inactive t = Active active DATETIME year to second NULL Date and time of the record when it is marked as inactive. dateinactive ChannelProvider Database table name: ChannelProvider This table contains the channel provider configurations, including the type of channel, and server details with fully qualified domain name (FQDN), protocol, and port. Channel providers enable the use of non-interactive media channels such as email with Unified CCX. Table 18: ChannelProvider Table Fields Storage Description Field Name int NOT NULL Primary Key Unique identifier of the channel provider. Server ID is the foreign key that associates this table with the ContactServiceQueue table. Id varchar (20, 0) NOT NULL Type of contact channel. channelType Varchar(255, 0) NOT NULL FQDN of the channel provider for sending the channel type. sendserverfqdn Varchar(20, 0) NOT NULL Sending protocol that is used to communicate with the channel provider. sendprotocol int NOT NULL 16-bit port number that is used to communicate with the channel provider for sending the channel type. sendserverport Varchar(255, 0) NOT NULL FQDN of the channel provider for receiving the channel type. receiveserverfqdn Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 25 Database Schema ChannelProvider