USP_DATAFORMTEMPLATE_VIEW_xxx

The load procedure used by the view dataform template "Lifecycle Major Donor Summary 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.
@USEMAJORDONORSINGLEGIFT	bit	INOUT	USEMAJORDONORSINGLEGIFT
@MAJORDONORSINGLEGIFTAMOUNT	money	INOUT	MAJORDONORSINGLEGIFTAMOUNT
@USEMAJORDONORLIFETIMEGIVING	bit	INOUT	USEMAJORDONORLIFETIMEGIVING
@MAJORDONORLIFETIMEGIVINGAMOUNT	money	INOUT	MAJORDONORLIFETIMEGIVINGAMOUNT
@INCLUDEMAJORDONORPROSPECTS	bit	INOUT	INCLUDEMAJORDONORPROSPECTS
@PLANNEDGIFTMUSTHAVEPAYMENTS	bit	INOUT	PLANNEDGIFTMUSTHAVEPAYMENTS

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_xxx
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @USEMAJORDONORSINGLEGIFT bit = null output,
    @MAJORDONORSINGLEGIFTAMOUNT money = null output,
    @USEMAJORDONORLIFETIMEGIVING bit = null output,
    @MAJORDONORLIFETIMEGIVINGAMOUNT money = null output,
    @INCLUDEMAJORDONORPROSPECTS bit = null output,
    @PLANNEDGIFTMUSTHAVEPAYMENTS bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
       @DATALOADED = 1,
       @USEMAJORDONORSINGLEGIFT = USEMAJORDONORSINGLEGIFT,
       @MAJORDONORSINGLEGIFTAMOUNT = MAJORDONORSINGLEGIFTAMOUNT,
       @USEMAJORDONORLIFETIMEGIVING = USEMAJORDONORLIFETIMEGIVING,
       @MAJORDONORLIFETIMEGIVINGAMOUNT = MAJORDONORLIFETIMEGIVINGAMOUNT,
       @INCLUDEMAJORDONORPROSPECTS = INCLUDEMAJORDONORPROSPECTS,
       @PLANNEDGIFTMUSTHAVEPAYMENTS = PLANNEDGIFTMUSTHAVEPAYMENTS
    from 
        dbo.REVENUELIFECYCLECRITERIA
    where 
        ID = @ID

    return 0;