USP_WPNONPROFITOFFICER_ADD

Adds Prospect Wealth Non-Profit Officer/Director information for a prospect.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@WEALTHID	uniqueidentifier	IN
@SOURCE	nvarchar(100)	IN
@GSID	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(150)	IN
@TITLE	nvarchar(100)	IN
@SALARY	money	IN
@DN_ORGANIZATION	nvarchar(150)	IN
@DN_ZIP5	nvarchar(5)	IN
@EIN	nvarchar(30)	IN
@LINE1	nvarchar(150)	IN
@CITY	nvarchar(50)	IN
@ZIP	nvarchar(10)	IN
@REVENUE	money	IN
@STATE	nvarchar(100)	IN
@PHONE	nvarchar(20)	IN

Definition

Copy



            create procedure dbo.USP_WPNONPROFITOFFICER_ADD (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @WEALTHID uniqueidentifier,
                @SOURCE nvarchar(100),
                @GSID 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(150) = '',
                @TITLE nvarchar(100) = '',
                @SALARY money = 0,
                @DN_ORGANIZATION nvarchar(150) = '',
                @DN_ZIP5 nvarchar(5) = '',
                @EIN nvarchar(30) = '',
                @LINE1 nvarchar(150) = '',
                @CITY nvarchar(50) = '',
                @ZIP nvarchar(10) = '',
                @REVENUE money = 0,
                @STATE nvarchar(100) = '',
                @PHONE nvarchar(20) = ''
            ) as begin

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

                begin try

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

                        set @ID = null;

                    else begin

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

                        insert into dbo.WPNONPROFITOFFICER (
                            ID,ADDEDBYID,CHANGEDBYID,
                            WEALTHID,
                            SOURCE,
                            GSID,
                            REVISION,
                            ORIGINALID,
                            NEWROW,
                            LASTCHANGEDON,
                            ADDEDON,
                            FULLHASH,
                            PARTIALHASH,
                            MC,
                            FULLNAME,
                            TITLE,
                            SALARY,
                            DN_ORGANIZATION,
                            DN_ZIP5,
                            EIN,
                            LINE1,
                            CITY,
                            ZIP,
                            REVENUE,
                            STATE,
                            PHONE
                        ) values (
                            @ID,@CHANGEAGENTID,@CHANGEAGENTID,
                            @WEALTHID,
                            @SOURCE,
                            @GSID,
                            @REVISION,
                            @ORIGINALID,
                            @NEWROW,
                            @LASTCHANGEDON,
                            @ADDEDON,
                            @FULLHASH,
                            @PARTIALHASH,
                            @MC,
                            @FULLNAME,
                            @TITLE,
                            @SALARY,
                            @DN_ORGANIZATION,
                            @DN_ZIP5,
                            @EIN,
                            @LINE1,
                            @CITY,
                            @ZIP,
                            @REVENUE,
                            @STATE,
                            @PHONE
                        );
                    end

                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                end catch

                return 0;
            end;