USP_DATAFORMTEMPLATE_EDIT_REGISTRANTEXTENSION

Backwards compatibility spec for USP_DATAFORMTEMPLATE_EDIT_REGISTRANTEXTENSION_2

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@REGISTRANTID	uniqueidentifier	IN	Registrant
@FUNDRAISINGGOAL	money	IN	Fundraisinggoal
@ADVOCACYACTIONGOAL	int	IN	Advocacyactiongoal
@MEMBERECRUITMENTGOAL	int	IN	Memberecruitmentgoal
@COMMUNICATIONGOAL	int	IN	Communicationgoal
@VOLUNTEERRECRUITMENTGOAL	int	IN	Volunteerrecruitmentgoal
@TARGETFUNDRAISINGGOAL	money	IN	TargetFundraisingGoal
@DONORRETENTIONGOAL	decimal(5, 2)	IN	DonorRetentionGoal
@OTHERUNITGOAL	int	IN	OtherUnitGoal
@ISPRIVATE	bit	IN	IsPrivate
@ALLOWADMINACCESSHQ	bit	IN	AllowAdminAccessHQ

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTEXTENSION
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @REGISTRANTID uniqueidentifier,
    @FUNDRAISINGGOAL money,
    @ADVOCACYACTIONGOAL int,
    @MEMBERECRUITMENTGOAL int,
    @COMMUNICATIONGOAL int,
    @VOLUNTEERRECRUITMENTGOAL int,
    @TARGETFUNDRAISINGGOAL money,
    @DONORRETENTIONGOAL decimal(5,2),
    @OTHERUNITGOAL int,
    @ISPRIVATE bit,
    @ALLOWADMINACCESSHQ bit
)
as 
set nocount on;

declare @ISDASHBOARDHELPERVISIBLE bit = null;
declare @ALLOWOTHERPARTICIPANTSCONTACTME bit = null;

exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTEXTENSION
    @ID = @ID,
    @ISDASHBOARDHELPERVISIBLE = @ISDASHBOARDHELPERVISIBLE output,
  @ALLOWOTHERPARTICIPANTSCONTACTME = @ALLOWOTHERPARTICIPANTSCONTACTME output;

exec dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTEXTENSION_2
  @ID = @ID,
    @CHANGEAGENTID = @CHANGEAGENTID,
    @REGISTRANTID = @REGISTRANTID,
  @FUNDRAISINGGOAL = @FUNDRAISINGGOAL,
  @ADVOCACYACTIONGOAL = @ADVOCACYACTIONGOAL,
  @MEMBERECRUITMENTGOAL = @MEMBERECRUITMENTGOAL,
  @COMMUNICATIONGOAL = @COMMUNICATIONGOAL,
  @VOLUNTEERRECRUITMENTGOAL = @VOLUNTEERRECRUITMENTGOAL,
  @TARGETFUNDRAISINGGOAL = @TARGETFUNDRAISINGGOAL,
  @DONORRETENTIONGOAL = @DONORRETENTIONGOAL,
  @OTHERUNITGOAL = @OTHERUNITGOAL,
  @ISPRIVATE = @ISPRIVATE,
  @ALLOWADMINACCESSHQ = @ALLOWADMINACCESSHQ,
  @ISDASHBOARDHELPERVISIBLE = @ISDASHBOARDHELPERVISIBLE,
  @ALLOWOTHERPARTICIPANTSCONTACTME = @ALLOWOTHERPARTICIPANTSCONTACTME;

return 0;