USP_DATAFORMTEMPLATE_VIEW_DONORCHALLENGEREVENUE

The load procedure used by the view dataform template "Donor Challenge Revenue Detail 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.
@DONORCHALLENGEID	uniqueidentifier	INOUT	Donor challenge ID
@DONORCHALLENGENAME	nvarchar(100)	INOUT	Donor challenge
@APPLIEDID	uniqueidentifier	INOUT	Applied ID
@APPLIEDAMOUNT	money	INOUT	Applied amount
@APPLIEDTYPE	nvarchar(100)	INOUT	Applied type
@APPLIEDNAME	nvarchar(400)	INOUT	Applied name
@APPLIEDTRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Applied transaction currency ID

Definition

Copy


              CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DONORCHALLENGEREVENUE
              (
                  @ID uniqueidentifier,
                  @DATALOADED bit = 0 output,
                  @DONORCHALLENGEID uniqueidentifier = null output,
                  @DONORCHALLENGENAME nvarchar(100) = null output,
                  @APPLIEDID uniqueidentifier = null output,
                  @APPLIEDAMOUNT money = null output,
                  @APPLIEDTYPE nvarchar(100) = null output,
                  @APPLIEDNAME nvarchar(400) = null output,
                  @APPLIEDTRANSACTIONCURRENCYID uniqueidentifier = null output
              )
              as
                  set nocount on;

                  set @DATALOADED = 0;

                  declare @TYPECODE as int;

                  select 
                    @DATALOADED = 1,
                    @DONORCHALLENGEID = DONORCHALLENGE.ID,
                    @DONORCHALLENGENAME = DONORCHALLENGE.NAME,
                    @TYPECODE = DONORCHALLENGE.TYPECODE
                  from dbo.DONORCHALLENGE
                  inner join dbo.DONORCHALLENGEENCUMBERED on DONORCHALLENGEENCUMBERED.DONORCHALLENGEID = DONORCHALLENGE.ID
                    where DONORCHALLENGEENCUMBERED.MATCHEDREVENUEID = @ID or DONORCHALLENGE.LUMPSUMMATCHREVENUEID = @ID

                  if @TYPECODE = 0 --Match per gift
                    select 
                      @APPLIEDID = REVENUE.ID,
                      @APPLIEDAMOUNT  = REVENUE.TRANSACTIONAMOUNT,
                      @APPLIEDTYPE = REVENUE.TYPE,
                      @APPLIEDNAME = CONSTITUENT.NAME,
                      @APPLIEDTRANSACTIONCURRENCYID = REVENUE.TRANSACTIONCURRENCYID
                    from dbo.DONORCHALLENGEENCUMBERED
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM REVENUESPLIT on REVENUESPLIT.ID = DONORCHALLENGEENCUMBERED.REVENUESPLITID
                    inner join dbo.FINANCIALTRANSACTION REVENUE on REVENUESPLIT.FINANCIALTRANSACTIONID = REVENUE.ID
                    inner join dbo.CONSTITUENT on REVENUE.CONSTITUENTID = CONSTITUENT.ID
                    where DONORCHALLENGEENCUMBERED.MATCHEDREVENUEID = @ID

                  return 0;