USP_DATALIST_FAFEVENTDONATIONOPTIONSCONFIG

CREATE procedure dbo.USP_DATALIST_FAFEVENTDONATIONOPTIONSCONFIG
(@EVENTID uniqueidentifier) with execute as caller

as
    set nocount on;

    select 
        FAFEVENTDONATIONOPTIONSCONFIG.[ID],
        FAFEVENTDONATIONOPTIONSCONFIG.[EVENTID],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISENABLEDONATIONS],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISENABLERECURRINGGIFTS],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISENABLEPLEDGES],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISALLOWTEAMDONATIONS],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISALLOWCOMPANYDONATIONS],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISALLOWEVENTDONATIONS],
        FAFEVENTDONATIONOPTIONSCONFIG.[MINIMUMDONATIONAMOUNT],
        FAFEVENTDONATIONOPTIONSCONFIG.[MAXIMUMTRANSACTIONAMOUNT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISALLOWDONATIONSFROMORGS],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEMONTHLYGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEANNUALLYGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEQUARTERLYGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEWEEKLYGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISALLOWDONORTOSELECTSTARTDATEGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[STARTDATEONORBEFOREGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISSTARTDATESAMEASDAYTOSUBMITGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[DONORONORBEFOREDATEGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISALLOWDONORTOSELECTSTARTDATEPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[STARTDATEONORBEFOREPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[DONORONORBEFOREDATEPLEDGE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINESINGLEGIFT],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISFREQUENCYAVAILONLINESINGLEPLEDGE],

        FAFEVENTDONATIONOPTIONSCONFIG.[ISUNPAIDPLEDGES],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISUNPAIDRECURRINGGIFTS],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISSPONSORSHIPREVENUE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISUNPAIDSPONSORSHIPREVENUE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISREGISTRATIONREVENUE],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISPENDINGMATCHINGGIFTS],
        FAFEVENTDONATIONOPTIONSCONFIG.[UNCONFIRMEDPARTICIPANTGIFTENTRY],
        FAFEVENTDONATIONOPTIONSCONFIG.[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR],
    FAFEVENTDONATIONOPTIONSCONFIG.[ISALLOWHOUSEHOLDDONATIONS]   

    from 
        dbo.FAFEVENTDONATIONOPTIONSCONFIG
    where
        EVENTID = ISNULL(@EVENTID,EVENTID)