Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas

Página de 718
Campaign_Half_Hour
THIS TABLE IS NOT CURRENTLY BEING USED. IT IS RESERVED FOR FUTURE USE.
Note
This table is in the
category. To see database rules for these tables, see
.
Central database only.
Provides historical reporting for campaign attributes.
Related Tables
(via CampaignID)
Table 85: Indexes for Campaign_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key located
on PRIMARY
XAK1Campaign_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Campaign_Half_Hour
CampaignID, DateTime, TimeZone
clustered, unique primary key located on
PRIMARY
XPKCampaign_Half_Hour
Table 86: Fields in Campaign_Half_Hour Table
Keys and
NULL
Option
Data Type
Description
Name
AK1
NULL
DBINT
Indicates how long in seconds the campaign has
been configured to be active during the current half
hour.
ActiveTimeToHalf
PK, FK
NOT
NULL
DBINT
The unique identifier of the Campaign.
CampaignID
PK NOT
NULL
DBSMALLDATE
The central controller date and time at the start of
the interval.
DateTime
IE1-Indexed
NULL
DBDATETIME
The current date and time stamp when the records
are written to the database.
DbDateTime
NULL
DBINT
Reserved for future use.
FutureUseInt1
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0    
203
All tables
Campaign_Half_Hour