USP_DATAFORMTEMPLATE_VIEW_PROSPECTSUMMARY

        create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PROSPECTSUMMARY
        (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @PROSPECTMANAGERFUNDRAISERID uniqueidentifier = null output,
            @PROSPECTMANAGER nvarchar(700) = null output,
            @PROSPECTSTATUS nvarchar(100) = null output,
            @PROSPECTMANAGERSTARTDATE datetime = null output
        ) as
            set nocount on;
            set @DATALOADED = 0;

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

            select
                @DATALOADED = 1,
                @PROSPECTMANAGERFUNDRAISERID = case when P.PROSPECTMANAGERENDDATE < @CURRENTDATEEARLIESTTIME then null else P.PROSPECTMANAGERFUNDRAISERID end,
                @PROSPECTMANAGER = case when P.PROSPECTMANAGERENDDATE < @CURRENTDATEEARLIESTTIME then null else PROSPECTMANAGER_NF.NAME end,
                @PROSPECTSTATUS = dbo.UFN_PROSPECTSTATUSCODE_GETDESCRIPTION(P.PROSPECTSTATUSCODEID),
                @PROSPECTMANAGERSTARTDATE = case when P.PROSPECTMANAGERENDDATE < @CURRENTDATEEARLIESTTIME then null else P.PROSPECTMANAGERSTARTDATE end
            from 
                dbo.CONSTITUENT C
                left outer join dbo.PROSPECT P on P.ID=C.ID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(P.PROSPECTMANAGERFUNDRAISERID) PROSPECTMANAGER_NF
            where
                C.ID = @ID;

            return 0;