UFN_FAFEVENT_GETEVENTGOAL

Get FAF event goal.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
Definition

Copy


CREATE function dbo.UFN_FAFEVENT_GETEVENTGOAL(@EVENTID uniqueidentifier)
returns table
  as return
    select
      '00000000-0000-0000-0000-000000000000' as ID, 
      EG.REVENUETOTAL,
      EG.REVENUEMONTHLY,
      EG.REVENUEWEEKLY,
      EG.REVENUEDAILY,
      EG.REVENUESPONSOR,
      EG.REVENUECOMPANY,
      EG.REVENUETEAM,
      EG.REVENUEINDIVIDUAL,
      EG.RECRUITMENTTOTAL,
      EG.RECRUITMENTMONTHLY,
      EG.RECRUITMENTWEEKLY,
      EG.RECRUITMENTDAILY,
      EG.RECRUITMENTSPONSOR,
      EG.RECRUITMENTCOMPANY,
      EG.RECRUITMENTTEAM,
      EG.RECRUITMENTINDIVIDUAL,
      EG.COMMUNICATIONTOTAL,
      EG.COMMUNICATIONMONTHLY,
      EG.COMMUNICATIONWEEKLY,
      EG.COMMUNICATIONDAILY,
      EG.COMMUNICATIONSPONSOR,
      EG.COMMUNICATIONCOMPANY,
      EG.COMMUNICATIONTEAM,
      EG.COMMUNICATIONINDIVIDUAL,
      EG.ISACTIVE,
      EG.MINIMIMUMFUNDRAISINGGOAL,
      EG.MINIMIMUMPARTICIPANTGOAL,
      EG.MINIMIMUMTEAMMEMBERGOAL,
      EG.MINIMIMUMDONORGOAL,
      EG.MINIMIMUMNEWMEMBERGOAL,
      EG.MINIMIMUMNEWDONORGOAL,
      EG.MINIMUMFUNDRAISEGOALPERMEMBER,
      EG.RECRUITMENTFUNDRAISINGCOACHES,
      EG.RECRUITMENTFITNESSCOACHES,
      EG.RECRUITMENTDONOR,
      REVENUERETENTION,     
      REVENUESPONSORRETENTION,
      REVENUECOMPANYRETENTION,
      REVENUETEAMRETENTION,
      REVENUEINDIVIDUALRETENTION,
      RECRUITMENTFUNDRAISINGCOACHRETENTION,
      RECRUITMENTFITNESSCOACHRETENTION,
      RECRUITMENTSPONSORRETENTION,
      RECRUITMENTCOMPANYRETENTION,
      RECRUITMENTDONORRETENTION,
      RECRUITMENTTEAMRETENTION,
      RECRUITMENTINDIVIDUALRETENTION,
      EG.REVENUEHOUSEHOLD,
      EG.RECRUITMENTHOUSEHOLD,
      EG.COMMUNICATIONHOUSEHOLD,
      EG.REVENUEHOUSEHOLDRETENTION,
      EG.RECRUITMENTHOUSEHOLDRETENTION,
      EG.ID as COPYSOURCEID, 
      @EVENTID as COPYBATCHGUID,
      REVENUEREGISTRATION,
      REVENUEREGISTRATIONRETENTION
    from 
      dbo.EVENTGOAL EG
    join 
      dbo.EVENTEXTENSION EX on EG.EVENTID = EX.EVENTID
    where
      EG.EVENTID = @EVENTID