USP_PARTIALINFORMATIONSEARCHRESULT_BODETAIL_RELATIONSHIPS_INSERT

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

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID	uniqueidentifier	IN
@MATCHFLAG	bit	IN
@LASTNAME	nvarchar(100)	IN
@FIRSTNAME	nvarchar(50)	IN
@MIDDLENAME	nvarchar(50)	IN
@SUFFIX	nvarchar(50)	IN
@TITLE	nvarchar(30)	IN
@FULLNAME	nvarchar(300)	IN
@YEAROFBIRTH	UDT_YEAR	IN
@GENDERCODE	tinyint	IN
@ADDRESS1	nvarchar(100)	IN
@CITY1	nvarchar(50)	IN
@STATE1	nvarchar(2)	IN
@ZIP1	nvarchar(10)	IN
@ADDRESS2	nvarchar(100)	IN
@CITY2	nvarchar(50)	IN
@STATE2	nvarchar(2)	IN
@ZIP2	nvarchar(10)	IN
@LASTDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_BODETAIL_RELATIONSHIPS_INSERT(
                @ID uniqueidentifier output,
                @CHANGEAGENTID uniqueidentifier,
                @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID uniqueidentifier = null,
                @MATCHFLAG bit = 0,
                @LASTNAME nvarchar(100) = '',
                @FIRSTNAME nvarchar(50) = '',
                @MIDDLENAME nvarchar(50) = '',
                @SUFFIX nvarchar(50) = '',
                @TITLE nvarchar(30) = '',
                @FULLNAME nvarchar(300) = '',
                @YEAROFBIRTH dbo.UDT_YEAR = 0,
                @GENDERCODE tinyint = 0,
                @ADDRESS1 nvarchar(100) = '',
                @CITY1 nvarchar(50) = '',
                @STATE1 nvarchar(2) = '',
                @ZIP1 nvarchar(10) = '',
                @ADDRESS2 nvarchar(100) = '',
                @CITY2 nvarchar(50) = '',
                @STATE2 nvarchar(2) = '',
                @ZIP2 nvarchar(10) = '',
                @LASTDATE datetime = null
            )
            as
            begin
                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_BODETAIL_RELATIONSHIPS] (
                            ID,
                            PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID,
                            MATCHFLAG,
                            LASTNAME,
                            FIRSTNAME,
                            MIDDLENAME,
                            SUFFIX,
                            TITLE,
                            FULLNAME,
                            YEAROFBIRTH,
                            GENDERCODE,
                            ADDRESS1,
                            CITY1,
                            STATE1,
                            ZIP1,
                            ADDRESS2,
                            CITY2,
                            STATE2,
                            ZIP2,
                            LASTDATE,
                            CHANGEDBYID,
                            ADDEDBYID,
                            DATEADDED,
                            DATECHANGED                        
                        ) values (
                            @ID,
                            @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID,
                            @MATCHFLAG,
                            @LASTNAME,
                            @FIRSTNAME,
                            @MIDDLENAME,
                            @SUFFIX,
                            @TITLE,
                            @FULLNAME,
                            @YEAROFBIRTH,
                            @GENDERCODE,
                            @ADDRESS1,
                            @CITY1,
                            @STATE1,
                            @ZIP1,
                            @ADDRESS2,
                            @CITY2,
                            @STATE2,
                            @ZIP2,
                            @LASTDATE,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;
            end