USP_DATAFORMTEMPLATE_VIEW_CONSITUENTHISTORYEXPANDEDVIEW

The load procedure used by the view dataform template "Constituent Revenue History Expanded Revenue View"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CAMPAIGNS	nvarchar(max)	INOUT	Campaigns
@APPEAL	nvarchar(100)	INOUT	Appeal
@REVENUECATEGORIES	nvarchar(max)	INOUT	Revenue categories
@NAMINGOPPORTUNITIES	nvarchar(max)	INOUT	Naming opportunities
@TRIBUTES	nvarchar(max)	INOUT	Tributes
@GIVENANONYMOUSLY	bit	INOUT	Anonymous
@ACKNOWLEDGEMENTDATE	datetime	INOUT	Last Acknowledgement date
@SITES	nvarchar(max)	INOUT	Sites
@OPPORTUNITYCOUNT	int	INOUT	OPPORTUNITYCOUNT
@OPPORTUNITYID	uniqueidentifier	INOUT	OPPORTUNITYID
@OPPORTUNITYNAME	nvarchar(300)	INOUT	OPPORTUNITYNAME
@OPPORTUNITYDATE	datetime	INOUT	OPPORTUNITYDATE
@OPPORTUNITYAMOUNT	money	INOUT	OPPORTUNITYAMOUNT
@APPBASECURRENCY	uniqueidentifier	INOUT	APPBASECURRENCY

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSITUENTHISTORYEXPANDEDVIEW
                (
                    @ID uniqueidentifier,    
                    @CURRENTAPPUSERID uniqueidentifier = null,    
                    @DATALOADED bit = 0 output,
                    @CAMPAIGNS nvarchar(max) = null output,
                    @APPEAL nvarchar(100) = null output,
                    @REVENUECATEGORIES nvarchar(max) = null output,
                    @NAMINGOPPORTUNITIES nvarchar(max) = null output,
                    @TRIBUTES nvarchar(max) = null output,
                    @GIVENANONYMOUSLY bit = null output,
                    @ACKNOWLEDGEMENTDATE datetime = null output,
                    @SITES nvarchar(max) = null output,
                    @OPPORTUNITYCOUNT integer = null output,
                    @OPPORTUNITYID uniqueidentifier = null output,
                    @OPPORTUNITYNAME nvarchar(300) = null output,
                    @OPPORTUNITYDATE datetime = null output,
                    @OPPORTUNITYAMOUNT money = null output,
                    @APPBASECURRENCY uniqueidentifier = null output
                )
                as
                set nocount on;

                exec dbo.USP_CONSITUENTREVENUEHISTORYEXPANDEDVIEW_GET
                    @ID = @ID,
                    @CURRENTAPPUSERID = @CURRENTAPPUSERID,
                    @DATALOADED = @DATALOADED output,
                    @CAMPAIGNS = @CAMPAIGNS output,
                    @APPEAL = @APPEAL output,
                    @REVENUECATEGORIES = @REVENUECATEGORIES output,
                    @NAMINGOPPORTUNITIES = @NAMINGOPPORTUNITIES output,
                    @TRIBUTES = @TRIBUTES output,
                    @GIVENANONYMOUSLY = @GIVENANONYMOUSLY output,
                    @ACKNOWLEDGEMENTDATE = @ACKNOWLEDGEMENTDATE output,
                    @SITES = @SITES output,
                    @OPPORTUNITYCOUNT = @OPPORTUNITYCOUNT output,
                    @OPPORTUNITYID = @OPPORTUNITYID output,
                    @OPPORTUNITYNAME = @OPPORTUNITYNAME output,
                    @OPPORTUNITYDATE = @OPPORTUNITYDATE output,
                    @OPPORTUNITYAMOUNT = @OPPORTUNITYAMOUNT output,
                    @APPBASECURRENCY = @APPBASECURRENCY output

                return 0;