UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS

Get FAF event registration options goals

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTPRICEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS(@EVENTPRICEID uniqueidentifier)
returns table
as return
  select 
    '00000000-0000-0000-0000-000000000000' as ID, 
    REGTYPEGOALCODE,
    MINFUNDRAISING,
    ISNOTLOWERFUNDRAISING,
    PARTICIPANTMUSTPAYBALANCE,
    PARTICIPANTPAYSBALANCEMESSAGE,
    RECRUITEMENT,
      ISNOTLOWERRECRUITEMENT,
    VOLUNTEERRECRUITEMENT,
    ISNOTLOWERVOLUNTEERRECRUITEMENT,
    DONORRETENTION,
    ISNOTLOWERDONORRETENTION,
    UNIT,
    ISNOTLOWERUNIT,
      COMMUNICATIONS,
    ISNOTLOWERCOMMUNICATION,
    LABELFORUNIT,
    TARGETFUNDRAISING,
    ISNOTLOWERTARGETFUNDRAISING,
    TEAMS,
    ISNOTLOWERTEAMS,
    TEAMRETENTION,
    ISNOTLOWERTEAMRETENTION,
    TEAMMEMBERS,
    ISNOTLOWERTEAMMEMBERS,
    TEAMMEMBERRETENTION,
    ISNOTLOWERTEAMMEMBERRETENTION
    from dbo.FAFREGISTRATIONTYPEGOAL
  where FAFREGISTRATIONTYPEGOAL.EVENTPRICEID = @EVENTPRICEID