USP_DATAFORMTEMPLATE_VIEW_DONORCHALLENGE

The load procedure used by the view dataform template "Donor Challenge 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.
@NAME	nvarchar(100)	INOUT	Challenge name
@STARTDATE	datetime	INOUT	Start date
@ENDDATE	datetime	INOUT	End date
@TOTALFUNDS	money	INOUT	Total funds
@MATCHTHRESHOLD	money	INOUT	Match threshold
@ENCUMBEREDFUNDS	money	INOUT	Encumbered funds
@MATCHEDFUNDS	money	INOUT	Matched funds
@REMAININGFUNDS	money	INOUT	Remaining funds
@TYPECODE	tinyint	INOUT	Type code
@STATUSTYPE	nvarchar(100)	INOUT	Status
@PROCESSLASTRUN	datetime	INOUT	Last updated
@TYPE	nvarchar(100)	INOUT	Type
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DONORCHALLENGE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @NAME nvarchar(100) = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output,
    @TOTALFUNDS money = null output,
    @MATCHTHRESHOLD money = null output,
    @ENCUMBEREDFUNDS money = null output,
    @MATCHEDFUNDS money = null output,
    @REMAININGFUNDS money = null output,
    @TYPECODE tinyint = null output,
    @STATUSTYPE nvarchar(100) = null output,
    @PROCESSLASTRUN datetime = null output,
    @TYPE nvarchar(100) = null output,
    @BASECURRENCYID uniqueidentifier = null output
)
as
begin
    set nocount on;

    set @DATALOADED = 0;

  set @ENCUMBEREDFUNDS = dbo.UFN_DONORCHALLENGE_ENCUMBEREDAMOUNT(@ID);

    set @MATCHEDFUNDS = dbo.UFN_DONORCHALLENGE_MATCHEDAMOUNT(@ID);

    select 
        @DATALOADED = 1,
        @NAME = NAME,
        @STARTDATE = STARTDATE,
        @ENDDATE = ENDDATE,
        @TOTALFUNDS = TOTALFUNDS,
    @MATCHTHRESHOLD = MATCHTHRESHOLD,
        @ENCUMBEREDFUNDS = @ENCUMBEREDFUNDS,
        @MATCHEDFUNDS = @MATCHEDFUNDS,
        @REMAININGFUNDS = dbo.UFN_DONORCHALLENGE_GETREMAININGFUNDS(@ID),
    @TYPECODE = TYPECODE,
    @STATUSTYPE = STATUSTYPE,
    @PROCESSLASTRUN = PROCESSLASTRUN,
    @TYPE = TYPE,
    @BASECURRENCYID = DONORCHALLENGE.BASECURRENCYID
    from 
        dbo.DONORCHALLENGE
    where
        ID = @ID;

    return 0
end