USP_WEALTHPOINT_UPDATEWEALTHSUMMARY_AFFLUENCEINDICATOR

Updates the affluence indicator wealth summary information for a given wealth record.

Parameters

Parameter	Parameter Type	Mode	Description
@WEALTHID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_WEALTHPOINT_UPDATEWEALTHSUMMARY_AFFLUENCEINDICATOR (
                @WEALTHID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null
            ) as begin
                set nocount on;

                declare @CURRENTDATE datetime;

                set @CURRENTDATE = getdate();

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

                if exists (select WEALTH.ID from dbo.WEALTH where WEALTH.ID = @WEALTHID) begin
                    declare @AFFLUENCEINDICATORASSETS money, @AFFLUENCEINDICATORASSETSCONFIRMED money, @AFFLUENCEINDICATORNUMBER int, @AFFLUENCEINDICATORNUMBERCONFIRMED int;

                    select @AFFLUENCEINDICATORNUMBER = count(*), @AFFLUENCEINDICATORASSETS = sum(RPASSETS) from dbo.WPAFFLUENCEINDICATOR where WEALTHID = @WEALTHID and REJECTED = 0;
                    select @AFFLUENCEINDICATORNUMBERCONFIRMED = count(*), @AFFLUENCEINDICATORASSETSCONFIRMED = sum(RPASSETS) from dbo.WPAFFLUENCEINDICATOR  where WEALTHID = @WEALTHID and CONFIRMED = 1;

                    update
                        dbo.WEALTH
                    set
                        AFFLUENCEINDICATORASSETS = coalesce(@AFFLUENCEINDICATORASSETS,0),
                        AFFLUENCEINDICATORASSETSCONFIRMED = coalesce(@AFFLUENCEINDICATORASSETSCONFIRMED,0),
                        AFFLUENCEINDICATORNUMBER = coalesce(@AFFLUENCEINDICATORNUMBER,0),
                        AFFLUENCEINDICATORNUMBERCONFIRMED = coalesce(@AFFLUENCEINDICATORNUMBERCONFIRMED,0),
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @WEALTHID;
                end
            end