USP_DATAFORMTEMPLATE_VIEW_REGISTRATIONDEFAULTGOALS

The load procedure used by the view dataform template "FAF Registration Default Goals View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@MINFUNDRAISING	money	INOUT	Minimum fundraising goal
@TARGETFUNDRAISING	money	INOUT	Target fundraising goal
@RECRUITEMENT	int	INOUT	Number of participants to recruit
@DONORRETENTION	decimal(6, 3)	INOUT	Percentage of donors to retain
@COMMUNICATIONS	int	INOUT	Number of communications to send
@TEAMMINFUNDRAISING	money	INOUT	Team: Fundraising total amount
@TEAMMEMBERS	int	INOUT	Team: Number of team members
@TEAMMEMBERRETENTION	decimal(6, 3)	INOUT	Team: Percentage of team members to retain
@TEAMCOMMUNICATIONS	int	INOUT	Team: Number of communications to send
@TEAMRECRUITEMENT	int	INOUT	Team: Number of participants to recruit
@COMPANYMINFUNDRAISING	money	INOUT	Company: Fundraising total amount
@TEAMS	int	INOUT	Company: Number of teams
@TEAMRETENTION	decimal(6, 3)	INOUT	Company: Percentage of teams to retain
@COMPANYTEAMMEMBERS	int	INOUT	Company: Number of team members
@COMPANYTEAMMEMBERRETENTION	decimal(6, 3)	INOUT	Company: Percentage of team members to retain
@COMPANYRECRUITEMENT	int	INOUT	Company: Number of participants to recruit
@COMPANYCOMMUNICATIONS	int	INOUT	Company: Number of communications to send
@HOUSEHOLDMINFUNDRAISING	money	INOUT	Household: Minimum fundraising goal
@HOUSEHOLDTARGETFUNDRAISING	money	INOUT	Household: Target fundraising goal
@HOUSEHOLDRECRUITEMENT	int	INOUT	Household: Number of participants to recruit
@HOUSEHOLDDONORRETENTION	decimal(6, 3)	INOUT	Household: Percentage of donors to retain
@HOUSEHOLDCOMMUNICATIONS	int	INOUT	Household: Number of communications to send
@HOUSEHOLDMEMBERS	int	INOUT	Household: Number of household members
@HOUSEHOLDMEMBERRETENTION	decimal(6, 3)	INOUT	Household: Percentage of household members to retain

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REGISTRATIONDEFAULTGOALS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,

  @MINFUNDRAISING money = null output ,
  @TARGETFUNDRAISING money = null output ,
  @RECRUITEMENT int = null output,
  @DONORRETENTION decimal(6,3) = null output,
  @COMMUNICATIONS int = null output,

  @TEAMMINFUNDRAISING money = null output ,
  @TEAMMEMBERS int = null output,
  @TEAMMEMBERRETENTION decimal(6,3) = null output,
  @TEAMCOMMUNICATIONS int = null output,
  @TEAMRECRUITEMENT int = null output,

  @COMPANYMINFUNDRAISING money = null output ,
  @TEAMS int = null output,
  @TEAMRETENTION decimal(6,3) = null output,
  @COMPANYTEAMMEMBERS int = null output,
  @COMPANYTEAMMEMBERRETENTION decimal(6,3) = null output,
  @COMPANYRECRUITEMENT int = null output,
  @COMPANYCOMMUNICATIONS int = null output,

  @HOUSEHOLDMINFUNDRAISING money = null output ,
  @HOUSEHOLDTARGETFUNDRAISING money = null output ,
  @HOUSEHOLDRECRUITEMENT int = null output,
  @HOUSEHOLDDONORRETENTION decimal(6,3) = null output,
  @HOUSEHOLDCOMMUNICATIONS int = null output,
  @HOUSEHOLDMEMBERS int = null output,
  @HOUSEHOLDMEMBERRETENTION decimal(6,3) = null output

)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.

    select @DATALOADED = 1,
    @MINFUNDRAISING=FRTG0.MINFUNDRAISING,
    @TARGETFUNDRAISING=FRTG0.TARGETFUNDRAISING,
    @RECRUITEMENT=FRTG0.RECRUITEMENT,
    @DONORRETENTION=FRTG0.DONORRETENTION * 100,
    @COMMUNICATIONS=FRTG0.COMMUNICATIONS,

    @TEAMMINFUNDRAISING=FRTG1.MINFUNDRAISING,
    @TEAMMEMBERS=FRTG1.TEAMMEMBERS,
    @TEAMMEMBERRETENTION=FRTG1.TEAMMEMBERRETENTION * 100,
    @TEAMCOMMUNICATIONS=FRTG1.COMMUNICATIONS,
    @TEAMRECRUITEMENT=FRTG1.RECRUITEMENT,

    @COMPANYMINFUNDRAISING=FRTG2.MINFUNDRAISING,
    @TEAMS=FRTG2.TEAMS,
    @TEAMRETENTION=FRTG2.TEAMRETENTION * 100,
    @COMPANYTEAMMEMBERS=FRTG2.TEAMMEMBERS,
    @COMPANYTEAMMEMBERRETENTION=FRTG2.TEAMMEMBERRETENTION * 100,
    @COMPANYRECRUITEMENT=FRTG2.RECRUITEMENT,
    @COMPANYCOMMUNICATIONS=FRTG2.COMMUNICATIONS,

    @HOUSEHOLDMINFUNDRAISING=FRTG3.MINFUNDRAISING,
    @HOUSEHOLDTARGETFUNDRAISING=FRTG3.TARGETFUNDRAISING,
    @HOUSEHOLDRECRUITEMENT=FRTG3.RECRUITEMENT,
    @HOUSEHOLDDONORRETENTION=FRTG3.DONORRETENTION * 100,
    @HOUSEHOLDCOMMUNICATIONS=FRTG3.COMMUNICATIONS,
    @HOUSEHOLDMEMBERS=FRTG3.TEAMMEMBERS,
    @HOUSEHOLDMEMBERRETENTION=FRTG3.TEAMMEMBERRETENTION * 100

    from dbo.EVENTPRICE EP (NOLOCK)
    left join dbo.FAFREGISTRATIONTYPE FRT (NOLOCK)ON FRT.EVENTPRICEID = EP.ID
    left join dbo.FAFREGISTRATIONTYPEGOAL FRTG0 (NOLOCK) ON FRTG0.EVENTPRICEID = FRT.EVENTPRICEID AND FRTG0.REGTYPEGOALCODE =0
    left join dbo.FAFREGISTRATIONTYPEGOAL FRTG1 (NOLOCK) ON FRTG1.EVENTPRICEID = FRT.EVENTPRICEID AND FRTG1.REGTYPEGOALCODE =1
    left join dbo.FAFREGISTRATIONTYPEGOAL FRTG2 (NOLOCK) ON FRTG2.EVENTPRICEID = FRT.EVENTPRICEID AND FRTG2.REGTYPEGOALCODE =2
    left join dbo.FAFREGISTRATIONTYPEGOAL FRTG3 (NOLOCK) ON FRTG3.EVENTPRICEID = FRT.EVENTPRICEID AND FRTG3.REGTYPEGOALCODE =3

  where EP.ID = @ID

    return 0;