UFN_CONSTITUENT_ORGANIZATION_GETTHRESHOLDFUZZYDUPLICATES

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@NAME	nvarchar(100)	IN
@KEYNAME	nvarchar(100)	IN
@POSTCODE	nvarchar(12)	IN
@ADDRESSBLOCK	nvarchar(150)	IN
@OVERALLMATCHTHRESHOLD	numeric(5, 2)	IN

Definition

Copy



CREATE function dbo.UFN_CONSTITUENT_ORGANIZATION_GETTHRESHOLDFUZZYDUPLICATES
(
    @NAME nvarchar(100),
    @KEYNAME nvarchar(100),
    @POSTCODE nvarchar(12),
    @ADDRESSBLOCK nvarchar(150) = '',
    @OVERALLMATCHTHRESHOLD numeric(5, 2) = null
) 
returns @DUPLICATECANDIDATES table
(
    CONSTITUENTID uniqueidentifier,
    ADDRESSID uniqueidentifier,
    MATCHPERCENTAGE numeric(5, 2)
) as
begin

    insert into @DUPLICATECANDIDATES (
        CONSTITUENTID,
        ADDRESSID,
        MATCHPERCENTAGE
    )
    select 
        CONSTITUENTID,
    ADDRESSID,
    MATCHPERCENTAGE
  from dbo.UFN_FINDCONSTITUENTMATCHES_COMPOSITETHRESHOLD(
    null,
    @KEYNAME,
    @ADDRESSBLOCK,
    @POSTCODE,
    null,
    1,
    0,
    @OVERALLMATCHTHRESHOLD)

    return;
end