USP_DATAFORMTEMPLATE_ADD_APPEALNOTE_PRELOAD

The load procedure used by the edit dataform template "Appeal Note Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@AUTHORID	uniqueidentifier	INOUT	Author
@APPEALID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONTEXTTYPE	smallint	INOUT	Context type

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_APPEALNOTE_PRELOAD
(
  @CURRENTAPPUSERID uniqueidentifier,
  @AUTHORID uniqueidentifier = null output,
  @APPEALID uniqueidentifier,
  @CONTEXTTYPE smallint = null output
)
as
  set nocount on;

  set @CONTEXTTYPE = 4; --appeal                        


  select top 1
    @AUTHORID = CONSTITUENTID
  from
    dbo.APPUSER
  where
    ID = @CURRENTAPPUSERID;

  return 0;