USP_CONSTITUENTSOURCEANALYSIS_UPDATESYSTEMCONSTITUENCY

Updates cached system constituency values for source analysis.

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_CONSTITUENTSOURCEANALYSIS_UPDATESYSTEMCONSTITUENCY
            (
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
            set nocount on;

            begin try
                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
                if @CHANGEDATE is null
                    set @CHANGEDATE = getdate();

                exec dbo.USP_CONSTITUENTSOURCEANALYSIS_UPDATECOMMUNITYMEMBER @CHANGEAGENTID, @CHANGEDATE;

                exec dbo.USP_CONSTITUENTSOURCEANALYSIS_UPDATEDONOR @CHANGEAGENTID, @CHANGEDATE;

                exec dbo.USP_CONSTITUENTSOURCEANALYSIS_UPDATEMGO @CHANGEAGENTID, @CHANGEDATE;

                exec dbo.USP_CONSTITUENTSOURCEANALYSIS_UPDATEMEMBERSHIPMEMBER @CHANGEAGENTID, @CHANGEDATE;

            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;