UFN_FAFEVENT_GETEVENTTEAMFAFCONFIG

Get FAF Event fundraising group configuration
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
Definition

Copy


create function dbo.UFN_FAFEVENT_GETEVENTTEAMFAFCONFIG(@EVENTID uniqueidentifier)
returns table
        as return
            select
                '00000000-0000-0000-0000-000000000000' as ID, 
        ID as COPYSOURCEID,
        @EVENTID as COPYBATCHGUID,        
                INDIVIDUALSFUNDRAISE, 
        HOUSEHOLDSFUNDRAISE, 
        HOUSEHOLDAPPROVEBYEVENTADMIN, 
        HOUSEHOLDSJOINTEAMS, 
        TEAMSFUNDRAISE, 
        TEAMSREQUESTFUNDRAISE, 
            TEAMNAMECHANGEAFTERREG, 
        TEAMLEADERAPPOINTTEAMCOLEADERS, 
        TEAMLEADERAPPROVETEAMMEMBERS, 
        TEAMLEADEROPTIONAPPROVETEAMMEMBERS, 
        COMPANIESFUNDRAISE, 
            COMPANYTEAMSAPPROVEBYEVENTADMIN, 
        COMPANYLEADERAPPOINTCOMPANYCOLEADERS, 
        COMPANYLEADERAPPROVETEAMS, 
        COMPANYLEADEROPTIONAPPROVETEAMS, 
        COMPANYNAMECHANGEAFTERREG,
            HOUSEHOLDMEMBERSLIMIT, 
        TEAMMEMBERSLIMIT, 
        COMPANYTEAMSLIMIT, 
        COMPANYTEAMMEMBERSLIMIT, 
        PARTICIPANTSCANREACTIVATETEAMS, 
        FORMERTEAMCANREACTIVATETEAMSCODE,
            PARTICIPANTSCANREACTIVATECOMPANYTEAMS, 
        FORMERCOMPANYCANREACTIVATETEAMSCODE,
        PARTICIPANTSCANREACTIVATEHOUSEHOLDS,
        FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE,
        HOUSEHOLDLEADERAPPOINTHOUSEHOLDCOLEADERS
            from
                dbo.EVENTTEAMFAFCONFIG
            where
                EVENTID=@EVENTID;