USP_DATAFORMTEMPLATE_ADD_PRELOAD_STEWARDSHIPPLANSTEP

The load procedure used by the edit dataform template "Stewardship Plan Step Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@STEWARDSHIPPLANID	uniqueidentifier	INOUT	Plan ID
@STEPOWNERNAME	nvarchar(154)	INOUT	Constituent name

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_STEWARDSHIPPLANSTEP
(
    @PLANID uniqueidentifier,
    @STEWARDSHIPPLANID uniqueidentifier = null output,
    @STEPOWNERNAME nvarchar(154) = null output    
) as begin
    set nocount on;

    set @STEWARDSHIPPLANID = @PLANID;

    select 
        @STEPOWNERNAME = NF_OWNER.NAME
    from 
        STEWARDSHIPPLAN
    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(STEWARDSHIPPLAN.CONSTITUENTID) NF_OWNER
    where
        STEWARDSHIPPLAN.ID = @PLANID;

        return 0;

end