USP_DATAFORMTEMPLATE_ADD_STEPCOMPLETED

The save procedure used by the add dataform template "Completed Step Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@EXPECTEDDATE	datetime	IN	Expected date
@ACTUALDATE	datetime	IN	Actual date
@STATUSCODE	tinyint	IN	Status
@FUNDRAISERID	uniqueidentifier	IN	Owner
@INTERACTIONTYPECODEID	uniqueidentifier	IN	Contact method
@OBJECTIVE	nvarchar(100)	IN	Objective
@PROSPECTPLANSTATUSCODEID	uniqueidentifier	IN	Plan stage
@COMMENT	nvarchar(max)	IN	Comment
@DOCUMENTATIONTYPE	int	IN	Documentation
@ADDITIONALFUNDRAISERS	xml	IN	Additional fundraisers

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STEPCOMPLETED
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @PROSPECTPLANID uniqueidentifier,
                        @EXPECTEDDATE datetime,
                        @ACTUALDATE datetime = null,
                        @STATUSCODE tinyint = 2,
                        @FUNDRAISERID uniqueidentifier = null,
                        @INTERACTIONTYPECODEID uniqueidentifier = null,
                        @OBJECTIVE nvarchar(100) = '',
                        @PROSPECTPLANSTATUSCODEID uniqueidentifier = null,
                        @COMMENT nvarchar(max) = '',
                        @DOCUMENTATIONTYPE int = null,
                        @ADDITIONALFUNDRAISERS xml = null
                    )
                    as begin
                        set nocount on;

                        exec dbo.USP_STEP_ADD @ID output, @CHANGEAGENTID, @PROSPECTPLANID, @EXPECTEDDATE, @ACTUALDATE, @STATUSCODE, @FUNDRAISERID, 
                            @INTERACTIONTYPECODEID, @OBJECTIVE, @PROSPECTPLANSTATUSCODEID, @COMMENT, @ADDITIONALFUNDRAISERS

                        return 0;
                    end