UFN_FAF_ISPARTICIPANTS

create function dbo.UFN_FAF_ISPARTICIPANTS(@CONSTITUENTID uniqueidentifier) 
returns bit
with execute as caller
as begin
    -- registrant

   if Exists(Select c.ID from REGISTRANT rg inner join CONSTITUENT c on c.ID = rg.CONSTITUENTID
                      inner join REGISTRANTEXTENSION rt on rg.ID = rt.RegistrantID
                      where c.ID = @CONSTITUENTID)
        return 1  
   -- sponsor

   if Exists(Select ES.ID from EVENTSPONSOR ES 
                    INNER JOIN EVENTEXTENSION ET ON ES.EVENTID = ET.EVENTID
                    Where ES.CONSTITUENTID = @CONSTITUENTID)
        return 1
   -- team

   if EXISTS(SELECT ET.ID from TEAMEXTENSION ET
                INNER JOIN EVENTEXTENSION ES ON ET.EVENTID = ES.EVENTID
                Where ET.TEAMCONSTITUENTID = @CONSTITUENTID)
       return 1

    -- donors

    if EXISTS(Select R.APPEALID from REVENUE R
                INNER JOIN [EVENT] E ON R.APPEALID = E.APPEALID
                INNER JOIn EVENTEXTENSION ES ON ES.EVENTID = E.ID
               Where R.CONSTITUENTID = @CONSTITUENTID)
       return 1

   return 0
end