USP_WPWHOSWHO_ADD

Adds Prospect Wealth Biographical information for a prospect.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@WEALTHID	uniqueidentifier	IN
@SOURCE	nvarchar(100)	IN
@WWID	int	IN
@REVISION	int	IN
@ORIGINALID	int	IN
@NEWROW	bit	IN
@LASTCHANGEDON	datetime	IN
@ADDEDON	datetime	IN
@FULLHASH	nvarchar(32)	IN
@PARTIALHASH	nvarchar(32)	IN
@MC	nvarchar(2)	IN
@FULLNAME	nvarchar(100)	IN
@LINE1	nvarchar(4000)	IN
@CITY	nvarchar(4000)	IN
@STATE	nvarchar(4000)	IN
@ZIP	nvarchar(50)	IN
@A2LINE1	nvarchar(4000)	IN
@A2CITY	nvarchar(4000)	IN
@A2STATE	nvarchar(4000)	IN
@A2ZIP	nvarchar(50)	IN
@SX	nvarchar(6)	IN
@DOB	datetime	IN
@BP	nvarchar(120)	IN
@DT	UDT_FUZZYDATE	IN
@OCC	nvarchar(4000)	IN
@ED	nvarchar(max)	IN
@PR	nvarchar(max)	IN
@PO	nvarchar(max)	IN
@CE	nvarchar(max)	IN
@CR	nvarchar(max)	IN
@HA	nvarchar(max)	IN
@MEMINFO	nvarchar(max)	IN
@RI	nvarchar(max)	IN
@AF	nvarchar(max)	IN
@CP	nvarchar(max)	IN
@TH	nvarchar(max)	IN
@LW	nvarchar(max)	IN
@TR	nvarchar(max)	IN
Definition

Copy


            create procedure dbo.USP_WPWHOSWHO_ADD (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @WEALTHID uniqueidentifier,
                @SOURCE nvarchar(100),
                @WWID int = 0,
                @REVISION int = 0,
                @ORIGINALID int = 0,
                @NEWROW bit = 0,
                @LASTCHANGEDON datetime = null,
                @ADDEDON datetime = null,
                @FULLHASH nvarchar(32) = '',
                @PARTIALHASH nvarchar(32) = '',
                @MC nvarchar(2) = '',
                @FULLNAME nvarchar(100) = '',
                @LINE1 nvarchar(4000) = '',
                @CITY nvarchar(4000) = '',
                @STATE nvarchar(4000) = '',
                @ZIP nvarchar(50) = '',
                @A2LINE1 nvarchar(4000) = '',
                @A2CITY nvarchar(4000) = '',
                @A2STATE nvarchar(4000) = '',
                @A2ZIP nvarchar(50) = '',
                @SX nvarchar(6) = '',
                @DOB datetime = null,
                @BP nvarchar(120) = '',
                @DT dbo.UDT_FUZZYDATE = '00000000',
                @OCC nvarchar(4000) = '',
                @ED nvarchar(max) = '',
                @PR nvarchar(max) = '',
                @PO nvarchar(max) = '',
                @CE nvarchar(max) = '',
                @CR nvarchar(max) = '',
                @HA nvarchar(max) = '',
                @MEMINFO nvarchar(max) = '',
                @RI nvarchar(max) = '',
                @AF nvarchar(max) = '',
                @CP nvarchar(max) = '',
                @TH nvarchar(max) = '',
                @LW nvarchar(max) = '',
                @TR nvarchar(max) = ''
            ) as begin

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

                begin try

                    if exists(select 1 from dbo.WPWHOSWHO where WEALTHID=@WEALTHID and FULLHASH=@FULLHASH) 

                        set @ID = null;

                    else begin

                        if @ID is null
                            set @ID = newid();

                        insert into dbo.WPWHOSWHO (
                            ID,ADDEDBYID,CHANGEDBYID,
                            WEALTHID,
                            SOURCE,
                            WWID,
                            REVISION,
                            ORIGINALID,
                            NEWROW,
                            LASTCHANGEDON,
                            ADDEDON,
                            FULLHASH,
                            PARTIALHASH,
                            MC,
                            FULLNAME,
                            LINE1,
                            CITY,
                            STATE,
                            ZIP,
                            A2LINE1,
                            A2CITY,
                            A2STATE,
                            A2ZIP,
                            SX,
                            DOB,
                            BP,
                            DT,
                            OCC,
                            ED,
                            PR,
                            PO,
                            CE,
                            CR,
                            HA,
                            MEMINFO,
                            RI,
                            AF,
                            CP,
                            TH,
                            LW,
                            TR
                        ) values (
                            @ID,@CHANGEAGENTID,@CHANGEAGENTID,
                            @WEALTHID,
                            @SOURCE,
                            @WWID,
                            @REVISION,
                            @ORIGINALID,
                            @NEWROW,
                            @LASTCHANGEDON,
                            @ADDEDON,
                            @FULLHASH,
                            @PARTIALHASH,
                            @MC,
                            @FULLNAME,
                            @LINE1,
                            @CITY,
                            @STATE,
                            @ZIP,
                            @A2LINE1,
                            @A2CITY,
                            @A2STATE,
                            @A2ZIP,
                            @SX,
                            @DOB,
                            @BP,
                            @DT,
                            @OCC,
                            @ED,
                            @PR,
                            @PO,
                            @CE,
                            @CR,
                            @HA,
                            @MEMINFO,
                            @RI,
                            @AF,
                            @CP,
                            @TH,
                            @LW,
                            @TR
                        );
                    end

                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                end catch

                return 0;
            end;