USP_DATAFORMTEMPLATE_VIEW_COMMITTEESUMMARY

        create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_COMMITTEESUMMARY
        (
                @ID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier=null,
                @DATALOADED bit = 0 output,
                @CANCOORDINATEEVENTS bit = null output,
                @CANSOLICITREVENUE bit = null output,
                @GROUPGOALS xml = null output,
                @GROUPEVENTID uniqueidentifier = null output,
                @GROUPEVENTNAME nvarchar(100) = null output,
                @TOTALRAISED money = null output,
                @CAMPAIGNID uniqueidentifier = null output,
                @CAMPAIGNNAME nvarchar(100) = null output,
                @CAMPAIGNPOSITIONID_TRANSLATION nvarchar(100) = null output,
                @CAMPAIGNTASKID_TRANSLATION nvarchar(100) = null output,
                @BASECURRENCYID uniqueidentifier = null output
        )
         as
                set nocount on;

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                set @DATALOADED = 0;

                --CONSTIT FIELDS
                select @DATALOADED = 1,
                @CANCOORDINATEEVENTS = CANCOORDINATEEVENTS,
                @CANSOLICITREVENUE = CANSOLICITREVENUE
                from dbo.COMMITTEE where COMMITTEE.ID = @ID;

                select top 1
                @GROUPEVENTID = EVENT.ID,
                @GROUPEVENTNAME = EVENT.NAME
                from dbo.EVENTCOORDINATOR
                inner join dbo.EVENT
                on EVENT.ID = EVENTCOORDINATOR.EVENTID
                where CONSTITUENTID = @ID
                order by EVENT.ISACTIVE desc,
                case when EVENT.ENDDATE >= @CURRENTDATE then 0 else 1 end asc,
                EVENT.STARTDATE asc,
                EVENT.NAME asc;

                set @GROUPGOALS = (select top 2 ID,ISFUNDRAISINGGOAL,GROUPGOALUNITCODEID, 
                AMOUNT,NAME,GOALDATE,BASECURRENCYID
                from dbo.UFN_GROUPGOAL_DATALIST(@ID,null) order by 
                DATESORT desc,
                Case DATESORT When 1 Then GOALDATE When 0 Then null Else GetDate() - GOALDATE End asc
                for xml raw('ITEM'),type,elements,root('GROUPGOALS'),BINARY BASE64);

                select top 1
                @CAMPAIGNID = CAMPAIGN.ID,
                @CAMPAIGNNAME = CAMPAIGN.NAME,
                @CAMPAIGNPOSITIONID_TRANSLATION = CAMPAIGNFUNDRAISERPOSITIONCODE.DESCRIPTION,
                @CAMPAIGNTASKID_TRANSLATION = CAMPAIGNFUNDRAISERTASKCODE.DESCRIPTION
                from dbo.CAMPAIGNFUNDRAISER inner join dbo.CAMPAIGN
                on CAMPAIGNFUNDRAISER.CAMPAIGNID = CAMPAIGN.ID
                left join CAMPAIGNFUNDRAISERPOSITIONCODE
                on CAMPAIGNFUNDRAISER.CAMPAIGNFUNDRAISERPOSITIONCODEID = CAMPAIGNFUNDRAISERPOSITIONCODE.ID
                left join CAMPAIGNFUNDRAISERTASKCODE
                on CAMPAIGNFUNDRAISER.CAMPAIGNFUNDRAISERTASKCODEID = CAMPAIGNFUNDRAISERTASKCODE.ID
                where CAMPAIGNFUNDRAISER.CONSTITUENTID = @ID order by 
                case when CAMPAIGNFUNDRAISER.DATETO >= @CURRENTDATE then 0 else 1 end asc,
                CAMPAIGNFUNDRAISER.DATEFROM asc,
                CAMPAIGN.NAME asc;

                set @BASECURRENCYID = dbo.UFN_APPUSER_GETBASECURRENCY(@CURRENTAPPUSERID);
                set @TOTALRAISED = dbo.UFN_REVENUESOLICITOR_GETSUM_INCURRENCY(@ID, null, null, @BASECURRENCYID);

                return 0;