UFN_INDEPENDENTTEAMLEADERLIST

This table function return a list of team leaders within an independent team , input parameter is the team captain IDthe team captain ID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_INDEPENDENTTEAMLEADERLIST
      (
          @CONSTITUENTID uniqueidentifier = NULL
          ,@EVENTID uniqueidentifier = NULL
      )
      returns table  
      as  
      return  
      (  
      select 
          FNTEAM.TEAMNAME,  
          FNTEAM.TEAMID,
          C.keyname, 
          C.name,
          C.ID 
      from dbo.UFN_FAF_GETTEAMINFO_BY_REGISTRANT(@CONSTITUENTID, @EVENTID) FNTEAM
      INNER JOIN TEAMEXTENSION TE  
          ON FNTEAM.TEAMID = TE.TEAMFUNDRAISINGTEAMID  
          AND TE.TYPECODE = 1 AND TE.STATUSCODE = 0 
      INNER JOIN dbo.TEAMFUNDRAISINGTEAMCAPTAIN TC  --retrieve team leaders

          ON FNTEAM.TEAMID = TC.TEAMFUNDRAISINGTEAMID
      INNER JOIN dbo.CONSTITUENT C
          ON TC.CONSTITUENTID = C.ID  
      WHERE FNTEAM.TEAMTYPECODE = 1  --team 

      )