USP_MERGETASK_CONSTITUENTGIFTAID

Parameters

Parameter	Parameter Type	Mode
@SOURCEID	uniqueidentifier	IN
@TARGETID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


                CREATE procedure dbo.USP_MERGETASK_CONSTITUENTGIFTAID
                (
                    @SOURCEID uniqueidentifier,
                    @TARGETID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as
                    set nocount on;

                    declare @CHANGEDATE datetime = getdate();

                    -- If the target constituent is not an individual, then tax declarations can't be copied to their record

                    if exists (    select 1
                                from dbo.CONSTITUENT
                                where
                                    ID = @TARGETID and
                                    ISORGANIZATION = 0 and 
                                    ISGROUP = 0)
                    begin
                        update dbo.TAXDECLARATION set 
                            CONSTITUENTID = @TARGETID,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CHANGEDATE
                        where
                            CONSTITUENTID = @SOURCEID and
                            dbo.UFN_DECLARATION_ISUNIQUE(@TARGETID, CHARITYCLAIMREFERENCENUMBERID, DECLARATIONSTARTS, DECLARATIONENDS, PAYSTAXCODE) = 1
                    end

                    return 0;