UFN_FAFEVENT_GETEVENTSPONSORSHIPOPTION

Get FAF event sponsorship options

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@EVENTID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_FAFEVENT_GETEVENTSPONSORSHIPOPTION(@EVENTID uniqueidentifier)
returns table
  as return
    select
      '00000000-0000-0000-0000-000000000000' as ID, ID as COPYSOURCEID, @EVENTID as COPYBATCHGUID, NAME, DESCRIPTION, ISNOTAVAILABLEONLINEREG, FEESAMOUNT, TAXDEDUCTIBLEAMOUNT, 
      null as EARLYREGISTRATIONDATE, EARLYREGISTRATIONDISCOUNT, null as LATEFEEDATE, LATEFEE,
    MINFUNDRAISINGGOAL, ISNOTLOWERFUNDRAISINGGOAL, SPONSORMUSTPAYBALANCE, SPONSORPAYSBALANCEMESSAGE, RECRUITEMENT, ISNOTLOWERRECRUITEMENT, VOLUNTEERRECRUITEMENT,
    ISNOTLOWERVOLUNTEERRECRUITEMENT,DONORRETENTION, ISNOTLOWERDONORRETENTION, UNIT, ISNOTLOWERUNIT, COMMUNICATIONS, ISNOTLOWERCOMMUNICATION, LABELFORUNITGOAL,
    NUMBERAVAILABLE, TURNONWAITLIST, DISPLAYSPOTSAVAILABLE, SENDEVENTCONTACTALERTMAXREACHED, ALLOWSPONSORWAIVEBENEFITS, WAITLISTMESSAGE, ISACTIVE
    from
      dbo.EVENTSPONSORSHIPTYPE
    where EVENTID = @EVENTID