USP_DATAFORMTEMPLATE_VIEW_EVENTGOAL

The load procedure used by the view dataform template "Event Goal 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.
@EVENTID	uniqueidentifier	INOUT	Event
@REVENUETOTAL	money	INOUT	Total
@REVENUEMONTHLY	money	INOUT	Monthly
@REVENUEWEEKLY	money	INOUT	Weekly
@REVENUEDAILY	money	INOUT	Daily
@REVENUESPONSOR	money	INOUT	Sponsors
@REVENUECOMPANY	money	INOUT	Companies
@REVENUETEAM	money	INOUT	Teams
@REVENUEINDIVIDUAL	money	INOUT	Individual participants
@RECRUITMENTSPONSOR	int	INOUT	Sponsors
@RECRUITMENTCOMPANY	int	INOUT	Companies
@RECRUITMENTTEAM	int	INOUT	Teams
@RECRUITMENTINDIVIDUAL	int	INOUT	Individual participants
@COMMUNICATIONTOTAL	int	INOUT	Total
@COMMUNICATIONMONTHLY	int	INOUT	Monthly
@COMMUNICATIONWEEKLY	int	INOUT	Weekly
@COMMUNICATIONDAILY	int	INOUT	Daily
@COMMUNICATIONSPONSOR	int	INOUT	Sponsors
@COMMUNICATIONCOMPANY	int	INOUT	Companies
@COMMUNICATIONTEAM	int	INOUT	Teams
@COMMUNICATIONINDIVIDUAL	int	INOUT	Individual participants
@RECRUITMENTDONOR	int	INOUT	Donors
@RECRUITMENTFUNDRAISINGCOACHES	int	INOUT	Fundraising coaches
@RECRUITMENTFITNESSCOACHES	int	INOUT	Fitness coaches
@REVENUERETENTION	decimal(6, 3)	INOUT	Percentage of total revenue to retain
@REVENUESPONSORRETENTION	decimal(6, 3)	INOUT	Percentage of sponsor revenue to retain
@REVENUECOMPANYRETENTION	decimal(6, 3)	INOUT	Percentage of company revenue to retain
@REVENUEINDIVIDUALRETENTION	decimal(6, 3)	INOUT	Percentage of individual participant revenue to retain
@REVENUETEAMRETENTION	decimal(6, 3)	INOUT	Percentage of team revenue to retain
@RECRUITMENTFUNDRAISINGCOACHRETENTION	decimal(6, 3)	INOUT	Percentage of fundraising coaches to retain
@RECRUITMENTFITNESSCOACHRETENTION	decimal(6, 3)	INOUT	Percentage of fitness coaches to retain
@RECRUITMENTSPONSORRETENTION	decimal(6, 3)	INOUT	Percentage of sponsors to retain
@RECRUITMENTCOMPANYRETENTION	decimal(6, 3)	INOUT	Percentage of companies to retain
@RECRUITMENTDONORRETENTION	decimal(6, 3)	INOUT	Percentage of donors to retain
@RECRUITMENTTEAMRETENTION	decimal(6, 3)	INOUT	Percentage of teams to retain
@RECRUITMENTINDIVIDUALRETENTION	decimal(6, 3)	INOUT	Percentage of individual participants to retain
@REVENUEHOUSEHOLD	money	INOUT	Households
@RECRUITMENTHOUSEHOLD	int	INOUT	Households
@COMMUNICATIONHOUSEHOLD	int	INOUT	Households
@REVENUEHOUSEHOLDRETENTION	decimal(6, 3)	INOUT	Percentage of households revenue to retain
@RECRUITMENTHOUSEHOLDRETENTION	decimal(6, 3)	INOUT	Percentage of households to retain
@REVENUEREGISTRATION	money	INOUT	Registration
@REVENUEREGISTRATIONRETENTION	decimal(6, 3)	INOUT	Percentage of registration revenue to retain
@ISACTIVE	bit	INOUT	ISACTIVE

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTGOAL 
(
    @ID uniqueidentifier ,
    @DATALOADED bit = 0 output,
    @EVENTID uniqueidentifier = null output,
--    @TEAMFUNDRAISINGTEAMID uniqueidentifier = null output,
--    @REGISTRANTID uniqueidentifier = null output,
--    @FAFGOALTYPEID uniqueidentifier = null output,
    @REVENUETOTAL money = null output,
    @REVENUEMONTHLY money = null output,
    @REVENUEWEEKLY money = null output,
    @REVENUEDAILY money = null output,
    @REVENUESPONSOR money = null output,
    @REVENUECOMPANY money = null output,
    @REVENUETEAM money = null output,
    @REVENUEINDIVIDUAL money = null output,
    --@RECRUITMENTTOTAL int = null output,
    --@RECRUITMENTMONTHLY int = null output,
   -- @RECRUITMENTWEEKLY int = null output,
   -- @RECRUITMENTDAILY int = null output,
    @RECRUITMENTSPONSOR int = null output,
    @RECRUITMENTCOMPANY int = null output,
    @RECRUITMENTTEAM int = null output,
    @RECRUITMENTINDIVIDUAL int = null output,
    @COMMUNICATIONTOTAL int = null output,
    @COMMUNICATIONMONTHLY int = null output,
    @COMMUNICATIONWEEKLY int = null output,
    @COMMUNICATIONDAILY int = null output,
    @COMMUNICATIONSPONSOR int = null output,
    @COMMUNICATIONCOMPANY int = null output,
    @COMMUNICATIONTEAM int = null output,
    @COMMUNICATIONINDIVIDUAL int = null output,
    @RECRUITMENTDONOR int = null output,
    @RECRUITMENTFUNDRAISINGCOACHES int = null output,
    @RECRUITMENTFITNESSCOACHES int = null output,
    @REVENUERETENTION decimal(6,3) = null output,
    @REVENUESPONSORRETENTION decimal(6,3) = null output,
    @REVENUECOMPANYRETENTION decimal(6,3) = null output,
    @REVENUEINDIVIDUALRETENTION decimal(6,3) = null output,
    @REVENUETEAMRETENTION decimal(6,3) = null output,    
    @RECRUITMENTFUNDRAISINGCOACHRETENTION decimal(6,3) = null output,
    @RECRUITMENTFITNESSCOACHRETENTION decimal(6,3) = null output,
    @RECRUITMENTSPONSORRETENTION decimal(6,3) = null output,
    @RECRUITMENTCOMPANYRETENTION decimal(6,3) = null output,
    @RECRUITMENTDONORRETENTION decimal(6,3) = null output,
    @RECRUITMENTTEAMRETENTION decimal(6,3) = null output,
    @RECRUITMENTINDIVIDUALRETENTION decimal(6,3) = null output,
    @REVENUEHOUSEHOLD money = null output,
    @RECRUITMENTHOUSEHOLD int = null output,
    @COMMUNICATIONHOUSEHOLD int = null output,
    @REVENUEHOUSEHOLDRETENTION decimal(6,3) = null output,
    @RECRUITMENTHOUSEHOLDRETENTION decimal(6,3) = null output ,
    @REVENUEREGISTRATION money = null output,  
    @REVENUEREGISTRATIONRETENTION decimal(6,3) = null output,
    @ISACTIVE bit= 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,
          -- @ID = EVENTID, 
        --    @TEAMFUNDRAISINGTEAMID = TEAMFUNDRAISINGTEAMID, 
        --    @REGISTRANTID = REGISTRANTID, 
        --    @FAFGOALTYPEID = FAFGOALTYPEID, 
           @REVENUETOTAL = REVENUETOTAL, 
           @REVENUEMONTHLY = REVENUEMONTHLY, 
           @REVENUEWEEKLY = REVENUEWEEKLY, 
           @REVENUEDAILY = REVENUEDAILY, 
           @REVENUESPONSOR = REVENUESPONSOR, 
           @REVENUECOMPANY = REVENUECOMPANY, 
           @REVENUETEAM = REVENUETEAM, 
           @REVENUEINDIVIDUAL = REVENUEINDIVIDUAL, 
           --@RECRUITMENTTOTAL = RECRUITMENTTOTAL, 
           --@RECRUITMENTMONTHLY = RECRUITMENTMONTHLY, 
          -- @RECRUITMENTWEEKLY = RECRUITMENTWEEKLY, 
          -- @RECRUITMENTDAILY = RECRUITMENTDAILY,
           @RECRUITMENTSPONSOR = RECRUITMENTSPONSOR, 
           @RECRUITMENTCOMPANY = RECRUITMENTCOMPANY, 
           @RECRUITMENTTEAM = RECRUITMENTTEAM, 
           @RECRUITMENTINDIVIDUAL = RECRUITMENTINDIVIDUAL, 
           @COMMUNICATIONTOTAL = COMMUNICATIONTOTAL, 
           @COMMUNICATIONMONTHLY = COMMUNICATIONMONTHLY, 
           @COMMUNICATIONWEEKLY = COMMUNICATIONWEEKLY, 
           @COMMUNICATIONDAILY = COMMUNICATIONDAILY, 
           @COMMUNICATIONSPONSOR = COMMUNICATIONSPONSOR, 
           @COMMUNICATIONCOMPANY = COMMUNICATIONCOMPANY, 
           @COMMUNICATIONTEAM = COMMUNICATIONTEAM, 
           @COMMUNICATIONINDIVIDUAL = COMMUNICATIONINDIVIDUAL,
          @RECRUITMENTDONOR = RECRUITMENTDONOR,
          @RECRUITMENTFUNDRAISINGCOACHES = RECRUITMENTFUNDRAISINGCOACHES,
          @RECRUITMENTFITNESSCOACHES = RECRUITMENTFITNESSCOACHES,
          @REVENUERETENTION = REVENUERETENTION*100,
          @REVENUESPONSORRETENTION  = REVENUESPONSORRETENTION*100,
          @REVENUECOMPANYRETENTION  = REVENUECOMPANYRETENTION*100,    
          @REVENUEINDIVIDUALRETENTION  = REVENUEINDIVIDUALRETENTION*100,
          @REVENUETEAMRETENTION  = REVENUETEAMRETENTION*100,      
          @RECRUITMENTFUNDRAISINGCOACHRETENTION  = RECRUITMENTFUNDRAISINGCOACHRETENTION*100,
          @RECRUITMENTFITNESSCOACHRETENTION = RECRUITMENTFITNESSCOACHRETENTION*100,
          @RECRUITMENTSPONSORRETENTION = RECRUITMENTSPONSORRETENTION*100,    
          @RECRUITMENTCOMPANYRETENTION = RECRUITMENTCOMPANYRETENTION*100,
          @RECRUITMENTDONORRETENTION  = RECRUITMENTDONORRETENTION*100,
          @RECRUITMENTTEAMRETENTION  = RECRUITMENTTEAMRETENTION*100,
          @RECRUITMENTINDIVIDUALRETENTION  = RECRUITMENTINDIVIDUALRETENTION*100,
          @REVENUEHOUSEHOLD = REVENUEHOUSEHOLD,
          @RECRUITMENTHOUSEHOLD = RECRUITMENTHOUSEHOLD,
          @COMMUNICATIONHOUSEHOLD= COMMUNICATIONHOUSEHOLD,
          @REVENUEHOUSEHOLDRETENTION = REVENUEHOUSEHOLDRETENTION*100,
          @RECRUITMENTHOUSEHOLDRETENTION = RECRUITMENTHOUSEHOLDRETENTION*100 ,
          @REVENUEREGISTRATION = REVENUEREGISTRATION,  
          @REVENUEREGISTRATIONRETENTION = REVENUEREGISTRATIONRETENTION*100,
           @ISACTIVE = EG.ISACTIVE 

    from dbo.EVENTGOAL EG (NOLOCK)
    left join dbo.EVENT E (NOLOCK)ON EG.EVENTID = E.ID
    where E.ID = @ID

    return 0;