USP_DATAFORMTEMPLATE_EDIT_ASSIGNLETTERCODESPROCESS_2

Backwards compatibility procedure for USP_DATAFORMTEMPLATE_EDIT_ASSIGNLETTERCODESPROCESS_3.

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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@LETTERCODES	xml	IN
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing Selection
@ASSIGNALLLETTERCODES	bit	IN	Assign all letters
@USEDATEFILTER	bit	IN	Only consider revenue or recognition credit added since last run
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN	Selection type
@INCLUDEDONORASACKNOWLEDGEE	bit	IN	Include donor
@INCLUDERECOGNITIONRECIPIENTSASACKNOWLEDGEE	bit	IN	Include recognition recipients

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ASSIGNLETTERCODESPROCESS_2
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @NAME nvarchar(100), 
                @DESCRIPTION nvarchar(255),
                @IDSETREGISTERID uniqueidentifier,
                @LETTERCODES xml,
                @CREATEOUTPUTIDSET bit,
                @OUTPUTIDSETNAME nvarchar(100), 
                @OVERWRITEOUTPUTIDSET bit,
                @ASSIGNALLLETTERCODES bit,
                @USEDATEFILTER bit,
                @OUTPUTIDSETRECORDTYPEID uniqueidentifier,
                @INCLUDEDONORASACKNOWLEDGEE bit,
                @INCLUDERECOGNITIONRECIPIENTSASACKNOWLEDGEE bit
            )
            as
            set nocount on;

            declare @SITEID uniqueidentifier = null;
            declare @CURRENTAPPUSERID uniqueidentifier = null;

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ASSIGNLETTERCODESPROCESS_2
                @ID = @ID,
                @SITEID = @SITEID output;

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_ASSIGNLETTERCODESPROCESS_3
                @ID,
                @CHANGEAGENTID,
                @NAME,
                @DESCRIPTION,
                @IDSETREGISTERID,
                @LETTERCODES,
                @CREATEOUTPUTIDSET,
                @OUTPUTIDSETNAME,
                @OVERWRITEOUTPUTIDSET,
                @ASSIGNALLLETTERCODES,
                @USEDATEFILTER,
                @OUTPUTIDSETRECORDTYPEID,
                @INCLUDEDONORASACKNOWLEDGEE,
                @INCLUDERECOGNITIONRECIPIENTSASACKNOWLEDGEE,
                @CURRENTAPPUSERID,
                @SITEID;