Campaign Filter Groups

OBD_CAMPAIGN_CUSTOMFILTER

CAMPAIGNID

CAMPAIGNID

nvarchar

(64) (not null)

This is the campaign name. For example, Collection.

OBD_CAMPAIGN_CUSTOMFILTER

DAYOFWEEK

DAYOFWEEK

int

(not null)

This value denotes the day of the week configured for the custom filter group to be applied.

OBD_CAMPAIGN_CUSTOMFILTER

HOURFROM

HOURFROM

nvarchar

(64) (not null)

The start hour to filter uploaded contacts for delivery. The default value is 00:00 hours.

OBD_CAMPAIGN_CUSTOMFILTER

HOURTO

HOURTO

nvarchar

(8) (not null)

The end hour to filter uploaded contacts for delivery. The default value is 23:59 hours.

OBD_CAMPAIGN_CUSTOMFILTER

CUSTOMFILTERGROUP

CUSTOMFILTERGROUP

nvarchar

(32) (not null)

The name of the custom filter group applied to the campaign for contact delivery.

OBD_CAMPAIGN_CUSTOMFILTER

Id

Id

int

(not null)

Identity column unique to each record.

OBD_CAMPAIGN_CUSTOMFILTER

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.

OBD_CAMPAIGN_CUSTOMFILTER

SubTenantID

SubTenantID

int

(null)

The Sub Tenant ID autogenerated by the application when a new tenant is created.

OBD_CUSTOMFILTERS

CustomFilterGroupID

CustomFilterGroupID

int

(not null)

The custom filter group ID autogenerated when a new filter group is created.

OBD_CUSTOMFILTERS

CustomFilterGroup

CustomFilterGroup

nvarchar

(32) (not null)

The name of the custom filter group created.

OBD_CUSTOMFILTERS

Description

Description

nvarchar

(32) (null)

The description for the custom filter group.

OBD_CUSTOMFILTERS

CampaignCustoFilters

CampaignCustoFilters

XML

This is an XML containing  the fields Id, CustomFilterGroupID, CustomFilterGroup, Description, CampaignID, IsDefault, TenantID, SubTenantID, and any other fields included by the user. For each Custom Filter Group, all the filter conditions are shown in an XML.

OBD_CUSTOMFILTERS

CampaignCustoFilterGroup1

CampaignCustoFilterGroup1

XML

This is an XML.  Illustrative fields are: Id, CustomFilterGroup, CampaignID, ConditionID, ConditionName, ConditionSTR, ConditionQuery, IsEnabled, ContPercent, SequenceID, SystemConditions, OrderBy, and IsDeleted. For each Custom Filter Group, all the filter conditions are shown in an XML.

OBD_CUSTOMFILTERS

CampaignID

CampaignID

nvarchar

(64) (not null)

This is the campaign name this custom filter group belongs to. For example, Collection.

OBD_CUSTOMFILTERS

IsDefault

IsDefault

bit

(null)

Specifies if this is the default custom filter group for the campaign.

OBD_CUSTOMFILTERS

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.

OBD_CUSTOMFILTERS

SubTenantID

SubTenantID

int

(null)

The Sub Tenant ID autogenerated by the application when a new tenant is created.

OBD_CUSTOMFILTERGROUP

CustomFilterGroup

CustomFilterGroup

nvarchar

(32) (not null)

The name of the custom filter group.

OBD_CUSTOMFILTERGROUP

CampaignID

CampaignID

nvarchar

(64) (not null)

This is the campaign name this custom filter group belongs to. For example, Collection.

OBD_CUSTOMFILTER

ConditionID

ConditionID

int

(not null)

The condition ID autogenerated by the application when a condition is created.

OBD_CUSTOMFILTER

ConditionName

ConditionName

nvarchar

(64) (null)

The condition name for the condition part of this filter group.

OBD_CUSTOMFILTER

ConditionSTR

ConditionSTR

nvarchar

(max) (null)

The string that is part of the condition.

OBD_CUSTOMFILTER

ConditionQRY

ConditionQRY

nvarchar

(max) (null)

The query that is part of the condition.

OBD_CUSTOMFILTER

Enabled

Enabled

int

(null)

Specifies if this condition is enabled.

OBD_CUSTOMFILTER

ContPercent

ContPercent

numeric

(5, 2) (null)

Defines the percentage of contacts processed for each condition.

OBD_CUSTOMFILTER

SequenceID

SequenceID

int

(null)

The sequence ID generated for this condition.

OBD_CUSTOMFILTER

SysConditions

SysConditions

nvarchar

(64) (null)

The system conditions to filter the contacts with.

OBD_CUSTOMFILTER

OrderBy

OrderBy

nvarchar

(2048) (null)

The order in which the data satisfying the condition should be shown.

OBD_CUSTOMFILTER

TargetGroupName

TargetGroupName

nvarchar

(64) (null)

Not in use.

OBD_CUSTOMFILTER

IsDeleted

IsDeleted

bit

(null)

Specifies if this condition is deleted and cannot be used.

OBD_CUSTOMFILTER

ConditionType

ConditionType

int

(null)

Not in use.

OBD_CUSTOMFILTER

PaceID

PaceID

nvarchar

(16) (null)

The pacing mode ID.

The following pacing modes are applicable for Cisco CCE and Cisco CCX:

1 for Predictive Only

2 for Predictive Blended

3 for Preview Only

4 for Preview Blended

5 for Progressive Only

6 for Progressive Blended

7 for Direct preview Only

8 for Direct preview Blended.

OBD_CUSTOMFILTER

ZoneNameMapped

ZoneNameMapped

nvarchar

(max) (null)

The zone name mapped to this condition.

OBD_CUSTOMFILTER

ExportedConditionID

ExportedConditionID

int

(null)

Not in use.

OBD_CUSTOMFILTER

ConditionSTRInfo

ConditionSTRInfo

nvarchar

(max) (null)

The condition based on which contacts are filtered.

OBD_CUSTOMFILTERGROUP

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.