Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-11
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
CampaignCSQMap
Database table name: CampaignCSQMap
The CampaignCSQMap table shows the relationship between campaigns and contact service queues
(CSQs). A new record is created in the CampaignCSQMap table when a campaign is associated with a
CSQ in Unified CCX Administration.
(CSQs). A new record is created in the CampaignCSQMap table when a campaign is associated with a
CSQ in Unified CCX Administration.
The CampaignCSQMap table contains the fields shown in
Related Tables
•
(via campaignID)
•
(csqID maps to contactServiceQueueID)
ContactCallDetail
Database table name: ContactCallDetail
The Unified CCX system creates a new record in the ContactCallDetail table for each call or call leg
processed by the system. A new call leg starts each time that a call is transferred or redirected, except
when a call is transferred from a Cisco CTI port to an agent.
processed by the system. A new call leg starts each time that a call is transferred or redirected, except
when a call is transferred from a Cisco CTI port to an agent.
Table 1-5
CampaignCSQMap Table Fields
Field Name
Description
Storage
recordid
A unique identifier for the record
int
NOT NULL
Primary Key
campaignid
A unique identifier for the campaign, from the Campaign
table.
table.
int
NOT NULL
Primary Key
csqid
A unique identifier for the CSQ, from the
ContactServiceQueue table.
ContactServiceQueue table.
int
NOT NULL
Primary Key
active
Indicates whether the record is active in the system. A record
becomes inactive if the campaign is deleted from the system.
becomes inactive if the campaign is deleted from the system.
f = Inactive
t = Active
boolean
NULL
createdatetime
Default, CURRENT_TIME_STAMP
datetime year to
second
second
NOT NULL
dateinactive
Date this record was deleted.
datetime year to
second
second
NOT NULL