USP_DATALIST_CONSTITUENTPROFILEDASHBOARDRECOGNITIONSUMMARY2

            CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDRECOGNITIONSUMMARY2
            (
              @CONSTITUENTID uniqueidentifier,
              @ISVISIBLE bit = 1,
              @SELECTEDCURRENCYID uniqueidentifier = null,
              @CURRENTAPPUSERID uniqueidentifier,
              @SECURITYFEATUREID uniqueidentifier = null,
              @SECURITYFEATURETYPE tinyint = null
            ) as
                set nocount on;



                declare
                  @SITEFILTERMODE tinyint = 0,
                  @SITESSELECTED nvarchar(max) = null,
                  @DATEFILTER tinyint = 10, --ALL DATES 

                  @CURRENCYCODE tinyint = 3, --My Base

                  @RECOGNITIONFILTERID uniqueidentifier = null,
                  @STARTDATE datetime,
                  @ENDDATE datetime,
                  @HOUSEHOLDID uniqueidentifier = null,
                  @ISGROUP bit = 0,
                  @RECOGNITIONTOTALNUMBER int = null,
                  @RECOGNITIONTOTALAMOUNT money = null,
                  @RECOGNITIONTOTALAMOUNT_HOUSEHOLD money = null,
                  @RECOGNITIONTOTALYEARS int = null,
                  @RECOGNITIONCONSECUTIVEYEARS int = null,
                  @RECOGNITIONGIVENSINCEFISCALYEAR datetime = null,
                  @TOTALRECOGNITIONWITHGIFTAID money = null,

                  @RECOGNITIONFIRSTID uniqueidentifier = null,
                  @RECOGNITIONFIRSTRECORDID uniqueidentifier = null,
                  @RECOGNITIONFIRSTDATE datetime = null,
                  @RECOGNITIONFIRSTTYPECODE tinyint = null,
                  @RECOGNITIONFIRSTTYPE nvarchar(50) = null,
                  @RECOGNITIONFIRSTAMOUNT money = null,
                  @RECOGNITIONLATESTID uniqueidentifier = null,
                  @RECOGNITIONLATESTRECORDID uniqueidentifier = null,
                  @RECOGNITIONLATESTDATE datetime = null,
                  @RECOGNITIONLATESTTYPECODE tinyint = null,
                  @RECOGNITIONLATESTTYPE nvarchar(50) = null,
                  @RECOGNITIONLATESTAMOUNT money = null,

                  @CURRENCYISOCURRENCYCODE nvarchar(3) = null,
                  @CURRENCYDECIMALDIGITS tinyint = 0,
                  @CURRENCYSYMBOL nvarchar(5) = null,
                  @CURRENCYSYMBOLDISPLAYSETTINGCODE tinyint = 0

            if @ISVISIBLE = 1
            begin

                  if @SELECTEDCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY()
                    set @CURRENCYCODE = 1

                  exec [dbo].[USP_RESOLVEDATEFILTER] @DATEFILTER, @STARTDATE output, @ENDDATE output;

                  /*Get Household ID*/
                  select top(1) @HOUSEHOLDID = GM.GROUPID
                  from dbo.GROUPMEMBER as GM
                  left outer join dbo.GROUPDATA as GD on GD.ID = GM.GROUPID
                  where GM.MEMBERID = @CONSTITUENTID
                  and GD.GROUPTYPECODE = 0
                  and dbo.UFN_GROUPMEMBER_ISCURRENTMEMBER(GM.ID) = 1;

                  /* see if this is a household */
                  if @HOUSEHOLDID is null
                    select
                        @ISGROUP = 1
                    from dbo.GROUPDATA 
                    where GROUPDATA.ID = @CONSTITUENTID ;


                  if (exists(select top 1 ID from dbo.GROUPDATA where ID = @CONSTITUENTID))
                    select @RECOGNITIONFILTERID = ID from dbo.RECOGNITIONFILTER where ISHOUSEHOLDDEFAULT = 1;
                  else
                    select @RECOGNITIONFILTERID = ID from dbo.RECOGNITIONFILTER where ISINDIVIDUALDEFAULT = 1;


                  exec dbo.USP_CONSTITUENT_RECOGNITIONSUMMARYEXPANDED_2
                      @CONSTITUENTID,
                      @ISGROUP,
                      @HOUSEHOLDID,
                      @RECOGNITIONFILTERID,
                      @STARTDATE,
                      @ENDDATE,
                      @CURRENTAPPUSERID,
                      @SITEFILTERMODE,
                      @SITESSELECTED,
                      @SECURITYFEATUREID,
                      @SECURITYFEATURETYPE,
                      @CURRENCYCODE,

                      @RECOGNITIONTOTALNUMBER output,
                      @RECOGNITIONTOTALAMOUNT output,
                      @RECOGNITIONTOTALAMOUNT_HOUSEHOLD output,
                      @RECOGNITIONTOTALYEARS output,
                      @RECOGNITIONCONSECUTIVEYEARS output,
                      @RECOGNITIONGIVENSINCEFISCALYEAR output,
                      @TOTALRECOGNITIONWITHGIFTAID output,

                      @RECOGNITIONFIRSTID output,
                      @RECOGNITIONFIRSTRECORDID output,
                      @RECOGNITIONFIRSTDATE output,
                      @RECOGNITIONFIRSTTYPECODE output,
                      @RECOGNITIONFIRSTTYPE output,
                      @RECOGNITIONFIRSTAMOUNT output,
                      @RECOGNITIONLATESTID output,
                      @RECOGNITIONLATESTRECORDID output,
                      @RECOGNITIONLATESTDATE output,
                      @RECOGNITIONLATESTTYPECODE output,
                      @RECOGNITIONLATESTTYPE output,
                      @RECOGNITIONLATESTAMOUNT output,
                      @CURRENCYISOCURRENCYCODE output,
                      @CURRENCYDECIMALDIGITS output,
                      @CURRENCYSYMBOL output,
                      @CURRENCYSYMBOLDISPLAYSETTINGCODE output
            end              


                  select
                      @RECOGNITIONTOTALNUMBER as RECOGNITIONTOTALNUMBER,
                      @RECOGNITIONTOTALAMOUNT as RECOGNITIONTOTALAMOUNT,
                      @RECOGNITIONTOTALAMOUNT_HOUSEHOLD as RECOGNITIONTOTALAMOUNT_HOUSEHOLD,
                      @RECOGNITIONTOTALYEARS as RECOGNITIONTOTALYEARS,
                      @RECOGNITIONGIVENSINCEFISCALYEAR as RECOGNITIONGIVENSINCEFISCALYEAR,
                      @RECOGNITIONCONSECUTIVEYEARS as RECOGNITIONCONSECUTIVEYEARS,

                      @RECOGNITIONFIRSTID as RECOGNITIONFIRSTID,
                      @RECOGNITIONFIRSTRECORDID as RECOGNITIONFIRSTRECORDID,
                      @RECOGNITIONFIRSTDATE as RECOGNITIONFIRSTDATE,
                      @RECOGNITIONFIRSTTYPECODE as RECOGNITIONFIRSTTYPECODE,
                      @RECOGNITIONFIRSTTYPE as RECOGNITIONFIRSTTYPE,
                      @RECOGNITIONFIRSTAMOUNT as RECOGNITIONFIRSTAMOUNT,
                      @RECOGNITIONLATESTID as RECOGNITIONLATESTID,
                      @RECOGNITIONLATESTRECORDID as RECOGNITIONLATESTRECORDID,
                      @RECOGNITIONLATESTDATE as RECOGNITIONLATESTDATE,
                      @RECOGNITIONLATESTTYPECODE as RECOGNITIONLATESTTYPECODE,
                      @RECOGNITIONLATESTTYPE as RECOGNITIONLATESTTYPE,
                      @RECOGNITIONLATESTAMOUNT as RECOGNITIONLATESTAMOUNT,
                      @TOTALRECOGNITIONWITHGIFTAID as TOTALRECOGNITIONWITHGIFTAID,

                      @CURRENCYISOCURRENCYCODE as CURRENCYISOCURRENCYCODE,
                      @CURRENCYDECIMALDIGITS as CURRENCYDECIMALDIGITS,
                      @CURRENCYSYMBOL as CURRENCYSYMBOL,
                      @CURRENCYSYMBOLDISPLAYSETTINGCODE as CURRENCYSYMBOLDISPLAYSETTINGCODE


                return 0;