McDewey

Storage Description Field Name smallint NOT NULL Indicates whether the calendar is associated with an application or a chat widget. entitytype boolean NOT NULL Indicates wheather the record is deleted. active datetime year to second Date and time when the record was deleted. dateinactive Campaign Database table name: Campaign The campaign configuration information is stored in this table. A campaign is associated with one or more CSQs. This mapping of Campaigns and CSQs is stored separately in CampaignCSQMap table. Table 12: Campaign Table Fields Storage Description Field Name int NOT NULL Primary Key A unique identifier for the record. recordid int NOT NULL Primary Key A unique identifier for the campaign. campaignid int NOT NULL Primary Key Identifier of the Unified CCX profile that is associated with this record. profileid datetime year to second NOT NULL Default -CURRENT_TIMESTAMP createdatetime nvarchar(10) NULL Name of the campaign. Must be unique. campaignname smallint NOT NULL • 0 = campaign is enabled • 1 = campaign is disabled enabled varchar(50) NULL A description of the campaign. description Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 18 Database Schema Campaign