USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTDUPLICATESEARCHPROCESS

The load 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 used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@RECORDTYPEID	uniqueidentifier	INOUT
@OPTIONCODE	tinyint	INOUT	Option
@ISINCREMENTAL	bit	INOUT	Only match constituents added since the process was last run
@IDSETREGISTERID	uniqueidentifier	INOUT	Selected constituents
@ISEXHAUSTIVE	bit	INOUT	Match constituents without token filtering
@CHECKPHONE	bit	INOUT	Match constituents based on phone number
@CHECKEMAIL	bit	INOUT	Match constituents based on email address
@NAMEMATCHTHRESHOLD	int	INOUT	Required name confidence level to match
@ADDRESSMATCHTHRESHOLD	int	INOUT	Required address confidence level to match
@OVERALLMATCHTHRESHOLD	int	INOUT	Required overall confidence level to match
@CHECKSTATE	bit	INOUT	State
@CHECKPOSTCODE	bit	INOUT	Zip;
@LEFTPOSTCODECOUNT	int	INOUT	Digits required for inexact match
@CHECKCOUNTRY	bit	INOUT	Country
@CHECKBIRTHDATE	bit	INOUT	Filter individuals by birth date
@CHECKGENDER	bit	INOUT	Filter individuals by gender
@CHECKMIDDLENAME	bit	INOUT	Include middle names in comparison
@CHECKMAIDENNAME	bit	INOUT	Include maiden names in comparison
@INCLUDEINACTIVE	bit	INOUT	Include Inactive
@INCLUDEDECEASED	bit	INOUT	Include Deceased
@INCLUDEGROUPS	bit	INOUT	Include Groups
@INCLUDEORGANIZATIONS	bit	INOUT	Include Organizations
@POSTCODEPREFIXLENGTH	tinyint	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTDUPLICATESEARCHPROCESS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @TSLONG bigint = 0 output,
                    @RECORDTYPEID uniqueidentifier = null output,
                    @OPTIONCODE tinyint = null output,
                    @ISINCREMENTAL bit = null output,
                    @IDSETREGISTERID uniqueidentifier = null output,
                    @ISEXHAUSTIVE bit = null output,
                    @CHECKPHONE bit = null output,
                    @CHECKEMAIL bit = null output,
                    @NAMEMATCHTHRESHOLD int = null output,
                    @ADDRESSMATCHTHRESHOLD int = null output,
                    @OVERALLMATCHTHRESHOLD int = null output,
                    @CHECKSTATE bit = null output,
                    @CHECKPOSTCODE bit = null output,
                    @LEFTPOSTCODECOUNT int = null output,
                    @CHECKCOUNTRY bit = null output,
                    @CHECKBIRTHDATE bit = null output,
                    @CHECKGENDER bit = null output,
                    @CHECKMIDDLENAME bit = null output,
                    @CHECKMAIDENNAME bit = null output,
                    @INCLUDEINACTIVE bit = null output,
                    @INCLUDEDECEASED bit = null output,
                    @INCLUDEGROUPS bit = null output,
                    @INCLUDEORGANIZATIONS bit = null output,
                    @POSTCODEPREFIXLENGTH tinyint = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;
                    set @TSLONG = 0;

                    select
                        @DATALOADED = 1,
                        @TSLONG = TSLONG,
                        @OPTIONCODE = OPTIONCODE,
                        @ISINCREMENTAL = ISINCREMENTAL,
                        @IDSETREGISTERID = IDSETREGISTERID,
                        @ISEXHAUSTIVE = 0, -- 12/5/12 no longer used
                        @CHECKPHONE = CHECKPHONE,
                        @CHECKEMAIL = CHECKEMAIL,
                        @NAMEMATCHTHRESHOLD = NAMEMATCHTHRESHOLD,
                        @ADDRESSMATCHTHRESHOLD = ADDRESSMATCHTHRESHOLD,
                        @OVERALLMATCHTHRESHOLD = OVERALLMATCHTHRESHOLD,
                        @CHECKSTATE = CHECKSTATE,
                        @CHECKPOSTCODE = CHECKPOSTCODE,
                        @LEFTPOSTCODECOUNT = LEFTPOSTCODECOUNT,
                        @CHECKCOUNTRY = CHECKCOUNTRY,
                        @CHECKBIRTHDATE = CHECKBIRTHDATE,
                        @CHECKGENDER = CHECKGENDER,
                        @CHECKMIDDLENAME = CHECKMIDDLENAME,
                        @CHECKMAIDENNAME = CHECKMAIDENNAME,
                        @INCLUDEINACTIVE = INCLUDEINACTIVE,
                        @INCLUDEDECEASED = INCLUDEDECEASED,
                        @INCLUDEGROUPS = INCLUDEGROUPS,
                        @INCLUDEORGANIZATIONS = INCLUDEORGANIZATIONS,
                        @POSTCODEPREFIXLENGTH = POSTCODEPREFIXLENGTH
                    from dbo.CONSTITUENTDUPLICATESEARCHPROCESS
                    where
                        ID = @ID;

                    select 
                        @RECORDTYPEID = ID
                    from dbo.RECORDTYPE 
                    where 
                        upper(NAME) = 'CONSTITUENT';

                    return 0;