McDewey

Table 93: Fields in Campaign_Half_Hour Table Keys and NULL Option Data Type Description Name AK1NULL 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 beginning 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 NULL DBINT Reserved for future use. FutureUseInt2 NULL DBINT Reserved for future use. FutureUseInt3 NULL DBINT Reserved for future use. FutureUseInt4 NULL DBINT Reserved for future use. FutureUseInt5 NOT NULL DBFLT8 Unique record identifier. RecoveryKey PK NOT NULL DBINT The Central Controller’s time zone for the date and time. The value is the offset in minutes from UTC (formerly GMT).The value is negative for time zones to the east of UTC and positive for time zones to the west of UTC. TimeZone Campaign_Query_Rule This table is in the Blended Agent category (see Blended Agent (Outbound Option), on page 616). To see database rules for these tables, see Blended Agent Tables (Outbound Option), on page 695. It contains a set of associations between query rules and campaigns. If Outbound Option was not selected during setup, this table will contain no data. Note Use the Outbound Option Configuration option within Unified ICM Configuration Manager to modify Campaign_Query_Rule records. Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 166 All Tables Campaign_Query_Rule