USP_DATALIST_CONSTITUENTDUPLICATESEARCHSETTINGS

This data list returns a list of criteria for constituent auto match.

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONTYPE	nvarchar(256)	IN	Transaction Type
@LEFTPOSTCODECOUNT	tinyint	IN	Number matched ZIP digits required for inexact match
@OVERALLMATCHTHRESHOLD	int	IN	Confidence Level

Definition

Copy



CREATE PROCEDURE DBO.USP_DATALIST_CONSTITUENTDUPLICATESEARCHSETTINGS
(
   @TRANSACTIONTYPE nvarchar(256) =''
  ,@LEFTPOSTCODECOUNT tinyint = null
  ,@OVERALLMATCHTHRESHOLD integer = null
)
AS
    SET NOCOUNT ON;

    declare @ADVOCACYINSTALLED bit = 0;

    if exists(select * from INSTALLEDPRODUCTLIST where ID = '4560756A-E63C-4804-82F0-9D7D0AB36997') set @ADVOCACYINSTALLED = 1;

---added producttypecode so faf will not pick up new bbis automatch config

    SELECT ID,
       TRANSACTIONTYPE,
           LEFTPOSTCODECOUNT,
           CASE floor(OVERALLMATCHTHRESHOLD) 
               WHEN 70 THEN 'Low'
               WHEN 80 THEN 'Medium'
               WHEN 90 THEN 'High'
               WHEN 100 THEN 'Exact'
               END AS CONFIDENCELEVEL       
    FROM  DBO.CONSTITUENTDUPLICATESEARCHSETTINGS
  WHERE TRANSACTIONTYPE LIKE CASE WHEN LEN(@TRANSACTIONTYPE) > 0  THEN (@TRANSACTIONTYPE+'%') ELSE TRANSACTIONTYPE END
  AND   LEFTPOSTCODECOUNT = COALESCE(@LEFTPOSTCODECOUNT,LEFTPOSTCODECOUNT)
  AND   OVERALLMATCHTHRESHOLD = COALESCE(@OVERALLMATCHTHRESHOLD,OVERALLMATCHTHRESHOLD)
  AND   TRANSACTIONTYPE <> 'Default Criteria' 
  AND   CONSTITUENTDUPLICATESEARCHSETTINGS.ID <> '7BDE63AA-73B8-4A31-BE9F-82D92B67E2F4'
  AND  ( CONSTITUENTDUPLICATESEARCHSETTINGS.TRANSACTIONTYPE <>  'Advocacy Registration Form' OR @ADVOCACYINSTALLED = 1)
  AND (CONSTITUENTDUPLICATESEARCHSETTINGS.PRODUCTTYPECODE is null OR CONSTITUENTDUPLICATESEARCHSETTINGS.PRODUCTTYPECODE = 1);