USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_INSERT

This procedure is used to insert 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_INSERT (
                @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
                    if @ID is null
                        set @ID = newid();

                    insert into dbo.[PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP] (
                        [ID],
                        [PARTIALINFORMATIONSEARCHCRITERIAID],
                        [JOBID],
                        [CONFIDENCE],
                        [DUNSNUM],
                        [FULLNAME],
                        [FIRSTNAME],
                        [MIDDLENAME],
                        [LASTNAME],
                        [SUFFIX],
                        [COMPANY],
                        [ADDRESS],
                        [CITY],
                        [STATE],
                        [ZIP],
                        [PHONE],
                        [MATCHTYPE],
                        [ADDEDBYID],
                        [CHANGEDBYID],
                        [DATEADDED],
                        [DATECHANGED]
                    )
                    values (
                        @ID,
                        @PARTIALINFORMATIONSEARCHCRITERIAID,
                        @JOBID,
                        dbo.UFN_PARTIALINFORMATIONSEARCH_GETMATCHCONFIDENCEFROMPERCENTAGE(@MATCHPERCENTAGE),
                        @DUNSNUM,
                        @FULLNAME,
                        @FIRSTNAME,
                        @MIDDLENAME,
                        @LASTNAME,
                        @SUFFIX,
                        @COMPANY,
                        @ADDRESS,
                        @CITY,
                        @STATE,
                        @ZIP,
                        @PHONE,
                        @MATCHTYPE,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE
                    );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;