USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTDUPLICATESEARCHPROCESS

The load procedure used by the view dataform template "Constituent Duplicate Search Process View 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.
@NAME	nvarchar(100)	INOUT	Name
@OPTIONCODE	tinyint	INOUT	Option
@ISINCREMENTAL	bit	INOUT	Only include constituents added or updated since business process was last run
@LASTRUNON	datetime	INOUT	Business process Last Run On
@IDSETREGISTERID	uniqueidentifier	INOUT	Include selection
@ISEXHAUSTIVE	bit	INOUT	Match constituents without token filtering
@CHECKPHONE	bit	INOUT	Phone
@CHECKEMAIL	bit	INOUT	Consider any email match a high confidence match
@REQUIRESECONDARYMATCH	bit	INOUT	Require secondary match
@MAXMATCHPERCONSTITUENT	tinyint	INOUT	Maximum matches per constituent
@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	tinyint	INOUT	Number matched ZIP digits required for inexact match
@CHECKCOUNTRY	bit	INOUT	Country
@CHECKBIRTHDATE	bit	INOUT	Birth Date
@CHECKGENDER	bit	INOUT	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
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@PARAMETERSID	uniqueidentifier	INOUT	PARAMETERSID
@POSTCODEPREFIXLENGTH	tinyint	INOUT

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTDUPLICATESEARCHPROCESS
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100) = null output,
                @OPTIONCODE tinyint = null output,
                @ISINCREMENTAL bit = null output,
                @LASTRUNON datetime = null output,
                @IDSETREGISTERID uniqueidentifier = null output,
                @ISEXHAUSTIVE bit = null output,
                @CHECKPHONE bit = null output,
                @CHECKEMAIL bit = null output,
                @REQUIRESECONDARYMATCH bit = null output,
                @MAXMATCHPERCONSTITUENT tinyint = null output,
                @NAMEMATCHTHRESHOLD int = null output,
                @ADDRESSMATCHTHRESHOLD int = null output,
                @OVERALLMATCHTHRESHOLD int = null output,
                @CHECKSTATE bit = null output,
                @CHECKPOSTCODE bit = null output,
                @LEFTPOSTCODECOUNT tinyint = 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,
                @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                @PARAMETERSID uniqueidentifier = null output,
                @POSTCODEPREFIXLENGTH tinyint = null output
            )
            as
            begin
                set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @NAME = CONSTITUENTDUPLICATESEARCHPROCESS.NAME, 
                    @OPTIONCODE = OPTIONCODE,
                    @ISINCREMENTAL = ISINCREMENTAL,
                    @LASTRUNON = LASTRUNON,
                    @IDSETREGISTERID = IDSETREGISTERID,
                    @ISEXHAUSTIVE = 0, -- 12/5/12 no longer used
                    @CHECKPHONE = CHECKPHONE,
                    @CHECKEMAIL = CHECKEMAIL,
                    @REQUIRESECONDARYMATCH = REQUIRESECONDARYMATCH,
                    @MAXMATCHPERCONSTITUENT = MAXMATCHPERCONSTITUENT,
                    @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,
                    @BUSINESSPROCESSCATALOGID = 'ecca871d-beb3-4649-9546-6d1e9676227c',
                    @PARAMETERSID = @ID,
                    @POSTCODEPREFIXLENGTH = POSTCODEPREFIXLENGTH
                from dbo.CONSTITUENTDUPLICATESEARCHPROCESS
                where
                    CONSTITUENTDUPLICATESEARCHPROCESS.ID = @ID;

                return 0;
            end