USP_DATALIST_RECURRINGHISTORYBYTRANSACTION

A datalist of recurring gift activity and schedule by transaction.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDEBITMASK	int	IN	Include

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_RECURRINGHISTORYBYTRANSACTION @ID uniqueidentifier, @INCLUDEBITMASK int = 255
            as
                set @INCLUDEBITMASK = coalesce(@INCLUDEBITMASK, 255)

                select    RGA.ID, 
                        RGA.[TYPE], 
                        RGA.SCHEDULEDATE, 
                        case when RGA.TYPECODE = 0 then RGA.AMOUNT else null end,
            dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATESPLITGROSSAMOUNT(REVENUESPLIT.ID, 1), 
                        case when RGA.TYPECODE = 0 then REVENUE.DATE else null end, 
                        REVENUE.ID
                from RECURRINGGIFTACTIVITY RGA
                inner join REVENUE SOURCE
                    on RGA.SOURCEREVENUEID = SOURCE.ID
                left outer join REVENUESPLIT
                    on RGA.PAYMENTREVENUEID = REVENUESPLIT.ID
                left outer join dbo.REVENUE
                    on REVENUESPLIT.REVENUEID = REVENUE.ID
                where SOURCE.ID = @ID and
                    1 = case RGA.[TYPECODE]
                            when 0 then --PAY

                                case when (@INCLUDEBITMASK & 1 > 0) then 1 else 0 end
                            when 1 then --SKIP

                                case when (@INCLUDEBITMASK & 2 > 0) then 1 else 0 end
                            when 2 then --ROLLBACK

                                case when (@INCLUDEBITMASK & 4 > 0) then 1 else 0 end
                        end