USP_DATAFORMTEMPLATE_EDITLOAD_GIVINGSUMMARYBATCHTEMPLATE

The load procedure used by the edit dataform template "Giving Summary Update Batch Template Edit 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.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@LOOKUP_ID	nvarchar(100)	INOUT	Constituent/Lookup ID
@KEYNAME	nvarchar(100)	INOUT	Last/org/group/household name
@FIRSTNAME	nvarchar(50)	INOUT	First name
@FIRSTGIFTAMOUNT	money	INOUT	First gift amount
@FIRSTGIFTDATE	datetime	INOUT	First gift date
@FIRSTGIFTDESIGNATION	nvarchar(100)	INOUT	First gift designation
@FIRSTGIFTTYPE	nvarchar(100)	INOUT	First gift type
@LARGESTGIFTAMOUNT	money	INOUT	Largest gift amount
@LARGESTGIFTDATE	datetime	INOUT	Largest gift date
@LARGESTGIFTDESIGNATION	nvarchar(100)	INOUT	Largest gift designation
@LARGESTGIFTTYPE	nvarchar(100)	INOUT	Largest gift type
@LATESTGIFTAMOUNT	money	INOUT	Latest gift amount
@LATESTGIFTDATE	datetime	INOUT	Latest gift date
@LATESTGIFTDESIGNATION	nvarchar(100)	INOUT	Latest gift designation
@LATESTGIFTTYPE	nvarchar(100)	INOUT	Latest gift type
@TOTALGIFTAMOUNT	money	INOUT	Total giving
@TOTALGIFTSGIVEN	int	INOUT	Total number of gifts

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GIVINGSUMMARYBATCHTEMPLATE(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @LOOKUP_ID nvarchar(100) = null output,
    @KEYNAME nvarchar(100) = null output,
    @FIRSTNAME nvarchar(50) = null output,
    @FIRSTGIFTAMOUNT money = null output,
    @FIRSTGIFTDATE datetime = null output,
    @FIRSTGIFTDESIGNATION nvarchar(100) = null output,
    @FIRSTGIFTTYPE nvarchar(100) = null output,
    @LARGESTGIFTAMOUNT money = null output,
    @LARGESTGIFTDATE datetime = null output,
    @LARGESTGIFTDESIGNATION nvarchar(100) = null output,
    @LARGESTGIFTTYPE nvarchar(100) = null output,
    @LATESTGIFTAMOUNT money = null output,
    @LATESTGIFTDATE datetime = null output,
    @LATESTGIFTDESIGNATION nvarchar(100) = null output,
    @LATESTGIFTTYPE nvarchar(100) = null output,
    @TOTALGIFTAMOUNT money = null output,
    @TOTALGIFTSGIVEN int = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows

    set @DATALOADED = 0
    set @TSLONG = 0

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.  Also note that we fetch the TSLONG so that concurrency

    -- can be considered.

    select
        @TSLONG = GS.TSLONG,
        @FIRSTGIFTAMOUNT = GS.FIRSTGIFTAMOUNT,
        @FIRSTGIFTDATE = GS.FIRSTGIFTDATE,
        @FIRSTGIFTDESIGNATION = GS.FIRSTGIFTDESIGNATION,
        @FIRSTGIFTTYPE = GS.FIRSTGIFTTYPE,
        @LARGESTGIFTAMOUNT = GS.LARGESTGIFTAMOUNT,
        @LARGESTGIFTDATE = GS.LARGESTGIFTDATE,
        @LARGESTGIFTDESIGNATION = GS.LARGESTGIFTDESIGNATION,
        @LARGESTGIFTTYPE = GS.LARGESTGIFTTYPE,
        @LATESTGIFTAMOUNT = GS.LATESTGIFTAMOUNT,
        @LATESTGIFTDATE = GS.LATESTGIFTDATE,
        @LATESTGIFTDESIGNATION = GS.LATESTGIFTDESIGNATION,
        @LATESTGIFTTYPE = GS.LATESTGIFTTYPE,
        @TOTALGIFTAMOUNT = GS.TOTALGIFTAMOUNT,
        @TOTALGIFTSGIVEN = GS.TOTALGIFTSGIVEN 
    from
        dbo.RE7INTEGRATIONGIVINGSUMMARY GS
    where 
        GS.ID = @ID

    select
        @DATALOADED = 1,
        @LOOKUP_ID = C.LOOKUPID,
        @KEYNAME = C.KEYNAME,
        @FIRSTNAME = C.FIRSTNAME
    from
        dbo.CONSTITUENT C
    where
        C.ID = @ID

    return 0;