USP_DATALIST_FUNDINGREQUEST_STEPS

                CREATE procedure dbo.USP_DATALIST_FUNDINGREQUEST_STEPS(@FUNDINGREQUESTID 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,
                        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
                    from
                        dbo.INTERACTION I
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(I.FUNDRAISERID) NF
                        left outer join dbo.FUNDINGREQUESTSTAGECODE PSC on PSC.ID=I.FUNDINGREQUESTSTAGECODEID
                        left outer join dbo.INTERACTIONTYPECODE ITC on I.INTERACTIONTYPECODEID = ITC.ID
                    where
                        I.FUNDINGREQUESTID = @FUNDINGREQUESTID
                    order by
                        I.DATE, I.DATEADDED, I.ID
                end