USP_DATAFORMTEMPLATE_VIEW_PAYMENTPLANNEDGIFT

The load procedure used by the view dataform template "Payment: Planned Gift View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TRANSACTIONTYPE	nvarchar(20)	INOUT	Transaction type
@CONSTITUENTNAME	nvarchar(700)	INOUT	Constituent
@DESCRIPTION	nvarchar(700)	INOUT	Description
@GIFTDATE	datetime	INOUT	Date
@VEHICLE	nvarchar(150)	INOUT	Vehicle
@GIFTAMOUNT	money	INOUT	Gift amount
@BALANCE	money	INOUT	Total due
@TOTALPAID	money	INOUT	Total paid
@DESIGNATIONS	nvarchar(3000)	INOUT	Designations
@ANONYMOUS	bit	INOUT	ANONYMOUS
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency ID
@ISADDITION	bit	INOUT	Is addition

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PAYMENTPLANNEDGIFT
(
  @ID uniqueidentifier,    
  @DATALOADED bit = 0 output,
  @TRANSACTIONTYPE nvarchar(20) = null output,
  @CONSTITUENTNAME nvarchar(700) = null output,
  @DESCRIPTION nvarchar(700) = null output,
  @GIFTDATE datetime = null output,
  @VEHICLE nvarchar(150) = null output,
  @GIFTAMOUNT money = null output,
  @BALANCE money = null output,
  @TOTALPAID money = null output,
  @DESIGNATIONS nvarchar(3000) = null output,
  @ANONYMOUS bit = null output,
  @TRANSACTIONCURRENCYID uniqueidentifier = null output,
  @ISADDITION bit = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @TRANSACTIONTYPE = REVENUE.TRANSACTIONTYPE,
    @CONSTITUENTNAME = NF.NAME,
    @GIFTDATE = REVENUE.DATE,
    @VEHICLE = PLANNEDGIFT.VEHICLE,
    @GIFTAMOUNT = REVENUE.TRANSACTIONAMOUNT,
    @BALANCE = dbo.UFN_PLEDGE_GETBALANCE(REVENUE.ID),
    @TOTALPAID = dbo.UFN_PLEDGE_GETAMOUNTPAID(REVENUE.ID),
    @DESIGNATIONS = dbo.UFN_REVENUE_DESIGNATIONLIST(REVENUE.ID),
    @ANONYMOUS = REVENUE.GIVENANONYMOUSLY,
    @TRANSACTIONCURRENCYID = REVENUE.TRANSACTIONCURRENCYID,
    @ISADDITION = PLANNEDGIFTREVENUE.ISADDITION
  from
    dbo.REVENUE
  cross apply
    dbo.UFN_CONSTITUENT_DISPLAYNAME(REVENUE.CONSTITUENTID) NF
  inner join
    dbo.V_PLANNEDGIFTREVENUE_WITHADDITIONS PLANNEDGIFTREVENUE on PLANNEDGIFTREVENUE.REVENUEID = REVENUE.ID
  inner join
    dbo.PLANNEDGIFT on PLANNEDGIFT.ID = PLANNEDGIFTREVENUE.PLANNEDGIFTID
  where
    REVENUE.ID = @ID;

  set @DESCRIPTION = @CONSTITUENTNAME;