McDewey

Storage Description Field Name smallint NULL Indicates whether the record is active in the system. A record becomes inactive if the campaign is deleted from the system. f = Inactive t = Active active datetime year to second NULL Default, CURRENT_TIME_STAMP createdatetime datetime year to second NULL Date this record was deleted. dateinactive Related Topics Campaign, on page 18 ContactServiceQueue , on page 47 CampaignSupervisorMap Database table name: CampaignSupervisorMap The CampaignSupervisorMap table shows the relationship between campaign and supervisor associated with that campaign. A new record is created in the CampaignSupervisorMap table when a campaign is associated with a supervisor in Unified CCX Administration. Table 14: CampaignSupervisorMap 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, from the Campaign table. campaignid nvarchar(50,0) NOT NULL Primary Key A unique identifier for the supervisor, based on the supervisor’s resourceloginid. supervisorid Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 21 Database Schema CampaignSupervisorMap