USP_DATAFORMTEMPLATE_PRELOAD_ADD_DONORCHALLENGEDESIGNATIONMAP

The load procedure used by the edit dataform template "Donor Challenge Designation Map Add Form"

Parameters

Parameter Parameter Type Mode Description
@DONORCHALLENGEID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@TYPECODE tinyint INOUT Donor challenge type code

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_DONORCHALLENGEDESIGNATIONMAP
(
  @DONORCHALLENGEID uniqueidentifier,
  @TYPECODE tinyint = null output
)
as
begin
  set nocount on;

  select
    @TYPECODE = TYPECODE
  from
    dbo.DONORCHALLENGE
  where
    ID = @DONORCHALLENGEID;

  return 0;
end