USP_DATALIST_PROSPECTPLAN_STEPSCOMPLETED

                CREATE procedure dbo.USP_DATALIST_PROSPECTPLAN_STEPSCOMPLETED(@PROSPECTPLANID uniqueidentifier)
                as begin
                    set nocount on;
                    select 
                        I.ID,
                        I.STATUS,
                        I.STATUSCODE,
                        I.DATE,
                        I.STARTTIME,
                        I.ENDTIME,
                        FUNDRAISER_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,
                        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.ISCONTACTREPORT
                    from
                        dbo.INTERACTION I
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(I.FUNDRAISERID) FUNDRAISER_NF
                        left outer join dbo.PROSPECTPLANSTATUSCODE PSC on PSC.ID=I.PROSPECTPLANSTATUSCODEID
                        left outer join dbo.INTERACTIONTYPECODE ITC on I.INTERACTIONTYPECODEID = ITC.ID
                    where
                        I.PROSPECTPLANID = @PROSPECTPLANID
                        and I.COMPLETED = 1
                    order by
                        I.ACTUALDATE desc, I.DATEADDED, I.ID
                end