USP_DATAFORMTEMPLATE_EDIT_MATCHINGGIFTPREFERENCE

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@AUTOCREATEMGFROMMGRELATIONS	tinyint	IN	Auto-create matching gift claim from matching gift relationships
@AUTOCREATEMGFROMSPOUSEMGRELATIONS	tinyint	IN	Auto-create matching gift claim from spouse matching gift relationships
@MATCHINGGIFTCONDITIONTYPECODEID	uniqueidentifier	IN	Default matching gift condition type
@SPOUSEMATCHINGGIFTCONDITIONTYPECODEID	uniqueidentifier	IN	Default matching gift condition type
@ADDRECOGNITIONCREDITSONMGCLAIMADD	tinyint	IN	Add recognition credit for donor to matched revenue when a matching gift claim is added to revenue
@ADDRECOGNITIONCREDITSONMGPAYMENTAPPLY	tinyint	IN	Add recognition credit for donor of matched revenue when applying a payment to a matching gift claim
@CLAIMREVENUERECOGNITIONTYPECODEID	uniqueidentifier	IN	Default recognition credit type
@PAYMENTREVENUERECOGNITIONTYPECODEID	uniqueidentifier	IN	Default recognition credit type
@MGCLAIMADDRECOGNITIONTYPECODE	tinyint	IN	Claim recognition type
@MGPAYMENTAPPLYRECOGNITIONTYPECODE	tinyint	IN	Payment recognition type

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_MATCHINGGIFTPREFERENCE
(
    @CHANGEAGENTID uniqueidentifier = null,
    @AUTOCREATEMGFROMMGRELATIONS tinyint,
    @AUTOCREATEMGFROMSPOUSEMGRELATIONS tinyint,
    @MATCHINGGIFTCONDITIONTYPECODEID uniqueidentifier,
    @SPOUSEMATCHINGGIFTCONDITIONTYPECODEID uniqueidentifier,
    @ADDRECOGNITIONCREDITSONMGCLAIMADD tinyint,
    @ADDRECOGNITIONCREDITSONMGPAYMENTAPPLY tinyint,
    @CLAIMREVENUERECOGNITIONTYPECODEID uniqueidentifier,
    @PAYMENTREVENUERECOGNITIONTYPECODEID uniqueidentifier,
    @MGCLAIMADDRECOGNITIONTYPECODE tinyint,
    @MGPAYMENTAPPLYRECOGNITIONTYPECODE tinyint
)

as
  set nocount on;

    declare @ADDRECOGNITIONCREDITSTOMATCHINGORGONMGCLAIMADD bit;
    declare @ADDRECOGNITIONCREDITSTOMATCHINGORGONMGPAYMENTAPPLY bit;
    declare @MATCHINGORGCLAIMREVENUERECOGNITIONTYPECODEID uniqueidentifier;
    declare @MATCHINGORGPAYMENTREVENUERECOGNITIONTYPECODEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MATCHINGGIFTPREFERENCE
        @ADDRECOGNITIONCREDITSTOMATCHINGORGONMGCLAIMADD = @ADDRECOGNITIONCREDITSTOMATCHINGORGONMGCLAIMADD output,
        @ADDRECOGNITIONCREDITSTOMATCHINGORGONMGPAYMENTAPPLY = @ADDRECOGNITIONCREDITSTOMATCHINGORGONMGPAYMENTAPPLY output,
        @MATCHINGORGCLAIMREVENUERECOGNITIONTYPECODEID = @MATCHINGORGCLAIMREVENUERECOGNITIONTYPECODEID output,
        @MATCHINGORGPAYMENTREVENUERECOGNITIONTYPECODEID = @MATCHINGORGPAYMENTREVENUERECOGNITIONTYPECODEID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_MATCHINGGIFTPREFERENCE_2
        @CHANGEAGENTID,
        @AUTOCREATEMGFROMMGRELATIONS,
        @AUTOCREATEMGFROMSPOUSEMGRELATIONS,
        @MATCHINGGIFTCONDITIONTYPECODEID,
        @SPOUSEMATCHINGGIFTCONDITIONTYPECODEID,
        @ADDRECOGNITIONCREDITSONMGCLAIMADD,
        @ADDRECOGNITIONCREDITSONMGPAYMENTAPPLY,
        @CLAIMREVENUERECOGNITIONTYPECODEID,
        @PAYMENTREVENUERECOGNITIONTYPECODEID,
        @MGCLAIMADDRECOGNITIONTYPECODE,
        @MGPAYMENTAPPLYRECOGNITIONTYPECODE,
        @ADDRECOGNITIONCREDITSTOMATCHINGORGONMGCLAIMADD,
        @ADDRECOGNITIONCREDITSTOMATCHINGORGONMGPAYMENTAPPLY,
        @MATCHINGORGCLAIMREVENUERECOGNITIONTYPECODEID,
        @MATCHINGORGPAYMENTREVENUERECOGNITIONTYPECODEID

  return 0;