USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTDUPLICATESEARCHPROCESS_DETAIL

The load procedure used by the view dataform template "Constituent Duplicate Search Process Detail 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.
@IDSETREGISTERNAME	nvarchar(100)	INOUT	Selected constituents
@OPTIONCODE	tinyint	INOUT	Option
@ISINCREMENTAL	bit	INOUT	Only include constituents added or updated since business process was last run
@LASTRUNON	datetime	INOUT	Last run on
@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	Number matched ZIP digits required for inexact match
@CHECKCOUNTRY	bit	INOUT	Country
@CHECKBIRTHDATE	bit	INOUT	Filter individuals by birth date
@CHECKGENDER	bit	INOUT	Filter individuals 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

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTDUPLICATESEARCHPROCESS_DETAIL
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @IDSETREGISTERNAME nvarchar(100) = null output,
                @OPTIONCODE tinyint = null output,
                @ISINCREMENTAL bit = null output,
                @LASTRUNON datetime = 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,
                @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                @PARAMETERSID uniqueidentifier = null output
            )
            as
            begin
                set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @IDSETREGISTERNAME = dbo.UFN_IDSET_GETNAME(IDSETREGISTERID),
                    @OPTIONCODE = OPTIONCODE,
                    @ISINCREMENTAL = ISINCREMENTAL,
                    @LASTRUNON = LASTRUNON,
                    @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,
                    @BUSINESSPROCESSCATALOGID = 'ecca871d-beb3-4649-9546-6d1e9676227c',
                    @PARAMETERSID = @ID
                from dbo.CONSTITUENTDUPLICATESEARCHPROCESS
                where
                    CONSTITUENTDUPLICATESEARCHPROCESS.ID = @ID;

                return 0;
            end