USP_DATAFORMTEMPLATE_VIEW_WEALTHCAPACITYFORMULAFORCONSTITUENT

The load procedure used by the view dataform template "Wealth Capacity Formula For Constituent View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nchar	IN	The input ID parameter used to load the fields defined on the form.
@ESTIMATEDWEALTHVALUE	money	INOUT	Estimated wealth value
@ESTIMATEDWEALTHID	uniqueidentifier	INOUT	Estimated wealth
@MAJORGIVINGCAPACITYVALUE	money	INOUT	Major giving capacity value
@MAJORGIVINGCAPACITYID	uniqueidentifier	INOUT	Major giving capacity
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@MAJORGIVINGCAPACITYBASISVALUE	nvarchar(250)	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WEALTHCAPACITYFORMULAFORCONSTITUENT (
                    @ID nchar(72),
                    @ESTIMATEDWEALTHVALUE money = null output,
                    @ESTIMATEDWEALTHID uniqueidentifier = null output,
                    @MAJORGIVINGCAPACITYVALUE money = null output,
                    @MAJORGIVINGCAPACITYID uniqueidentifier = null output,
                    @DATALOADED bit = 0 output,
                    @MAJORGIVINGCAPACITYBASISVALUE nvarchar(250) = null output
                ) as
                    set nocount on;

                    declare @WEALTHID uniqueidentifier;
                    declare @WEALTHCAPACITYFORMULAID uniqueidentifier;

                    set @WEALTHID = convert(uniqueidentifier, substring(@ID,1,36));
                    set @WEALTHCAPACITYFORMULAID = convert(uniqueidentifier, substring(@ID,37,36));
                    set @MAJORGIVINGCAPACITYBASISVALUE = '';

                    begin try
                        exec dbo.USP_CONSTITUENT_WEALTHCAPACITY_FROMFORMULA_2
                            @WEALTHID,
                            @WEALTHCAPACITYFORMULAID,
                            @ESTIMATEDWEALTHVALUE output,
                            @ESTIMATEDWEALTHID output,
                            @MAJORGIVINGCAPACITYVALUE output,
                            @MAJORGIVINGCAPACITYID output,
                            @MAJORGIVINGCAPACITYBASISVALUE output;
                    end try
                    begin catch
                        set @ESTIMATEDWEALTHVALUE = 0;
                        set @ESTIMATEDWEALTHID = null;
                        set @MAJORGIVINGCAPACITYVALUE = 0;
                        set @MAJORGIVINGCAPACITYID = null;
                    end catch

                    set @DATALOADED = 1;

                    return 0;