USP_DATAFORMTEMPLATE_VIEW_COMMUNICATIONLETTERACTIVITYEXCLUSIONS

The load procedure used by the view dataform template "Communication Exclusions View"

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.
@EXCLUDEBASEDONRECENTCOMMUNICATION	bit	INOUT	Exclude constituents included in communications within the past:
@NUMRECENTCOMMUNICATIONPERIODS	int	INOUT	NUMRECENTCOMMUNICATIONPERIODS
@RECENTCOMMUNICATIONPERIODTYPE	nvarchar(10)	INOUT	RECENTCOMMUNICATIONPERIODTYPE
@EXCLUDEBASEDONTOTALCOMMUNICATIONSINPASTYEAR	bit	INOUT	Exclude constituents included in at least the following number of communications in the past year:
@NUMTOTALCOMMUNICATIONSINPASTYEAR	int	INOUT	Number of communications
@EXCLUDEBASEDONRECENTGIVING	bit	INOUT	Exclude constituents with revenue in the past:
@NUMRECENTGIVINGPERIODS	int	INOUT	NUMRECENTGIVINGPERIODS
@RECENTGIVINGPERIODTYPE	nvarchar(10)	INOUT	RECENTGIVINGPERIODTYPE
@EXCLUDEBASEDONTOTALGIVINGINPASTYEAR	bit	INOUT	Exclude constituents with at least the following total revenue amount in the past year:
@TOTALREVENUEAMOUNTINPASTYEAR	money	INOUT	Total revenue amount
@COMMUNICATIONTYPES	xml	INOUT	COMMUNICATIONTYPES

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_COMMUNICATIONLETTERACTIVITYEXCLUSIONS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @EXCLUDEBASEDONRECENTCOMMUNICATION bit = null output,
    @NUMRECENTCOMMUNICATIONPERIODS int = null output,
    @RECENTCOMMUNICATIONPERIODTYPE nvarchar(10) = null output,
    @EXCLUDEBASEDONTOTALCOMMUNICATIONSINPASTYEAR bit = null output,
    @NUMTOTALCOMMUNICATIONSINPASTYEAR int = null output,
    @EXCLUDEBASEDONRECENTGIVING bit = null output,
    @NUMRECENTGIVINGPERIODS int = null output,
    @RECENTGIVINGPERIODTYPE nvarchar(10)  = null output,
    @EXCLUDEBASEDONTOTALGIVINGINPASTYEAR bit = null output,
    @TOTALREVENUEAMOUNTINPASTYEAR money = null output,
    @COMMUNICATIONTYPES xml = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select @DATALOADED = 1,
           @EXCLUDEBASEDONRECENTCOMMUNICATION = EXCLUDEBASEDONRECENTCOMMUNICATION,
           @NUMRECENTCOMMUNICATIONPERIODS = NUMRECENTCOMMUNICATIONPERIODS,
           @RECENTCOMMUNICATIONPERIODTYPE = RECENTCOMMUNICATIONPERIODTYPE,
           @EXCLUDEBASEDONTOTALCOMMUNICATIONSINPASTYEAR = EXCLUDEBASEDONTOTALCOMMUNICATIONSINPASTYEAR,
           @NUMTOTALCOMMUNICATIONSINPASTYEAR = NUMTOTALCOMMUNICATIONSINPASTYEAR,
           @EXCLUDEBASEDONRECENTGIVING = EXCLUDEBASEDONRECENTGIVING,
           @NUMRECENTGIVINGPERIODS = NUMRECENTGIVINGPERIODS,
           @RECENTGIVINGPERIODTYPE = RECENTGIVINGPERIODTYPE,
           @EXCLUDEBASEDONTOTALGIVINGINPASTYEAR = EXCLUDEBASEDONTOTALGIVINGINPASTYEAR,
           @TOTALREVENUEAMOUNTINPASTYEAR = TOTALREVENUEAMOUNTINPASTYEAR,
           @COMMUNICATIONTYPES = dbo.UFN_COMMUNICATIONLETTERACTIVITYEXCLUSION_GETCOMMUNICATIONTYPES_TOITEMLISTXML(ID)
    from dbo.COMMUNICATIONLETTERACTIVITYEXCLUSIONS
    where ID = @ID;

    return 0;