USP_DATAFORMTEMPLATE_ADD_STEWARDSHIPPLANASSIGNMENTPROCESS_PRELOAD

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

Parameters

Parameter Parameter Type Mode Description
@RECORDTYPEID uniqueidentifier INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STEWARDSHIPPLANASSIGNMENTPROCESS_PRELOAD
(
  @RECORDTYPEID uniqueidentifier = null output
)
as
  set nocount on;

  select @RECORDTYPEID = ID
  from dbo.RECORDTYPE 
  where NAME = 'Stewardship Plan';

  return 0;