USP_DATALIST_CONSTITUENT_AUTOMATCH_BYSEARCHSETTINGSCRITERIA

This datalist returns constituents that match the provided criteria data.

Parameters

Parameter	Parameter Type	Mode	Description
@SEARCHSETTINGSID	uniqueidentifier	IN	Duplicate constituent auto match settings ID
@TRANSACTIONTYPE	nvarchar(512)	IN	Transaction Type
@MAXROWS	int	IN	Input parameter indicating the maximum number of rows to return.
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Email Address
@KEYNAME	nvarchar(100)	IN	Last Name
@FIRSTNAME	nvarchar(50)	IN	First Name
@MAIDENNAME	nvarchar(100)	IN	Maiden Name
@MIDDLENAME	nvarchar(50)	IN	Middle Name
@ADDRESSBLOCK	nvarchar(150)	IN	Address Block
@CITY	nvarchar(100)	IN	Address City
@COUNTRYID	uniqueidentifier	IN	Country
@STATEID	uniqueidentifier	IN	State
@POSTCODE	nvarchar(12)	IN	Address Zip Code
@PHONENUMBER	nvarchar(100)	IN	Phone Number
@BIRTHDATE	date	IN	Birth Date
@GENDERCODE	tinyint	IN	Gender
@LOOKUPID	nvarchar(20)	IN	LookupID
@TITLECODEID	uniqueidentifier	IN	Title

Definition

Copy



                CREATE PROCEDURE [dbo].[USP_DATALIST_CONSTITUENT_AUTOMATCH_BYSEARCHSETTINGSCRITERIA]
                (
                    @SEARCHSETTINGSID uniqueidentifier = null,
                    @TRANSACTIONTYPE nvarchar(512) = 'FAF Registration',
                    @MAXROWS integer = 2,
                    @EMAILADDRESS dbo.UDT_EMAILADDRESS = '',
                    @KEYNAME nvarchar(100) = '',
                    @FIRSTNAME nvarchar(50) = '',
                    @MAIDENNAME nvarchar(100) = '',
                    @MIDDLENAME nvarchar(50) = '',
                    @ADDRESSBLOCK nvarchar(150) = '',
                    @CITY nvarchar(100) = '',
                    @COUNTRYID uniqueidentifier= null,
                    @STATEID uniqueidentifier= null,
                    @POSTCODE nvarchar(12) = '',
                    @PHONENUMBER nvarchar(100) = '',
                    @BIRTHDATE date = null,
                    @GENDERCODE tinyint = null,
                    @LOOKUPID nvarchar(20) = '',
                    @TITLECODEID uniqueidentifier = null
                )
                as
                begin
                    set nocount on;

                    --Supporting features that identify search settings by transaction type

                    if @SEARCHSETTINGSID is null
                    begin
                        select @SEARCHSETTINGSID = [ID] 
                        from dbo.[CONSTITUENTDUPLICATESEARCHSETTINGS] 
                        where [TRANSACTIONTYPE] = @TRANSACTIONTYPE
                    end

                    select 
                        [CONSTITUENTID],
                        [FIRSTNAME],
                        [KEYNAME],
                        [MATCHPERCENTAGESCORE]
                    from [dbo].[UFN_CONSTITUENT_AUTOMATCH_BYSEARCHSETTINGSCRITERIA](
                        @SEARCHSETTINGSID,
                        @MAXROWS,
                        @EMAILADDRESS,
                        @KEYNAME,
                        @FIRSTNAME,
                        @MAIDENNAME,
                        @MIDDLENAME,
                        @ADDRESSBLOCK,
                        @CITY,
                        @COUNTRYID,
                        @STATEID,
                        @POSTCODE,
                        @PHONENUMBER,
                        @BIRTHDATE,
                        @GENDERCODE,
                        @LOOKUPID,
                        @TITLECODEID
                    )

                end