UFN_CONSTITUENT_GETTHRESHOLDDUPLICATECANDIDATES

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@KEYNAME	nvarchar(100)	IN
@FIRSTNAME	nvarchar(50)	IN
@POSTCODE	nvarchar(12)	IN
@ADDRESSBLOCK	nvarchar(150)	IN
@OVERALLMATCHTHRESHOLD	decimal(20, 4)	IN

Definition

Copy



create function dbo.UFN_CONSTITUENT_GETTHRESHOLDDUPLICATECANDIDATES
(
    @KEYNAME nvarchar(100),
    @FIRSTNAME nvarchar(50) = '',
    @POSTCODE nvarchar(12),
    @ADDRESSBLOCK nvarchar(150) = '',
    @OVERALLMATCHTHRESHOLD decimal(20, 4) = null
) 
returns @DUPLICATECANDIDATES table
(
    CONSTITUENTID uniqueidentifier,
    ADDRESSID uniqueidentifier,
    MATCHPERCENTAGE numeric(5, 2)
) as
begin

    if @KEYNAME is null or len(@KEYNAME) = 0 or @POSTCODE is null or len(@POSTCODE) = 0
        return

    -- todo generify

    insert into @DUPLICATECANDIDATES (
        CONSTITUENTID,
        ADDRESSID,
        MATCHPERCENTAGE
    )
    select 
        CONSTITUENTID,
        ADDRESSID,
        MATCHPERCENTAGE
    from
        dbo.UFN_CONSTITUENT_GETTHRESHOLDFUZZYDUPLICATES (
            @KEYNAME,
            @FIRSTNAME,
            @POSTCODE,
            @ADDRESSBLOCK,
            @OVERALLMATCHTHRESHOLD
        )

    return;
end