USP_DATAFORMTEMPLATE_VIEW_DONORCHALLENGEDETAIL

The load procedure used by the view dataform template "Donor Challenge 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.
@NAME	nvarchar(100)	INOUT	Challenge name
@SPONSOR	nvarchar(700)	INOUT	Challenge sponsor
@STARTDATE	datetime	INOUT	Start date
@ENDDATE	datetime	INOUT	End date
@PAYPLEDGES	nvarchar(100)	INOUT	Pay pledges within
@TOTALFUNDS	money	INOUT	Total funds
@MATCHINGFACTOR	decimal(5, 2)	INOUT	Matching factor
@MATCHTHRESHOLD	money	INOUT	Match threshold
@TYPECODE	tinyint	INOUT	Type
@MATCHTYPE	nvarchar(100)	INOUT	Matching portion
@MINGIFTAMOUNT	money	INOUT	Min gift amount
@MAXMATCHPERGIFT	money	INOUT	Max match per gift
@DESCRIPTION	nvarchar(255)	INOUT	Description
@EXCLUDEDAPPLICATIONTYPES	nvarchar(100)	INOUT	Excluded application types
@SITE	nvarchar(1024)	INOUT	Site
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DONORCHALLENGEDETAIL
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @NAME nvarchar(100) = null output,
    @SPONSOR nvarchar(700) = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output,
    @PAYPLEDGES nvarchar(100) = null output,
    @TOTALFUNDS money = null output,
    @MATCHINGFACTOR decimal(5,2) = null output,
    @MATCHTHRESHOLD money = null output,
    @TYPECODE tinyint = null output,
    @MATCHTYPE nvarchar(100) = null output,
    @MINGIFTAMOUNT money = null output,
    @MAXMATCHPERGIFT money = null output,
    @DESCRIPTION nvarchar(255) = null output,
    @EXCLUDEDAPPLICATIONTYPES nvarchar(100) = null output,
    @SITE nvarchar(1024) = null output,
    @BASECURRENCYID uniqueidentifier = null output
)
as
begin
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @NAME = NAME,
        @SPONSOR = case
            when EXTERNALSPONSORID is null then
                dbo.UFN_DONORCHALLENGESPONSORCODE_GETDESCRIPTION(INTERNALSPONSORCODEID)
            else
                (select NAME from dbo.UFN_CONSTITUENT_DISPLAYNAME(EXTERNALSPONSORID))
            end,
        @STARTDATE = STARTDATE,
        @ENDDATE = ENDDATE,
        @PAYPLEDGES = convert(nvarchar(3), PAYPLEDGESWITHIN) + ' ' + lower(PAYPLEDGESWITHINUNIT),
        @TOTALFUNDS = TOTALFUNDS,
        @MATCHINGFACTOR = MATCHINGFACTOR,
        @MATCHTHRESHOLD = MATCHTHRESHOLD,
        @TYPECODE = TYPECODE,
        @MATCHTYPE = MATCHTYPE,
        @MINGIFTAMOUNT = MINGIFTAMOUNT,
        @MAXMATCHPERGIFT = MAXMATCHPERGIFT,
        @DESCRIPTION = [DESCRIPTION],
        @EXCLUDEDAPPLICATIONTYPES = (select dbo.uda_buildlist(APPLICATION) from dbo.DONORCHALLENGEEXCLUDEDAPPLICATIONTYPE where DONORCHALLENGEID = @ID),
        @SITE = (select SITE.[NAME] from dbo.SITE where SITE.ID = DONORCHALLENGE.SITEID),
        @BASECURRENCYID = DONORCHALLENGE.BASECURRENCYID
    from 
        dbo.DONORCHALLENGE
    where
        ID = @ID;

    return 0
end