UFN_FAFEVENT_GETGROUPPAGEPRIVACYFROMGROUPLEADER

               Create function dbo.UFN_FAFEVENT_GETGROUPPAGEPRIVACYFROMGROUPLEADER 
               (  
                @GROUPID uniqueidentifier,
                @TYPECODE integer = 3  --1: team, 2:company, 3: household only household for now

               )   
               returns integer   
               with execute as caller  
               as  
               begin  

                    DECLARE @RETPRIVATECODE integer = 0

                    --SELECT @RETPRIVATECODE=RE.ISPRIVATE, TE.TEAMFUNDRAISINGTEAMID, TE.TYPECODE

                    SELECT @RETPRIVATECODE=ISNULL(RE.ISPRIVATE,0)
                    FROM REGISTRANTEXTENSION RE INNER JOIN REGISTRANT REG ON REG.ID=RE.REGISTRANTID 
                    INNER JOIN TEAMFUNDRAISINGTEAMCAPTAIN TFTC ON TFTC.CONSTITUENTID=REG.CONSTITUENTID 
                    INNER JOIN TEAMEXTENSION TE ON TE.TEAMFUNDRAISINGTEAMID=TFTC.TEAMFUNDRAISINGTEAMID 
                    WHERE TFTC.TEAMFUNDRAISINGTEAMID=@GROUPID AND TE.TYPECODE=@TYPECODE 

                    --SELECT @RETPRIVATECODE               

                    return @RETPRIVATECODE
               end