USP_DATALIST_PROSPECTRESEARCHDASHBOARDGIVINGSUMMARY

This datalist returns giving summary information that is used by the prospect research dashboard.
Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ISVISIBLE	bit	IN	Visible
Definition

Copy


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

                        if @ISVISIBLE = 1
                        begin
                            select 
                                FIRSTGIFTAMOUNT,
                                FIRSTGIFTDATE,
                                FIRSTGIFTTYPE,
                                FIRSTGIFTDESIGNATION,
                                LATESTGIFTAMOUNT,
                                LATESTGIFTDATE,
                                LATESTGIFTTYPE,
                                LATESTGIFTDESIGNATION,
                                LARGESTGIFTAMOUNT,
                                LARGESTGIFTDATE,
                                LARGESTGIFTTYPE,
                                LARGESTGIFTDESIGNATION,
                                TOTALGIFTSGIVEN,
                                TOTALGIFTAMOUNT
                            from 
                                dbo.RE7INTEGRATIONGIVINGSUMMARY
                            where
                                ID = @CONSTITUENTID
                        end
                        else
                        begin
                            select top 1
                                FIRSTGIFTAMOUNT,
                                FIRSTGIFTDATE,
                                FIRSTGIFTTYPE,
                                FIRSTGIFTDESIGNATION,
                                LATESTGIFTAMOUNT,
                                LATESTGIFTDATE,
                                LATESTGIFTTYPE,
                                LATESTGIFTDESIGNATION,
                                LARGESTGIFTAMOUNT,
                                LARGESTGIFTDATE,
                                LARGESTGIFTTYPE,
                                LARGESTGIFTDESIGNATION,
                                TOTALGIFTSGIVEN,
                                TOTALGIFTAMOUNT
                            from 
                                dbo.RE7INTEGRATIONGIVINGSUMMARY
                            where
                                ID = @CONSTITUENTID
                        end