Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 EXCLUDEBASEDONRECENTCOMMUNICATION bit   Default = 1 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   Default = 4 The number of periods to be considered when defining the 'recent' communications.
 RECENTCOMMUNICATIONPERIODTYPECODE tinyint   Default = 0 The period by which to define 'recent' communications.
 RECENTCOMMUNICATIONPERIODTYPE nvarchar(8) (Computed) CASE [RECENTCOMMUNICATIONPERIODTYPECODE] WHEN 0 THEN N'weeks' WHEN 1 THEN N'months' WHEN 2 THEN N'quarters' WHEN 3 THEN N'years' END Provides a translation for the 'RECENTCOMMUNICATIONPERIODTYPECODE' field.
 EXCLUDEBASEDONTOTALCOMMUNICATIONSINPASTYEAR bit   Default = 1 Indicates whether or not the system should exclude constituents that have received a certain number of communications within the past year.
 NUMTOTALCOMMUNICATIONSINPASTYEAR int   Default = 12 The number of communications within the past year by which to exclude constituents.
 EXCLUDEBASEDONRECENTGIVING bit   Default = 1 Indicates whether or not the system should exclude constituents that have given within a chosen range from the communication's mail date.
 NUMRECENTGIVINGPERIODS int   Default = 4 The number of periods to be considered when defining the recent giving.
 RECENTGIVINGPERIODTYPECODE tinyint   Default = 0 The period by which to define recent giving.
 RECENTGIVINGPERIODTYPE nvarchar(8) (Computed) CASE [RECENTGIVINGPERIODTYPECODE] WHEN 0 THEN N'weeks' WHEN 1 THEN N'months' WHEN 2 THEN N'quarters' WHEN 3 THEN N'years' END Provides a translation for the 'RECENTGIVINGPERIODTYPECODE' field.
 EXCLUDEBASEDONTOTALGIVINGINPASTYEAR bit   Default = 1 Indicates whether or not the system should exclude constituents that have given a certain amount or more during the past year.
 TOTALREVENUEAMOUNTINPASTYEAR money   Default = 1000 The total amount of revenue received from a constituent within the last year by which to exclude constituents.
 ISSYSTEMDEFAULT bit   Default = 0 Indicates whether or not this record represents the system default communication exclusions.
 CONSIDERSPECIFICDESIGNATIONS bit   Default = 0 Indicates whether or not only specific designations should be considered when calculating recent giving.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 SEGMENTATIONID uniqueidentifier MKTSEGMENTATION.ID FK to MKTSEGMENTATION
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID FK to IDSETREGISTER

Index Name Field(s) Unique Primary Clustered
 IX_COMMUNICATIONEXCLUSIONS_DATEADDED DATEADDED    
 IX_COMMUNICATIONEXCLUSIONS_DATECHANGED DATECHANGED      
 IX_COMMUNICATIONEXCLUSIONS_IDSETREGISTERID IDSETREGISTERID      
 IX_COMMUNICATIONEXCLUSIONS_SEGMENTATIONID SEGMENTATIONID      
 PK_COMMUNICATIONEXCLUSIONS ID  

Trigger Name Description
 TR_COMMUNICATIONEXCLUSIONS_AUDIT_UPDATE
 TR_COMMUNICATIONEXCLUSIONS_AUDIT_DELETE

Referenced by Field
 COMMUNICATIONEXCLUSIONCOMMUNICATIONTYPES COMMUNICATIONEXCLUSIONID

Entity-Relationship diagram of this table