UFN_FAFEVENT_GETREVENUEOPTION

create function dbo.UFN_FAFEVENT_GETREVENUEOPTION(@EVENTID uniqueidentifier)
returns table
  as return
    select
      '00000000-0000-0000-0000-000000000000' as ID, 
      ID as COPYSOURCEID, 
      @EVENTID as COPYBATCHGUID, 
      ALLOWGIFTTYPEONETIMEDONATION,
      ALLOWGIFTTYPERECURRING,
      ALLOWGIFTTYPEPLEDGE,
      ISENABLEDONATIONS,
      ISENABLERECURRINGGIFTS,
      ISENABLEPLEDGES,
      ISALLOWTEAMDONATIONS,
      ISALLOWCOMPANYDONATIONS,
      ISALLOWEVENTDONATIONS,
      MINIMUMDONATIONAMOUNT,
      MAXIMUMTRANSACTIONAMOUNT,
      ISALLOWDONATIONSFROMORGS,
      ISFREQUENCYAVAILONLINEMONTHLYGIFT,
      ISFREQUENCYAVAILONLINEANNUALLYGIFT,
      ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT,
      ISFREQUENCYAVAILONLINEQUARTERLYGIFT,
      ISFREQUENCYAVAILONLINEBIMONTHLYGIFT,
      ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT,
      ISFREQUENCYAVAILONLINEBIWEEKLYGIFT,
      ISFREQUENCYAVAILONLINEWEEKLYGIFT,
      ISFREQUENCYAVAILONLINESINGLEGIFT,
      ISALLOWDONORTOSELECTSTARTDATEGIFT,
      STARTDATEONORBEFOREGIFT,
      ISSTARTDATESAMEASDAYTOSUBMITGIFT,
      DONORONORBEFOREDATEGIFT,
      ISFREQUENCYAVAILONLINEMONTHLYPLEDGE,
      ISFREQUENCYAVAILONLINEANNUALLYPLEDGE,
      ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE,
      ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE,
      ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE,
      ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE,
      ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE,
      ISFREQUENCYAVAILONLINEWEEKLYPLEDGE,
      ISFREQUENCYAVAILONLINESINGLEPLEDGE,
      ISALLOWDONORTOSELECTSTARTDATEPLEDGE,
      STARTDATEONORBEFOREPLEDGE,
      ISSTARTDATESAMEASDAYTOSUBMITPLEDGE,
      DONORONORBEFOREDATEPLEDGE,
      ISUNPAIDPLEDGES,
      ISUNPAIDRECURRINGGIFTS,
      ISSPONSORSHIPREVENUE,
      ISUNPAIDSPONSORSHIPREVENUE,
      ISREGISTRATIONREVENUE,
      ISPENDINGMATCHINGGIFTS,
      UNCONFIRMEDPARTICIPANTGIFTENTRY,
      ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR
    from 
      dbo.FAFEVENTDONATIONOPTIONSCONFIG
    where EVENTID = @EVENTID