UFN_FINDCONSTITUENTMATCHES_COMPOSITETHRESHOLD_2

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@TITLECODEID	uniqueidentifier	IN
@FIRSTNAME	nvarchar(50)	IN
@MIDDLENAME	nvarchar(50)	IN
@KEYNAME	nvarchar(100)	IN
@SUFFIXCODEID	uniqueidentifier	IN
@ADDRESSBLOCK	nvarchar(150)	IN
@POSTCODE	nvarchar(12)	IN
@COUNTRYID	uniqueidentifier	IN
@ISORGANIZATION	bit	IN
@ISGROUP	bit	IN
@LOOKUPID	nvarchar(100)	IN
@ALTERNATELOOKUPIDS	xml	IN
@EMAILADDRESS	nvarchar(100)	IN
@PHONENUMBER	nvarchar(100)	IN
@OVERALLMATCHTHRESHOLD	tinyint	IN
@AUTOMATCHTHRESHOLD	tinyint	IN

Definition

Copy



CREATE function dbo.UFN_FINDCONSTITUENTMATCHES_COMPOSITETHRESHOLD_2 (
  @TITLECODEID uniqueidentifier,
  @FIRSTNAME nvarchar(50),
  @MIDDLENAME nvarchar(50),
  @KEYNAME nvarchar(100),
  @SUFFIXCODEID uniqueidentifier,
  @ADDRESSBLOCK nvarchar(150),
  @POSTCODE nvarchar(12),
  @COUNTRYID uniqueidentifier,
  @ISORGANIZATION bit,
  @ISGROUP bit,
  @LOOKUPID nvarchar(100),
  @ALTERNATELOOKUPIDS xml,
  @EMAILADDRESS nvarchar(100),
  @PHONENUMBER nvarchar(100),
  @OVERALLMATCHTHRESHOLD tinyint,
  @AUTOMATCHTHRESHOLD tinyint
)
returns @MATCHES table (
  CONSTITUENTID uniqueidentifier,
  ADDRESSID uniqueidentifier,
  EMAILADDRESSID uniqueidentifier,
  PHONEID uniqueidentifier,
  MATCHPERCENTAGE tinyint,
  STREETNUMBERRESULT tinyint,
  STREETNAMERESULT tinyint,
  POSTCODERESULT tinyint
)
as
begin
  insert into @MATCHES
  select 
  CONSTITUENTID,
  ADDRESSID,
  EMAILADDRESSID,
  PHONEID,
  MATCHPERCENTAGE,
  STREETNUMBERRESULT,
  STREETNAMERESULT,
  POSTCODERESULT
    from dbo.UFN_FINDCONSTITUENTMATCHES_COMPOSITETHRESHOLD_3(
  @TITLECODEID,
  @FIRSTNAME,
  @MIDDLENAME,
  @KEYNAME,
  @SUFFIXCODEID,
  @ADDRESSBLOCK,
  @POSTCODE,
  @COUNTRYID,
  @ISORGANIZATION,
  @ISGROUP,
  @LOOKUPID,
  @ALTERNATELOOKUPIDS,
  @EMAILADDRESS,
  @PHONENUMBER,
  @OVERALLMATCHTHRESHOLD,
  @AUTOMATCHTHRESHOLD,
  null,
  null);

return
end;