USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_UPDATE

This procedure is used to update a Prospect Quick Search business ownership result.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@PARTIALINFORMATIONSEARCHCRITERIAID	uniqueidentifier	IN
@JOBID	nvarchar(50)	IN
@MATCHPERCENTAGE	decimal(18, 0)	IN
@DUNSNUM	int	IN
@FULLNAME	nvarchar(50)	IN
@FIRSTNAME	nvarchar(50)	IN
@MIDDLENAME	nvarchar(50)	IN
@LASTNAME	nvarchar(50)	IN
@SUFFIX	nvarchar(50)	IN
@COMPANY	nvarchar(30)	IN
@ADDRESS	nvarchar(25)	IN
@CITY	nvarchar(20)	IN
@STATE	nvarchar(2)	IN
@ZIP	nvarchar(10)	IN
@PHONE	nvarchar(20)	IN
@MATCHTYPE	nvarchar(300)	IN

Definition

Copy



            CREATE procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_UPDATE (
                @ID uniqueidentifier output,
                @CHANGEAGENTID uniqueidentifier,
                @PARTIALINFORMATIONSEARCHCRITERIAID uniqueidentifier,
                @JOBID nvarchar(50) = '',
                @MATCHPERCENTAGE decimal = 0,
                @DUNSNUM int = 0,
                @FULLNAME nvarchar(50) = '',
                @FIRSTNAME nvarchar(50) = '',
                @MIDDLENAME nvarchar(50) = '',
                @LASTNAME nvarchar(50) = '',
                @SUFFIX nvarchar(50) = '',
                @COMPANY nvarchar(30) = '',
                @ADDRESS nvarchar(25) = '',
                @CITY nvarchar(20) = '',
                @STATE nvarchar(2) = '',
                @ZIP nvarchar(10) = '',
                @PHONE nvarchar(20) = '',
                @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_BUSINESSOWNERSHIP]
                    set
                        [PARTIALINFORMATIONSEARCHCRITERIAID] = @PARTIALINFORMATIONSEARCHCRITERIAID,
                        [JOBID] = @JOBID,
                        [CONFIDENCE] = dbo.UFN_PARTIALINFORMATIONSEARCH_GETMATCHCONFIDENCEFROMPERCENTAGE(@MATCHPERCENTAGE),
                        [DUNSNUM] = @DUNSNUM,
                        [FULLNAME] = @FULLNAME,
                        [FIRSTNAME] = @FIRSTNAME,
                        [MIDDLENAME] = @MIDDLENAME,
                        [LASTNAME] = @LASTNAME,
                        [SUFFIX] = @SUFFIX,
                        [COMPANY] = @COMPANY,
                        [ADDRESS] = @ADDRESS,
                        [CITY] = @CITY,
                        [STATE] = @STATE,
                        [ZIP] = @ZIP,
                        [PHONE] = @PHONE,
                        [MATCHTYPE] = @MATCHTYPE,
                        [CHANGEDBYID] = @CHANGEAGENTID,
                        [DATECHANGED] = @CURRENTDATE
                    where
                        [ID] = @ID;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;