USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATESEARCHPROCESS_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@OPTIONCODE	tinyint	IN
@IDSETREGISTERID	uniqueidentifier	IN
@ISEXHAUSTIVE	bit	IN
@CHECKPHONE	bit	IN
@CHECKEMAIL	bit	IN
@NAMEMATCHTHRESHOLD	int	IN
@ADDRESSMATCHTHRESHOLD	int	IN
@OVERALLMATCHTHRESHOLD	int	IN
@CHECKSTATE	bit	IN
@CHECKPOSTCODE	bit	IN
@LEFTPOSTCODECOUNT	int	IN
@CHECKCOUNTRY	bit	IN
@CHECKBIRTHDATE	bit	IN
@CHECKGENDER	bit	IN
@CHECKMIDDLENAME	bit	IN
@CHECKMAIDENNAME	bit	IN
@INCLUDEINACTIVE	bit	IN
@INCLUDEDECEASED	bit	IN
@INCLUDEGROUPS	bit	IN
@INCLUDEORGANIZATIONS	bit	IN
@POSTCODEPREFIXLENGTH	tinyint	IN

Definition

Copy


                create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATESEARCHPROCESS_2
                    (
                        @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,
                        @POSTCODEPREFIXLENGTH tinyint
                    )
                as
                    set nocount on;
                    declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                    begin try
                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        update dbo.CONSTITUENTDUPLICATESEARCHPROCESS set
                            IDSETREGISTERID = @IDSETREGISTERID,
                            OPTIONCODE = @OPTIONCODE,
                            LEFTPOSTCODECOUNT = @LEFTPOSTCODECOUNT,
                            NAMEMATCHTHRESHOLD = @NAMEMATCHTHRESHOLD,
                            ADDRESSMATCHTHRESHOLD = @ADDRESSMATCHTHRESHOLD,
                            OVERALLMATCHTHRESHOLD = @OVERALLMATCHTHRESHOLD,
                            ISEXHAUSTIVE = 0, -- 12/5/12 no longer used
                            CHECKEMAIL = @CHECKEMAIL,
                            CHECKCOUNTRY = @CHECKCOUNTRY,
                            CHECKSTATE = @CHECKSTATE,
                            CHECKPOSTCODE = @CHECKPOSTCODE,
                            CHECKMIDDLENAME = @CHECKMIDDLENAME,
                            CHECKMAIDENNAME = @CHECKMAIDENNAME,
                            CHECKGENDER = @CHECKGENDER,
                            CHECKBIRTHDATE = @CHECKBIRTHDATE,
                            CHECKPHONE = @CHECKPHONE,
                            INCLUDEINACTIVE = @INCLUDEINACTIVE,
                            INCLUDEDECEASED = @INCLUDEDECEASED,
                            INCLUDEGROUPS = @INCLUDEGROUPS,
                            INCLUDEORGANIZATIONS = @INCLUDEORGANIZATIONS,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE,
                            POSTCODEPREFIXLENGTH = @POSTCODEPREFIXLENGTH
                        where
                            ID = @ID;

                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;