USP_DATALIST_EVENT_FAFAUTOCHARGE

List of all Individual Participant, teams, companies, household ready for auto-charge fundraising minimum

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_EVENT_FAFAUTOCHARGE
                (
                    @EVENTID uniqueidentifier = null
                )
                as
                set nocount on;

        select        R.ID 
                            , dbo.UFN_REGISTRANT_GETNAME(R.ID) as [NAME]
                            , isnull(dbo.UFN_REVENUE_GETPARTICIPANTRAISEDTOTAL(R.ID,@EVENTID), 0) as [AmountRaised]
                            , dbo.UFN_REGISTRANT_GETFUNDRAISINGMINIMUM(R.ID) as Minimum
                            , dbo.UFN_REGISTRANT_GETFUNDRAISINGMINIMUMREMAINING(R.ID, @EVENTID) as Remaining
                            , dbo.UFN_REGISTRANT_GETTARGETFUNDRAISING(R.ID) as [Target]
                      --,dbo.UFN_FAFEVENTREGISTRANT_GETREGISTRANTRECORDTYPE(R.ID) as [RECORD_TYPE] 

                            , AG.[ROLE] AS RECORD_TYPE

        from            dbo.REGISTRANT R 
        inner join  dbo.UFN_REGISTRANT_GETFAFROLE (@EVENTID, NULL) AG ON R.ID = AG.REGISTRANTID 
        inner join    dbo.REGISTRANTREGISTRATION RR        ON R.ID = RR.REGISTRANTID 
        inner join    dbo.FAFREGISTRATIONTYPEGOAL FTG    ON RR.EVENTPRICEID = FTG.EVENTPRICEID AND FTG.REGTYPEGOALCODE= 0 AND FTG.PARTICIPANTMUSTPAYBALANCE = 1

        where           R.EVENTID = @EVENTID 
        and                isnull(dbo.UFN_REVENUE_GETPARTICIPANTRAISEDTOTAL(R.ID,@EVENTID), 0)  < dbo.UFN_REGISTRANT_GETFUNDRAISINGMINIMUM(R.ID) 
        and           dbo.UFN_REGISTRANT_GETFUNDRAISINGMINIMUMREMAINING(R.ID,@EVENTID) > 0
        and           dbo.UFN_REGISTRANT_GETFUNDRAISINGMINIMUMREMAINING(R.ID,@EVENTID) > dbo.UFN_REGISTRANT_GETSELFPLEDGEBALANCE(R.ID)
        order by      dbo.UFN_REGISTRANT_GETNAME(R.ID)