USP_DATALIST_FAFREGISTRATIONGOALS
Returns FAF Fundraising and other Goals as specified by the Admin
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | Event ID |
| @EVENTPRICEID | uniqueidentifier | IN | Event Price ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_FAFREGISTRATIONGOALS(@EVENTID uniqueidentifier, @EVENTPRICEID uniqueidentifier = null) with execute as owner
as
set nocount on;
select distinct
EVENTPRICE.ID,
EVENTPRICE.EVENTID,
EVENTPRICE.NAME,
EVENTPRICE.AMOUNT,
FAFREGISTRATIONTYPEGOAL.REGTYPEGOALCODE,
FAFREGISTRATIONTYPEGOAL.REGTYPEGOAL,
FAFREGISTRATIONTYPEGOAL.MINFUNDRAISING as MINFUNDRAISINGGOAL,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERFUNDRAISING,
FAFREGISTRATIONTYPEGOAL.TARGETFUNDRAISING,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERTARGETFUNDRAISING,
FAFREGISTRATIONTYPEGOAL.RECRUITEMENT,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERRECRUITEMENT,
FAFREGISTRATIONTYPEGOAL.COMMUNICATIONS,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERCOMMUNICATION,
FAFREGISTRATIONTYPEGOAL.VOLUNTEERRECRUITEMENT,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERVOLUNTEERRECRUITEMENT,
FAFREGISTRATIONTYPEGOAL.UNIT,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERUNIT,
FAFREGISTRATIONTYPEGOAL.LABELFORUNIT,
FAFREGISTRATIONTYPEGOAL.TEAMMEMBERS,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERTEAMMEMBERS,
FAFREGISTRATIONTYPEGOAL.TEAMMEMBERRETENTION,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERTEAMMEMBERRETENTION,
FAFREGISTRATIONTYPEGOAL.TEAMS,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERTEAMS,
FAFREGISTRATIONTYPEGOAL.TEAMRETENTION,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERTEAMRETENTION,
FAFREGISTRATIONTYPEGOAL.DONORRETENTION,
FAFREGISTRATIONTYPEGOAL.ISNOTLOWERDONORRETENTION,
FAFREGISTRATIONTYPEGOAL.PARTICIPANTMUSTPAYBALANCE,
FAFREGISTRATIONTYPEGOAL.PARTICIPANTPAYSBALANCEMESSAGE
from
dbo.EVENTPRICE
left outer join dbo.FAFREGISTRATIONTYPEGOAL ON FAFREGISTRATIONTYPEGOAL.EVENTPRICEID = EVENTPRICE.ID
where EVENTPRICE.EVENTID = @EVENTID
and EVENTPRICE.ID = ISNULL(@EVENTPRICEID,EVENTPRICE.ID)
order by EVENTPRICE.AMOUNT, EVENTPRICE.NAME