USP_DATALIST_CONSTITUENTPROFILEDASHBOARDGIVINGHISTORY

                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDGIVINGHISTORY
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1
                    )
                    as
                        set nocount on;

                        if @ISVISIBLE = 1
                        begin
                            select
                                R.DATE,
                                R.DATEADDED,
                                R.AMOUNT,
                                case R.TRANSACTIONTYPECODE when 1 then dbo.UFN_PLEDGE_GETBALANCE(R.ID) else null end as BALANCE,
                                R.TRANSACTIONTYPE,
                                dbo.UFN_REVENUE_DESIGNATIONLIST(R.ID) as DESIGNATION
                            from
                                dbo.REVENUE R
                            where
                                (R.TRANSACTIONTYPECODE = 1 or --Pledge

                                ((R.TRANSACTIONTYPECODE = 0 and exists(select top 1 ID from dbo.REVENUESPLIT where REVENUEID = R.ID and APPLICATIONCODE in (0, 3, 4))))) and --Payment (Gift or Recurring gift payment)

                                R.CONSTITUENTID = @CONSTITUENTID
                            order by
                                DATE desc, DATEADDED desc, AMOUNT desc;

                        end