USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATESEARCHPROCESS

The save procedure used by the edit dataform template "Constituent Duplicate Search Process Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@OPTIONCODE	tinyint	IN	Option
@IDSETREGISTERID	uniqueidentifier	IN	Selected constituents
@ISEXHAUSTIVE	bit	IN	Match constituents without token filtering
@CHECKPHONE	bit	IN	Match constituents based on phone number
@CHECKEMAIL	bit	IN	Match constituents based on email address
@NAMEMATCHTHRESHOLD	int	IN	Required name confidence level to match
@ADDRESSMATCHTHRESHOLD	int	IN	Required address confidence level to match
@OVERALLMATCHTHRESHOLD	int	IN	Required overall confidence level to match
@CHECKSTATE	bit	IN	State
@CHECKPOSTCODE	bit	IN	Zip;
@LEFTPOSTCODECOUNT	int	IN	Digits required for inexact match
@CHECKCOUNTRY	bit	IN	Country
@CHECKBIRTHDATE	bit	IN	Filter individuals by birth date
@CHECKGENDER	bit	IN	Filter individuals by gender
@CHECKMIDDLENAME	bit	IN	Include middle names in comparison
@CHECKMAIDENNAME	bit	IN	Include maiden names in comparison
@INCLUDEINACTIVE	bit	IN	Include Inactive
@INCLUDEDECEASED	bit	IN	Include Deceased
@INCLUDEGROUPS	bit	IN	Include Groups
@INCLUDEORGANIZATIONS	bit	IN	Include Organizations

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATESEARCHPROCESS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @OPTIONCODE tinyint,
    @IDSETREGISTERID uniqueidentifier,
    @ISEXHAUSTIVE bit,
    @CHECKPHONE bit,
    @CHECKEMAIL bit,
    @NAMEMATCHTHRESHOLD int,
    @ADDRESSMATCHTHRESHOLD int,
    @OVERALLMATCHTHRESHOLD int,
    @CHECKSTATE bit,
    @CHECKPOSTCODE bit,
    @LEFTPOSTCODECOUNT int,
    @CHECKCOUNTRY bit,
    @CHECKBIRTHDATE bit,
    @CHECKGENDER bit,
    @CHECKMIDDLENAME bit,
    @CHECKMAIDENNAME bit,
    @INCLUDEINACTIVE bit,
    @INCLUDEDECEASED bit,
    @INCLUDEGROUPS bit,
    @INCLUDEORGANIZATIONS bit
)

as
  set nocount on;

    declare @POSTCODEPREFIXLENGTH tinyint;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTDUPLICATESEARCHPROCESS
        @ID = @ID,
        @POSTCODEPREFIXLENGTH = @POSTCODEPREFIXLENGTH output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATESEARCHPROCESS_2
        @ID,
        @CHANGEAGENTID,
        @OPTIONCODE,
        @IDSETREGISTERID,
        @ISEXHAUSTIVE,
        @CHECKPHONE,
        @CHECKEMAIL,
        @NAMEMATCHTHRESHOLD,
        @ADDRESSMATCHTHRESHOLD,
        @OVERALLMATCHTHRESHOLD,
        @CHECKSTATE,
        @CHECKPOSTCODE,
        @LEFTPOSTCODECOUNT,
        @CHECKCOUNTRY,
        @CHECKBIRTHDATE,
        @CHECKGENDER,
        @CHECKMIDDLENAME,
        @CHECKMAIDENNAME,
        @INCLUDEINACTIVE,
        @INCLUDEDECEASED,
        @INCLUDEGROUPS,
        @INCLUDEORGANIZATIONS,
        @POSTCODEPREFIXLENGTH

  return 0;