COMMUNICATIONEXCLUSIONS (4.0SP20)

ID

uniqueidentifier

SEGMENTATIONID

uniqueidentifier

true

FK to MKTSEGMENTATION

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

IDSETREGISTERID

uniqueidentifier

true

FK to IDSETREGISTER

EXCLUDEBASEDONRECENTCOMMUNICATION

bit

false

Indicates whether or not the system should exclude constituents that have received a communication within a chosen range from the communication's mail date.

NUMRECENTCOMMUNICATIONPERIODS

int

false

The number of periods to be considered when defining the 'recent' communications.

RECENTCOMMUNICATIONPERIODTYPECODE

tinyint

false

The period by which to define 'recent' communications.

RECENTCOMMUNICATIONPERIODTYPE

nvarchar(8) (Computed)

true

Provides a translation for the 'RECENTCOMMUNICATIONPERIODTYPECODE' field.

EXCLUDEBASEDONTOTALCOMMUNICATIONSINPASTYEAR

bit

false

Indicates whether or not the system should exclude constituents that have received a certain number of communications within the past year.

NUMTOTALCOMMUNICATIONSINPASTYEAR

int

false

The number of communications within the past year by which to exclude constituents.

EXCLUDEBASEDONRECENTGIVING

bit

false

Indicates whether or not the system should exclude constituents that have given within a chosen range from the communication's mail date.

NUMRECENTGIVINGPERIODS

int

false

The number of periods to be considered when defining the recent giving.

RECENTGIVINGPERIODTYPECODE

tinyint

false

The period by which to define recent giving.

RECENTGIVINGPERIODTYPE

nvarchar(8) (Computed)

true

Provides a translation for the 'RECENTGIVINGPERIODTYPECODE' field.

EXCLUDEBASEDONTOTALGIVINGINPASTYEAR

bit

false

Indicates whether or not the system should exclude constituents that have given a certain amount or more during the past year.

TOTALREVENUEAMOUNTINPASTYEAR

money

false

The total amount of revenue received from a constituent within the last year by which to exclude constituents.

ISSYSTEMDEFAULT

bit

false

Indicates whether or not this record represents the system default communication exclusions.

CONSIDERSPECIFICDESIGNATIONS

bit

false

Indicates whether or not only specific designations should be considered when calculating recent giving.

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

IX_COMMUNICATIONEXCLUSIONS_DATEADDED

False

False

True

IX_COMMUNICATIONEXCLUSIONS_DATECHANGED

False

False

False

IX_COMMUNICATIONEXCLUSIONS_IDSETREGISTERID

False

False

False

IX_COMMUNICATIONEXCLUSIONS_SEGMENTATIONID

False

False

False

PK_COMMUNICATIONEXCLUSIONS

True

True

False

TR_COMMUNICATIONEXCLUSIONS_AUDIT_UPDATE

TR_COMMUNICATIONEXCLUSIONS_AUDIT_DELETE

COMMUNICATIONEXCLUSIONCOMMUNICATIONTYPES

COMMUNICATIONEXCLUSIONID