UFN_FAF_HOUSEHOLDMEMBERLIST_BY_HOUSEHOLDID

This function takes teamID of the household and returns a list of household members

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TEAMID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_FAF_HOUSEHOLDMEMBERLIST_BY_HOUSEHOLDID(@TEAMID uniqueidentifier)
   returns table  
   as  
   return  
   (  
    select  
     TFT.name as TEAMNAME,  
     TFT.ID as TEAMID,
     C.keyname, 
     C.name,
     C.ID 
    from  
     dbo.TEAMFUNDRAISINGTEAMMEMBER TM
     inner join dbo.TEAMEXTENSION TE 
        on TM.TEAMFUNDRAISINGTEAMID = TE.TEAMFUNDRAISINGTEAMID
        and TE.TYPECODE = 3 --household

     inner join dbo.TEAMFUNDRAISINGTEAM TFT
        on TE.TEAMFUNDRAISINGTEAMID = TFT.id
     inner join dbo.TEAMFUNDRAISER TF
        on TM.TEAMFUNDRAISERID = TF.ID
     inner join dbo.CONSTITUENT C
        on TF.CONSTITUENTID = C.ID
   where TM.TEAMFUNDRAISINGTEAMID = @TEAMID
   )