USP_DATAFORMTEMPLATE_ADD_PLANNEDGIFTADDITIONASSET_PRELOAD

The load procedure used by the edit dataform template "Planned Gift Addition Asset Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTADDITIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTLOOKUPID	nvarchar(36)	INOUT
@CONSTITUENTFIRSTNAME	nvarchar(50)	INOUT
@CONSTITUENTKEYNAME	nvarchar(100)	INOUT
@CONSTITUENTID	uniqueidentifier	INOUT
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency ID

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PLANNEDGIFTADDITIONASSET_PRELOAD (
  @PLANNEDGIFTADDITIONID uniqueidentifier,
  @CONSTITUENTLOOKUPID nvarchar(36) = null output,
  @CONSTITUENTFIRSTNAME nvarchar(50) = null output,
  @CONSTITUENTKEYNAME nvarchar(100) = null output,
  @CONSTITUENTID uniqueidentifier = null output,
  @TRANSACTIONCURRENCYID uniqueidentifier = null output
) as
  set nocount on;

  select
    @CONSTITUENTLOOKUPID = CONSTITUENT.LOOKUPID,
    @CONSTITUENTFIRSTNAME = CONSTITUENT.FIRSTNAME,
    @CONSTITUENTKEYNAME = CONSTITUENT.KEYNAME,
    @CONSTITUENTID = CONSTITUENT.ID,
    @TRANSACTIONCURRENCYID = PLANNEDGIFTADDITION.TRANSACTIONCURRENCYID
  from
    dbo.PLANNEDGIFTADDITION
    inner join dbo.PLANNEDGIFT on PLANNEDGIFTADDITION.PLANNEDGIFTID = PLANNEDGIFT.ID
    inner join dbo.CONSTITUENT on CONSTITUENT.ID = PLANNEDGIFT.CONSTITUENTID
  where
    PLANNEDGIFTADDITION.ID = @PLANNEDGIFTADDITIONID;

  return 0;