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