USP_DATAFORMTEMPLATE_VIEW_NAMINGOPPORTUNITY

The load procedure used by the view dataform template "Naming Opportunity Summary Profile 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.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(250)	INOUT	Description
@TYPE	nvarchar(100)	INOUT	Type
@CONTACT	nvarchar(700)	INOUT	Contact
@PURPOSE	nvarchar(100)	INOUT	Purpose
@QUANTITY	int	INOUT	Quantity
@REMAINING	int	INOUT	Remaining
@AMOUNT	money	INOUT	Minimum gift amount
@SITE	nvarchar(100)	INOUT	Site
@AREA	nvarchar(100)	INOUT	Area
@UNIT	nvarchar(100)	INOUT	Unit
@FACILITY	nvarchar(100)	INOUT	Facility
@CAMPAIGN	nvarchar(100)	INOUT	Campaign
@CAMPAIGNID	uniqueidentifier	INOUT	Campaign ID
@ISACTIVE	bit	INOUT	Status
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_NAMINGOPPORTUNITY
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @DESCRIPTION nvarchar(250) = null output,
                    @TYPE nvarchar(100) = null output,
                    @CONTACT nvarchar(700) = null output,
                    @PURPOSE nvarchar(100) = null output,
                    @QUANTITY int = null output,
                    @REMAINING int = null output,
                    @AMOUNT money = null output,
                    @SITE nvarchar(100) = null output,
                    @AREA nvarchar(100) = null output,
                    @UNIT nvarchar(100) = null output,
                    @FACILITY nvarchar(100) = null output,
                    @CAMPAIGN nvarchar(100) = null output,
                    @CAMPAIGNID uniqueidentifier = null output,
                    @ISACTIVE bit = null output,
                    @BASECURRENCYID uniqueidentifier = null output
                )
                as
                    set nocount on;
                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @NAME = NAMINGOPPORTUNITY.NAME,
                        @DESCRIPTION = NAMINGOPPORTUNITY.DESCRIPTION,
                        @TYPE = dbo.UFN_NAMINGOPPORTUNITYTYPECODE_GETDESCRIPTION(NAMINGOPPORTUNITYTYPECODEID),
                        @CONTACT = NF.NAME,
                        @PURPOSE = DESIGNATIONLEVEL.NAME,
                        @QUANTITY = NAMINGOPPORTUNITY.QUANTITY,
                        @REMAINING = NAMINGOPPORTUNITY.REMAINING,
                        @AMOUNT = NAMINGOPPORTUNITY.MINIMUMAMOUNT,
                        @SITE = SITE.NAME,
                        @AREA = dbo.UFN_NAMINGOPPORTUNITYAREACODE_GETDESCRIPTION(NAMINGOPPORTUNITYFACILITY.AREACODEID),
                        @UNIT = dbo.UFN_NAMINGOPPORTUNITYUNITCODE_GETDESCRIPTION(NAMINGOPPORTUNITYFACILITY.UNITCODEID),
                        @FACILITY = NAMINGOPPORTUNITYFACILITY.NAME,
                        @CAMPAIGN = CAMPAIGN.NAME,
                        @CAMPAIGNID = CAMPAIGN.ID,
                        @ISACTIVE = NAMINGOPPORTUNITY.ISACTIVE,
                        @BASECURRENCYID = NAMINGOPPORTUNITY.BASECURRENCYID
                    from
                        dbo.NAMINGOPPORTUNITY
                        inner join dbo.DESIGNATIONLEVEL on DESIGNATIONLEVEL.ID = NAMINGOPPORTUNITY.PURPOSEID
                        left join dbo.SITE on SITE.ID = NAMINGOPPORTUNITY.SITEID
                        left join dbo.NAMINGOPPORTUNITYFACILITY on NAMINGOPPORTUNITYFACILITY.ID = NAMINGOPPORTUNITY.FACILITYID
                        left join dbo.CAMPAIGN on CAMPAIGN.ID = NAMINGOPPORTUNITY.CAMPAIGNID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(NAMINGOPPORTUNITY.CONTACTID) NF
                    where
                        @ID = NAMINGOPPORTUNITY.ID