USP_DATALIST_PROSPECTPLAN_STEPSPLANNED

                CREATE procedure dbo.USP_DATALIST_PROSPECTPLAN_STEPSPLANNED(@PROSPECTPLANID uniqueidentifier)
                as begin
                    set nocount on;
                    select 
                        I.ID,
                        I.STATUS,
                        I.STATUSCODE,
                        I.DATE,
                        NF.NAME,
                        I.OBJECTIVE,
                        PSC.DESCRIPTION,
                        case when exists(select 1 from dbo.INTERACTIONNOTE where INTERACTIONNOTE.INTERACTIONID=I.ID)
                               or exists(select 1 from dbo.INTERACTIONATTACHMENT where INTERACTIONATTACHMENT.INTERACTIONID=I.ID)
                               or exists(select 1 from dbo.INTERACTIONMEDIALINK where INTERACTIONMEDIALINK.INTERACTIONID=I.ID)
                        then convert(bit,1) else convert(bit,0) end,
                        I.ISINTERACTION,
                        PPTC.DESCRIPTION as PROSPECTPLANTYPE,
                        NF_C.NAME as CONSTITUENTNAME,
                        ITC.DESCRIPTION as CONTACTMETHOD,
                        case
                            when exists (select ID from INTERACTIONADDITIONALFUNDRAISER where INTERACTIONID = I.ID) then convert(bit, 1)
                            else convert(bit, 0)
                        end HASADDITIONALFUNDRAISERS,
                        I.DATEADDED,
                        case
                            when exists (select ID from dbo.INTERACTIONPARTICIPANT where INTERACTIONID = I.ID) then convert(bit, 1)
                            else convert(bit, 0)
                        end HASPARTICIPANTS,
                        I.STARTTIME,
                        I.ENDTIME,
                        (select DISPLAYNAME from TIMEZONEENTRY where TIMEZONEENTRY.ID = I.TIMEZONEENTRYID) as TIMEZONE
                    from
                        dbo.INTERACTION I
                        inner join dbo.PROSPECTPLAN PP on I.PROSPECTPLANID = PP.ID
                        inner join dbo.PROSPECTPLANTYPECODE PPTC on PP.PROSPECTPLANTYPECODEID = PPTC.ID
                        left outer join dbo.PROSPECTPLANSTATUSCODE PSC on PSC.ID=I.PROSPECTPLANSTATUSCODEID
                        left outer join dbo.INTERACTIONTYPECODE ITC on I.INTERACTIONTYPECODEID = ITC.ID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(I.FUNDRAISERID) NF
                        cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(I.CONSTITUENTID) NF_C
                    where
                        I.PROSPECTPLANID = @PROSPECTPLANID
                        and I.COMPLETED = 0
                    order by
                        I.EXPECTEDDATE, I.DATEADDED, I.ID
                end