McDewey

Storage Description Field Name BLOB NULL Any fields which are used internally only can be stored in this column in a blob. privateData smallint NOT NULL A type of the CSQ. Possible values: 0 – voice CSQ 1 – email CSQ 2 – chat CSQ queueType nvarchar(30,0) NULL The name displayed for the CSQ type. Possible values: • Voice • Chat • Email queueTypeName smallint NOT NULL Type of authentication for email CSQ. The possible values are 0 and 1. • 0=BASIC • 1=OAUTH emailAuthType lvarchar(30000) NULL For Gmail: Downloaded JSON file is stored. Default value: NULL emailOAuthDetails nvarchar(255,0) NULL The userid of the email account mapped to an email CSQ. accountuserId int NULL The unique identifier for the channel provider. channelproviderId int NULL Reserved. reviewQueueId nvarchar(30,0) NULL The type of routing: • Interactive • Noninteractive routingType nvarchar(255,0) NULL The name of the email folder that needs to be polled for mails on the mail server. folderName Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 50 Database Schema ContactServiceQueue