USP_DUPLICATESEARCH_PARTIALINFORMATIONSEARCHREALESTATE

This provides the ability to search for duplicates when adding a real estate record to a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@PARTIALINFORMATIONSEARCHRESULTID	uniqueidentifier	IN	PIS result ID
@CONSTITUENTID	uniqueidentifier	IN	Constituent ID
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.
@NAME	nvarchar(100)	IN	Owner name
@FORMATTEDADDRESS	nvarchar(255)	IN	Property address

Definition

Copy



CREATE procedure dbo.USP_DUPLICATESEARCH_PARTIALINFORMATIONSEARCHREALESTATE
(
    @PARTIALINFORMATIONSEARCHRESULTID uniqueidentifier = null,
    @CONSTITUENTID uniqueidentifier = null,
    @MAXROWS smallint = 500,
    @NAME nvarchar(100) = null,
    @FORMATTEDADDRESS nvarchar(255) = null
)
as

    declare @ASSESSORSPARCELNUMBER nvarchar(100)
    declare @FIPSCODE integer

    select @ASSESSORSPARCELNUMBER = ASSESSORSPARCELNUMBER, @FIPSCODE = FIPSCODE from dbo.PARTIALINFORMATIONSEARCHRESULT_REALESTATE where ID = @PARTIALINFORMATIONSEARCHRESULTID

    select top(@MAXROWS)
        R.ID as REALESTATERECORDID,
        R.ASSESSORSPARCELNUMBER,
        R.OWNER,
        dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(R.PROPADDRESS, '', R.PROPCITY, R.PROPSTATE, R.PROPZIP) as PROPERTYADDRESS
    from 
        dbo.WPREALESTATE R
    where
        @CONSTITUENTID = R.WEALTHID and R.ASSESSORSPARCELNUMBER = @ASSESSORSPARCELNUMBER and R.FIPSCODE = @FIPSCODE