Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 DESCRIPTION nvarchar(255)   Default = '' The description of the parameter set.
 TARGETCRITERIA tinyint   Default = 0 Indicates the method that should be used to select the target record for each group of duplicate constituents.
 MINSIMILARITY decimal(3, 2)   Default = 0.8 Duplicate matches that do not have a similarity that is greater than or equal to this number will be excluded from the merge process.
 DELETEDUPES bit   Default = 1 Delete duplicate constituents once they have been merged.
 INDIVIDUALSONLY bit   Default = 0 Exclude duplicate matches between organizations from the merge process.
 OMITINDORGMATCHES bit   Default = 1 Exclude duplicate matches between an individual and an organization from the merge process
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not a constituent selection should be created as a result of the constituent merge process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output selection to be created by the constituent merge process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output selection if one with the same name already exists.
 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.
 CONSTITUENTINACTIVITYDETAILS nvarchar(300)   Default = ''

Foreign Key Field Type Null Notes Description
 MERGECONFIGURATIONID uniqueidentifier   MERGECONFIGURATION.ID A foreign key to the merge configuration to be used for the merge process
 SOURCETABLEID uniqueidentifier   DUPLICATECONSTITUENTSEARCHRESULTSTABLE.ID A foreign key to the results table that contains the duplicate constituent records
 FILTERSELECTIONID uniqueidentifier IDSETREGISTER.ID A foreign key to the Selection of constituents used to indicate records that should be excluded from the constituent merge process.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CONSTITUENTINACTIVITYREASONCODEID uniqueidentifier CONSTITUENTINACTIVITYREASONCODE.ID FK to CONSTITUENTINACTIVITYREASONCODE

Index Name Field(s) Unique Primary Clustered
 IX_CONSTITUENTMERGEPROCESS_DATEADDED DATEADDED    
 IX_CONSTITUENTMERGEPROCESS_DATECHANGED DATECHANGED      
 PK_CONSTITUENTMERGEPROCESS ID  
 UC_CONSTITUENTMERGEPROCESS_NAME NAME    

Trigger Name Description
 TR_CONSTITUENTMERGEPROCESS_AUDIT_UPDATE
 TR_CONSTITUENTMERGEPROCESS_AUDIT_DELETE

Referenced by Field
 CONSTITUENTMERGEPROCESSEXPORTFORMAT PARAMETERSETID
 CONSTITUENTMERGEPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table