USP_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_UPDATE

This procedure is used to update a Prospect Quick Search real estate result.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@PARTIALINFORMATIONSEARCHCRITERIAID	uniqueidentifier	IN
@JOBID	nvarchar(50)	IN
@MATCHPERCENTAGE	decimal(18, 0)	IN
@FIPSCODE	nvarchar(5)	IN
@ASSESSORSPARCELNUMBER	nvarchar(100)	IN
@OWNERNAME	nvarchar(300)	IN
@PROPERTYADDRESSBLOCK	nvarchar(100)	IN
@PROPERTYUNITNUMBER	nvarchar(25)	IN
@PROPERTYCITY	nvarchar(50)	IN
@PROPERTYSTATE	nvarchar(100)	IN
@PROPERTYPOSTCODE	nvarchar(10)	IN
@MAILINGADDRESSBLOCK	nvarchar(100)	IN
@MAILINGUNITNUMBER	nvarchar(25)	IN
@MAILINGCITY	nvarchar(50)	IN
@MAILINGSTATE	nvarchar(100)	IN
@MAILINGPOSTCODE	nvarchar(10)	IN
@MATCHTYPE	nvarchar(300)	IN

Definition

Copy



            CREATE procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_UPDATE (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @PARTIALINFORMATIONSEARCHCRITERIAID uniqueidentifier,
                @JOBID nvarchar(50) = '',
                @MATCHPERCENTAGE decimal = 0,
                @FIPSCODE nvarchar(5) = '',
                @ASSESSORSPARCELNUMBER nvarchar(100) = '',
                @OWNERNAME nvarchar(300) = '',
                @PROPERTYADDRESSBLOCK nvarchar(100) = '',
                @PROPERTYUNITNUMBER nvarchar(25) = '',
                @PROPERTYCITY nvarchar(50) = '',
                @PROPERTYSTATE nvarchar(100) = '',
                @PROPERTYPOSTCODE nvarchar(10) = '',
                @MAILINGADDRESSBLOCK nvarchar(100) = '',
                @MAILINGUNITNUMBER nvarchar(25) = '',
                @MAILINGCITY nvarchar(50) = '',
                @MAILINGSTATE nvarchar(100) = '',
                @MAILINGPOSTCODE nvarchar(10) = '',
                @MATCHTYPE  nvarchar(300) = ''
            ) as
                set nocount on;

                declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                begin try
                    update
                        dbo.[PARTIALINFORMATIONSEARCHRESULT_REALESTATE]
                    set
                        [PARTIALINFORMATIONSEARCHCRITERIAID] = @PARTIALINFORMATIONSEARCHCRITERIAID,
                        [JOBID] = @JOBID,
                        [CONFIDENCE] = dbo.UFN_PARTIALINFORMATIONSEARCH_GETMATCHCONFIDENCEFROMPERCENTAGE(@MATCHPERCENTAGE),
                        [FIPSCODE] = @FIPSCODE,
                        [ASSESSORSPARCELNUMBER] = @ASSESSORSPARCELNUMBER,
                        [OWNERNAME] = @OWNERNAME,
                        [PROPERTYADDRESSBLOCK] = @PROPERTYADDRESSBLOCK,
                        [PROPERTYUNITNUMBER] = @PROPERTYUNITNUMBER,
                        [PROPERTYCITY] = @PROPERTYCITY,
                        [PROPERTYSTATE] = @PROPERTYSTATE,
                        [PROPERTYPOSTCODE] = @PROPERTYPOSTCODE,
                        [MAILINGADDRESSBLOCK] = @MAILINGADDRESSBLOCK,
                        [MAILINGUNITNUMBER] = @MAILINGUNITNUMBER,
                        [MAILINGCITY] = @MAILINGCITY,
                        [MAILINGSTATE] = @MAILINGSTATE,
                        [MAILINGPOSTCODE] = @MAILINGPOSTCODE,
                        [MATCHTYPE] = @MATCHTYPE,
                        [CHANGEDBYID] = @CHANGEAGENTID,
                        [DATECHANGED] = @CURRENTDATE
                    where
                        [ID] = @ID;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;