UFN_FINDADDRESSMATCH_CONSTITUENTUPDATEBATCH

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@ADDRESSBLOCK	nvarchar(150)	IN
@POSTCODE	nvarchar(12)	IN
@COUNTRYID	uniqueidentifier	IN
@CITY	nvarchar(50)	IN
@STATEID	uniqueidentifier	IN
@ADDRESSTYPECODEID	uniqueidentifier	IN
@ADDRESSMATCHTHRESHOLD	tinyint	IN
@BATCHCONSTITUENTUPDATEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_FINDADDRESSMATCH_CONSTITUENTUPDATEBATCH(
  @CONSTITUENTID uniqueidentifier, --constituent ID we are trying to find an address matching the rest of the parameters.

  @ADDRESSBLOCK nvarchar(150),
  @POSTCODE nvarchar(12),
  @COUNTRYID uniqueidentifier,
  @CITY nvarchar(50),
  @STATEID uniqueidentifier,
  @ADDRESSTYPECODEID uniqueidentifier,
  @ADDRESSMATCHTHRESHOLD tinyint,
  @BATCHCONSTITUENTUPDATEID uniqueidentifier -- Batch row ID to keep track of addresses that are already in the batch.

)
returns @MATCH table (
  ADDRESSID uniqueidentifier,
  NOCONFLICTS bit,
  STREETNUMBERRESULT tinyint,
  STREETNAMERESULT tinyint,
  POSTCODERESULT tinyint
)
as
begin

   insert into @MATCH 
   select ADDRESSID,NOCONFLICTS,STREETNUMBERRESULT,STREETNAMERESULT,POSTCODERESULT
   from dbo.UFN_FINDADDRESSMATCH_CONSTITUENTUPDATEBATCH2(@CONSTITUENTID, @ADDRESSBLOCK, @POSTCODE, @COUNTRYID, @CITY, @STATEID, @ADDRESSTYPECODEID, @ADDRESSMATCHTHRESHOLD, @BATCHCONSTITUENTUPDATEID, null)                         
  return;


end