Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 OPTIONCODE tinyint   Default = 0 The type of business process being run
 OPTION nvarchar(16) (Computed) CASE [OPTIONCODE] WHEN 0 THEN N'Fast process' WHEN 1 THEN N'Detailed process' WHEN 2 THEN N'Custom settings' END Provides a translation for the 'OPTIONCODE' field.
 ISINCREMENTAL bit   Default = 0 Only process constituents that were added or updated since this business process last ran
 LASTRUNON datetime The time this constituent duplicate search process last ran
 ISEXHAUSTIVE bit   Default = 0 Indicates whether a search will narrow its results by comparing tokens of the name and address.
 CHECKPHONE bit   Default = 1 Constituent phone parameter for match
 CHECKEMAIL bit   Default = 1 Email Address match parameter
 REQUIRESECONDARYMATCH bit   Default = 1 Indicates whether or not the constituents must have a secondary match(phone, address, email etc) to be considered a duplicate.
 MAXMATCHPERCONSTITUENT tinyint   Default = 10 The maximum number of constituents that one constituent can be matched against.
 NAMEMATCHTHRESHOLD decimal(20, 4)   Default = 70 The match percentage a record's name must pass to be included in duplicate search results.
 ADDRESSMATCHTHRESHOLD decimal(20, 4)   Default = 70 The match percentage a record's address must pass to be included in duplicate search results.
 OVERALLMATCHTHRESHOLD decimal(20, 4)   Default = 70 The overall match percentage a record must pass to be included in duplicate search results.
 CHECKSTATE bit   Default = 1 Constituent state parameter for match
 CHECKPOSTCODE bit   Default = 1 Constituent zip parameter for match
 LEFTPOSTCODECOUNT tinyint   Default = 3 The number of left-most digits of a zipcode that will be considered while performing duplicate searches.
 CHECKCOUNTRY bit   Default = 1 Constituent country parameter for match
 CHECKBIRTHDATE bit   Default = 1 Constituent birth date parameter for match
 CHECKGENDER bit   Default = 1 Constituent gender parameter for match
 CHECKMIDDLENAME bit   Default = 1 Constituent middle name parameter for match
 CHECKMAIDENNAME bit   Default = 1 Constituent middle name parameter for match
 INCLUDEINACTIVE bit   Default = 0 Constituent inactive flag parameter for match
 INCLUDEDECEASED bit   Default = 0 Constituent inactive flag parameter for match
 INCLUDEGROUPS bit   Default = 1 Constituent group flag parameter for match
 INCLUDEORGANIZATIONS bit   Default = 1 Constituent organization flag parameter for match
 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
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID A foreign key to the ID set used to filter the records included in the constituent duplicate search process.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_CONSTITUENTDUPLICATESEARCHPROCESS_DATEADDED DATEADDED    
 IX_CONSTITUENTDUPLICATESEARCHPROCESS_DATECHANGED DATECHANGED      
 PK_CONSTITUENTDUPLICATESEARCHPROCESS ID  
 UC_CONSTITUENTDUPLICATESEARCHPROCESS_NAME NAME    

Trigger Name Description
 TR_CONSTITUENTDUPLICATESEARCHPROCESS_DELETE_BUSINESSPROCESSINSTANCE
 TR_CONSTITUENTDUPLICATESEARCHPROCESS_AUDIT_UPDATE
 TR_CONSTITUENTDUPLICATESEARCHPROCESS_AUDIT_DELETE

Referenced by Field
 CONSTITUENTDUPLICATESEARCHPROCESSEXPORTFORMAT PARAMETERSETID
 CONSTITUENTDUPLICATESEARCHPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table