USP_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_INSERT

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

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@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_INSERT (
                @ID uniqueidentifier output,
                @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
                    if @ID is null
                        set @ID = newid();

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

                return 0;