USP_DATAFORMTEMPLATE_VIEW_DONORCONSTITUENCYCRITERIA

The load procedure used by the view dataform template "Donor Constituency Criteria View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DONORCONSTITUENCYDEFTYPECODE	smallint	INOUT	Criteria
@DONORCONSTITUENCYDEFLASTYEARS	int	INOUT	Years
@DONORCONSTITUENCYDEFSTARTDATE	datetime	INOUT	Date
@LOYALDONORCONSTITUENCYDEFPERIOD	int	INOUT	A Loyal donor constituent has given within
@LOYALDONORCONSTITUENCYDEFPERIODUNITCODE	smallint	INOUT	consecutive
@MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT	money	INOUT	Has lifetime giving greater than or equal to
@MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT	money	INOUT	Has a largest donation greater than or equal to
@MAJORDONORCONSTITUENCYDEFCONSIDERRECOGNITION	bit	INOUT	Consider recognition credits in donor constituency definitions
@DONORCURRENCYID	uniqueidentifier	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DONORCONSTITUENCYCRITERIA
(
  @DATALOADED bit = 0 output,
  @DONORCONSTITUENCYDEFTYPECODE smallint = null output,
  @DONORCONSTITUENCYDEFLASTYEARS int = null output,
  @DONORCONSTITUENCYDEFSTARTDATE datetime = null output,
  @LOYALDONORCONSTITUENCYDEFPERIOD int = null output,
  @LOYALDONORCONSTITUENCYDEFPERIODUNITCODE smallint = null output,
  @MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT money = null output,
  @MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT money = null output,
  @MAJORDONORCONSTITUENCYDEFCONSIDERRECOGNITION bit = null output,
  @DONORCURRENCYID uniqueidentifier = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select 
    @DATALOADED = 1,
    @DONORCONSTITUENCYDEFTYPECODE = DONORCONSTITUENCYDEFTYPECODE,
    @DONORCONSTITUENCYDEFLASTYEARS = DONORCONSTITUENCYDEFLASTYEARS,
    @DONORCONSTITUENCYDEFSTARTDATE = DONORCONSTITUENCYDEFSTARTDATE
  from
    dbo.INSTALLATIONINFO;

  select top 1 
    @LOYALDONORCONSTITUENCYDEFPERIOD = LOYALDONORCONSTITUENCYDEFPERIOD,
    @LOYALDONORCONSTITUENCYDEFPERIODUNITCODE = LOYALDONORCONSTITUENCYDEFPERIODUNITCODE,
    @MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT = MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT,
    @MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT = MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT,
    @MAJORDONORCONSTITUENCYDEFCONSIDERRECOGNITION = MAJORDONORCONSTITUENCYDEFCONSIDERRECOGNITION
  from 
    dbo.CONSTITUENCYCRITERIASPOUSE

  set @DONORCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

  return 0;