USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITYFORMULA_LOAD_2

The load procedure used by the edit dataform template "Wealth Capacity Formula Edit Form 2"

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.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@USERISOWNER	bit	INOUT
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@ISDEFAULT	bit	INOUT	Set this as the default formula
@ASSETCALCULATIONMETHODCODE	tinyint	INOUT	Asset calculation method
@MAJORGIVINGMULTIPLIERTYPECODE	tinyint	INOUT	Major giving multiplier
@MAJORGIVINGSETVALUEMULTIPLIER	decimal(20, 4)	INOUT	Set value
@MAJORGIVINGOVER70MULTIPLIER	decimal(20, 4)	INOUT	Over 70 years
@MAJORGIVING60TO69MULTIPLIER	decimal(20, 4)	INOUT	Between 60-69 years
@MAJORGIVING50TO59MULTIPLIER	decimal(20, 4)	INOUT	Between 50-59 years
@MAJORGIVING40TO49MULTIPLIER	decimal(20, 4)	INOUT	Between 40-49 years
@MAJORGIVINGUNDER40MULTIPLIER	decimal(20, 4)	INOUT	Less than 40 years
@MAJORGIVINGAGEUNKNOWNMULTIPLIER	decimal(20, 4)	INOUT	Age unknown
@REALESTATEINCLUDE	bit	INOUT	Real estate
@REALESTATECONFIRMEDONLY	bit	INOUT	Use confirmed records only
@REALESTATEVALUEMULTIPLIERTYPECODE	tinyint	INOUT	Real estate multiplier type
@REALESTATEVALUEMULTIPLIERCUTOFFVALUE	money	INOUT	If less than
@REALESTATEVALUEMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@REALESTATEVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@REALESTATEVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Otherwise multiply by
@REALESTATEAGGREGATETYPECODE	tinyint	INOUT	Real estate aggregate type
@REALESTATEUSEPROPERTYVALUATION	bit	INOUT	Property valuation
@REALESTATEUSEPROPERTYVALUEESTIMATE	bit	INOUT	Property value estimate
@REALESTATESOURCES	xml	INOUT	Data source(s) to include
@BUSINESSOWNERSHIPINCLUDE	bit	INOUT	Business ownership
@BUSINESSOWNERSHIPCONFIRMEDONLY	bit	INOUT	Use confirmed records only
@BUSINESSOWNERSHIPVALUEMULTIPLIERTYPECODE	tinyint	INOUT	Business ownership multiplier type
@BUSINESSOWNERSHIPVALUEMULTIPLIERCUTOFFVALUE	money	INOUT	If less than
@BUSINESSOWNERSHIPVALUEMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@BUSINESSOWNERSHIPVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@BUSINESSOWNERSHIPVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Otherwise multiply by
@BUSINESSOWNERSHIPVALUECODE	tinyint	INOUT	Value to use in calculation
@BUSINESSOWNERSHIPSOURCES	xml	INOUT	Data source(s) to include
@SECURITIESINCLUDE	bit	INOUT	Securities
@SECURITIESCONFIRMEDONLY	bit	INOUT	Use confirmed records only
@SECURITIESVALUEMULTIPLIERTYPECODE	tinyint	INOUT	Securities multiplier type
@SECURITIESVALUEMULTIPLIERCUTOFFVALUE	money	INOUT	If less than
@SECURITIESVALUEMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@SECURITIESVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@SECURITIESVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Otherwise multiply by
@SECURITIESVALUECODE	tinyint	INOUT	Value to use in calculation
@SECURITIESSOURCES	xml	INOUT	Data source(s) to include
@INCOMECOMPENSATIONINCLUDE	bit	INOUT	Income/compensation
@INCOMECOMPENSATIONCONFIRMEDONLY	bit	INOUT	Use confirmed records only
@INCOMECOMPENSATIONVALUEMULTIPLIERTYPECODE	tinyint	INOUT	Income/compensation multiplier type
@INCOMECOMPENSATIONVALUEMULTIPLIERCUTOFFVALUE	money	INOUT	If less than
@INCOMECOMPENSATIONVALUEMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@INCOMECOMPENSATIONVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@INCOMECOMPENSATIONVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Otherwise multiply by
@INCOMECOMPENSATIONINCLUDESALARY	bit	INOUT	Salary
@INCOMECOMPENSATIONINCLUDEBONUS	bit	INOUT	Bonus
@INCOMECOMPENSATIONINCLUDESHORTTERMCOMP	bit	INOUT	Other short term compensation
@INCOMECOMPENSATIONINCLUDELONGTERMCOMP	bit	INOUT	Other long term compensation
@INCOMECOMPENSATIONINCLUDEEXERCISEDOPTIONS	bit	INOUT	Exercised options
@INCOMECOMPENSATIONINCLUDEUNEXERCISEDOPTIONS	bit	INOUT	Unexercised options
@INCOMECOMPENSATIONINCLUDEUNEXERCISABLEOPTIONS	bit	INOUT	Unexercisable options
@INCOMECOMPENSATIONSOURCES	xml	INOUT	Data source(s) to include
@OTHERASSETINCLUDE	bit	INOUT	Other assets
@OTHERASSETCONFIRMEDONLY	bit	INOUT	Use confirmed records only
@OTHERASSETVALUEMULTIPLIERTYPECODE	tinyint	INOUT	Other asset multiplier type
@OTHERASSETVALUEMULTIPLIERCUTOFFVALUE	money	INOUT	If less than
@OTHERASSETVALUEMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@OTHERASSETVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@OTHERASSETVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Otherwise multiply by
@OTHERASSETVALUECODE	tinyint	INOUT	Value to use in calculation
@OTHERASSETSOURCES	xml	INOUT	Data source(s) to include
@NONPROFITAFFILIATIONINCLUDE	bit	INOUT	Nonprofit affiliations
@NONPROFITAFFILIATIONCONFIRMEDONLY	bit	INOUT	Use confirmed records only
@NONPROFITAFFILIATIONVALUEMULTIPLIERTYPECODE	tinyint	INOUT	Nonprofit affiliation multiplier type
@NONPROFITAFFILIATIONVALUEMULTIPLIERCUTOFFVALUE	money	INOUT	If less than
@NONPROFITAFFILIATIONVALUEMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@NONPROFITAFFILIATIONVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@NONPROFITAFFILIATIONVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Otherwise multiply by
@NONPROFITAFFILIATIONVALUECODE	tinyint	INOUT	Value to use in calculation
@NONPROFITAFFILIATIONSOURCES	xml	INOUT	Data source(s) to include
@PRIVATEFOUNDATIONINCLUDE	bit	INOUT	Private foundations
@PRIVATEFOUNDATIONCONFIRMEDONLY	bit	INOUT	Use confirmed records only
@PRIVATEFOUNDATIONVALUEMULTIPLIERTYPECODE	tinyint	INOUT	Private foundation multiplier type
@PRIVATEFOUNDATIONVALUEMULTIPLIERCUTOFFVALUE	money	INOUT	If less than
@PRIVATEFOUNDATIONVALUEMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@PRIVATEFOUNDATIONVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@PRIVATEFOUNDATIONVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Otherwise multiply by
@PRIVATEFOUNDATIONVALUECODE	tinyint	INOUT	Value to use in calculation
@PRIVATEFOUNDATIONSOURCES	xml	INOUT	Data source(s) to include
@OTHERSCANMODIFY	bit	INOUT	Other users may modify this formula
@REALESTATEINCLUDEHISTORICAL	bit	INOUT
@INCOMECOMPENSATIONINCLUDEHISTORICAL	bit	INOUT
@PHILANTHROPICGIFTINCLUDE	bit	INOUT
@PHILANTHROPICGIFTCONFIRMEDONLY	bit	INOUT
@PHILANTHROPICGIFTVALUEMULTIPLIERTYPECODE	tinyint	INOUT
@PHILANTHROPICGIFTVALUEMULTIPLIERCUTOFFVALUE	money	INOUT
@PHILANTHROPICGIFTVALUEMULTIPLIER	decimal(20, 4)	INOUT
@PHILANTHROPICGIFTVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT
@PHILANTHROPICGIFTVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT
@PHILANTHROPICGIFTVALUECODE	tinyint	INOUT
@PHILANTHROPICGIFTSOURCES	xml	INOUT
@POLITICALDONATIONINCLUDE	bit	INOUT
@POLITICALDONATIONCONFIRMEDONLY	bit	INOUT
@POLITICALDONATIONVALUEMULTIPLIERTYPECODE	tinyint	INOUT
@POLITICALDONATIONVALUEMULTIPLIERCUTOFFVALUE	money	INOUT
@POLITICALDONATIONVALUEMULTIPLIER	decimal(20, 4)	INOUT
@POLITICALDONATIONVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT
@POLITICALDONATIONVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT
@POLITICALDONATIONVALUECODE	tinyint	INOUT
@POLITICALDONATIONSOURCES	xml	INOUT
@GIVINGTOMYORGINCLUDE	bit	INOUT
@GIVINGTOMYORGVALUEMULTIPLIERTYPECODE	tinyint	INOUT
@GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE	money	INOUT
@GIVINGTOMYORGVALUEMULTIPLIER	decimal(20, 4)	INOUT
@GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT
@GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT
@GIVINGTOMYORGVALUECODE	tinyint	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITYFORMULA_LOAD_2 (
                        @ID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @USERISOWNER bit = null output,
                        @NAME nvarchar(100) = null output,
                        @DESCRIPTION nvarchar(255) = null output,
                        @ISDEFAULT bit = null output,

                        @ASSETCALCULATIONMETHODCODE tinyint = null output,
                        @MAJORGIVINGMULTIPLIERTYPECODE tinyint = null output,
                        @MAJORGIVINGSETVALUEMULTIPLIER decimal(20,4) = null output,
                        @MAJORGIVINGOVER70MULTIPLIER decimal(20,4) = null output,
                        @MAJORGIVING60TO69MULTIPLIER decimal(20,4) = null output,
                        @MAJORGIVING50TO59MULTIPLIER decimal(20,4) = null output,
                        @MAJORGIVING40TO49MULTIPLIER decimal(20,4) = null output,
                        @MAJORGIVINGUNDER40MULTIPLIER decimal(20,4) = null output,
                        @MAJORGIVINGAGEUNKNOWNMULTIPLIER decimal(20,4) = null output,

                        @REALESTATEINCLUDE bit = null output,
                        @REALESTATECONFIRMEDONLY bit = null output,
                        @REALESTATEVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @REALESTATEVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @REALESTATEVALUEMULTIPLIER decimal(20,4) = null output,
                        @REALESTATEVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @REALESTATEVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @REALESTATEAGGREGATETYPECODE tinyint = null output,
                        @REALESTATEUSEPROPERTYVALUATION bit = null output,
                        @REALESTATEUSEPROPERTYVALUEESTIMATE bit = null output,
                        @REALESTATESOURCES xml = null output,

                        @BUSINESSOWNERSHIPINCLUDE bit = null output,
                        @BUSINESSOWNERSHIPCONFIRMEDONLY bit = null output,
                        @BUSINESSOWNERSHIPVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @BUSINESSOWNERSHIPVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @BUSINESSOWNERSHIPVALUEMULTIPLIER decimal(20,4) = null output,
                        @BUSINESSOWNERSHIPVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @BUSINESSOWNERSHIPVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @BUSINESSOWNERSHIPVALUECODE tinyint = null output,
                        @BUSINESSOWNERSHIPSOURCES xml = null output,

                        @SECURITIESINCLUDE bit = null output,
                        @SECURITIESCONFIRMEDONLY bit = null output,
                        @SECURITIESVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @SECURITIESVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @SECURITIESVALUEMULTIPLIER decimal(20,4) = null output,
                        @SECURITIESVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @SECURITIESVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @SECURITIESVALUECODE tinyint = null output,
                        @SECURITIESSOURCES xml = null output,

                        @INCOMECOMPENSATIONINCLUDE bit = null output,
                        @INCOMECOMPENSATIONCONFIRMEDONLY bit = null output,
                        @INCOMECOMPENSATIONVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @INCOMECOMPENSATIONVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @INCOMECOMPENSATIONVALUEMULTIPLIER decimal(20,4) = null output,
                        @INCOMECOMPENSATIONVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @INCOMECOMPENSATIONVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @INCOMECOMPENSATIONINCLUDESALARY bit = null output,
                        @INCOMECOMPENSATIONINCLUDEBONUS bit = null output,
                        @INCOMECOMPENSATIONINCLUDESHORTTERMCOMP bit = null output,
                        @INCOMECOMPENSATIONINCLUDELONGTERMCOMP bit = null output,
                        @INCOMECOMPENSATIONINCLUDEEXERCISEDOPTIONS bit = null output,
                        @INCOMECOMPENSATIONINCLUDEUNEXERCISEDOPTIONS bit = null output,
                        @INCOMECOMPENSATIONINCLUDEUNEXERCISABLEOPTIONS bit = null output,
                        @INCOMECOMPENSATIONSOURCES xml = null output,

                        @OTHERASSETINCLUDE bit = null output,
                        @OTHERASSETCONFIRMEDONLY bit = null output,
                        @OTHERASSETVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @OTHERASSETVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @OTHERASSETVALUEMULTIPLIER decimal(20,4) = null output,
                        @OTHERASSETVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @OTHERASSETVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @OTHERASSETVALUECODE tinyint = null output,
                        @OTHERASSETSOURCES xml = null output,

                        @NONPROFITAFFILIATIONINCLUDE bit = null output,
                        @NONPROFITAFFILIATIONCONFIRMEDONLY bit = null output,
                        @NONPROFITAFFILIATIONVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @NONPROFITAFFILIATIONVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @NONPROFITAFFILIATIONVALUEMULTIPLIER decimal(20,4) = null output,
                        @NONPROFITAFFILIATIONVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @NONPROFITAFFILIATIONVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @NONPROFITAFFILIATIONVALUECODE tinyint = null output,
                        @NONPROFITAFFILIATIONSOURCES xml = null output,

                        @PRIVATEFOUNDATIONINCLUDE bit = null output,
                        @PRIVATEFOUNDATIONCONFIRMEDONLY bit = null output,
                        @PRIVATEFOUNDATIONVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @PRIVATEFOUNDATIONVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @PRIVATEFOUNDATIONVALUEMULTIPLIER decimal(20,4) = null output,
                        @PRIVATEFOUNDATIONVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @PRIVATEFOUNDATIONVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @PRIVATEFOUNDATIONVALUECODE tinyint = null output,
                        @PRIVATEFOUNDATIONSOURCES xml = null output,

                        @OTHERSCANMODIFY bit = null output,
                        @REALESTATEINCLUDEHISTORICAL bit = null output,
                        @INCOMECOMPENSATIONINCLUDEHISTORICAL bit = null output,

                        @PHILANTHROPICGIFTINCLUDE bit = null output,
                        @PHILANTHROPICGIFTCONFIRMEDONLY bit = null output,
                        @PHILANTHROPICGIFTVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @PHILANTHROPICGIFTVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @PHILANTHROPICGIFTVALUEMULTIPLIER decimal(20,4) = null output,
                        @PHILANTHROPICGIFTVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @PHILANTHROPICGIFTVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @PHILANTHROPICGIFTVALUECODE tinyint = null output,
                        @PHILANTHROPICGIFTSOURCES xml = null output,

                        @POLITICALDONATIONINCLUDE bit = null output,
                        @POLITICALDONATIONCONFIRMEDONLY bit = null output,
                        @POLITICALDONATIONVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @POLITICALDONATIONVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @POLITICALDONATIONVALUEMULTIPLIER decimal(20,4) = null output,
                        @POLITICALDONATIONVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @POLITICALDONATIONVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @POLITICALDONATIONVALUECODE tinyint = null output,
                        @POLITICALDONATIONSOURCES xml = null output,

                        @GIVINGTOMYORGINCLUDE bit = null output,
                        @GIVINGTOMYORGVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @GIVINGTOMYORGVALUEMULTIPLIER decimal(20,4) = null output,
                        @GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @GIVINGTOMYORGVALUECODE tinyint = null output
                    ) as
                        set nocount on;

                        select
                            @DATALOADED = 1,
                            @TSLONG = WCF.TSLONG,
                            @USERISOWNER = case when WCF.OWNERID = @CURRENTAPPUSERID or WCF.OWNERID is null or dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 then 1 else 0 end,
                            @NAME = WCF.NAME,
                            @DESCRIPTION = WCF.DESCRIPTION,
                            @ISDEFAULT = WCF.ISDEFAULT,

                            @ASSETCALCULATIONMETHODCODE = WCF.ASSETCALCULATIONMETHODCODE,
                            @MAJORGIVINGMULTIPLIERTYPECODE = WCF.MAJORGIVINGMULTIPLIERTYPECODE,
                            @MAJORGIVINGSETVALUEMULTIPLIER = WCF.MAJORGIVINGSETVALUEMULTIPLIER,
                            @MAJORGIVINGOVER70MULTIPLIER = WCF.MAJORGIVINGOVER70MULTIPLIER,
                            @MAJORGIVING60TO69MULTIPLIER = WCF.MAJORGIVING60TO69MULTIPLIER,
                            @MAJORGIVING50TO59MULTIPLIER = WCF.MAJORGIVING50TO59MULTIPLIER,
                            @MAJORGIVING40TO49MULTIPLIER = WCF.MAJORGIVING40TO49MULTIPLIER,
                            @MAJORGIVINGUNDER40MULTIPLIER = WCF.MAJORGIVINGUNDER40MULTIPLIER,
                            @MAJORGIVINGAGEUNKNOWNMULTIPLIER = WCF.MAJORGIVINGAGEUNKNOWNMULTIPLIER,

                            @REALESTATEINCLUDE = WCF.REALESTATEINCLUDE,
                            @REALESTATECONFIRMEDONLY = WCF.REALESTATECONFIRMEDONLY,
                            @REALESTATEVALUEMULTIPLIERTYPECODE = WCF.REALESTATEVALUEMULTIPLIERTYPECODE,
                            @REALESTATEVALUEMULTIPLIERCUTOFFVALUE = WCF.REALESTATEVALUEMULTIPLIERCUTOFFVALUE,
                            @REALESTATEVALUEMULTIPLIER = WCF.REALESTATEVALUEMULTIPLIER,
                            @REALESTATEVALUELESSTHANCUTOFFMULTIPLIER = WCF.REALESTATEVALUELESSTHANCUTOFFMULTIPLIER,
                            @REALESTATEVALUEGREATERTHANCUTOFFMULTIPLIER = WCF.REALESTATEVALUEGREATERTHANCUTOFFMULTIPLIER,
                            @REALESTATEAGGREGATETYPECODE = WCF.REALESTATEAGGREGATETYPECODE,
                            @REALESTATEUSEPROPERTYVALUATION = WCF.REALESTATEUSEPROPERTYVALUATION,
                            @REALESTATEUSEPROPERTYVALUEESTIMATE = WCF.REALESTATEUSEPROPERTYVALUEESTIMATE,
              @REALESTATEINCLUDEHISTORICAL = WCF.REALESTATEINCLUDEHISTORICAL,

                            @BUSINESSOWNERSHIPINCLUDE = WCF.BUSINESSOWNERSHIPINCLUDE,
                            @BUSINESSOWNERSHIPCONFIRMEDONLY = WCF.BUSINESSOWNERSHIPCONFIRMEDONLY,
                            @BUSINESSOWNERSHIPVALUEMULTIPLIERTYPECODE = WCF.BUSINESSOWNERSHIPVALUEMULTIPLIERTYPECODE,
                            @BUSINESSOWNERSHIPVALUEMULTIPLIERCUTOFFVALUE = WCF.BUSINESSOWNERSHIPVALUEMULTIPLIERCUTOFFVALUE,
                            @BUSINESSOWNERSHIPVALUEMULTIPLIER = WCF.BUSINESSOWNERSHIPVALUEMULTIPLIER,
                            @BUSINESSOWNERSHIPVALUELESSTHANCUTOFFMULTIPLIER = WCF.BUSINESSOWNERSHIPVALUELESSTHANCUTOFFMULTIPLIER,
                            @BUSINESSOWNERSHIPVALUEGREATERTHANCUTOFFMULTIPLIER = WCF.BUSINESSOWNERSHIPVALUEGREATERTHANCUTOFFMULTIPLIER,
                            @BUSINESSOWNERSHIPVALUECODE = WCF.BUSINESSOWNERSHIPVALUECODE,

                            @SECURITIESINCLUDE = WCF.SECURITIESINCLUDE,
                            @SECURITIESCONFIRMEDONLY = WCF.SECURITIESCONFIRMEDONLY,
                            @SECURITIESVALUEMULTIPLIERTYPECODE = WCF.SECURITIESVALUEMULTIPLIERTYPECODE,
                            @SECURITIESVALUEMULTIPLIERCUTOFFVALUE = WCF.SECURITIESVALUEMULTIPLIERCUTOFFVALUE,
                            @SECURITIESVALUEMULTIPLIER = WCF.SECURITIESVALUEMULTIPLIER,
                            @SECURITIESVALUELESSTHANCUTOFFMULTIPLIER = WCF.SECURITIESVALUELESSTHANCUTOFFMULTIPLIER,
                            @SECURITIESVALUEGREATERTHANCUTOFFMULTIPLIER = WCF.SECURITIESVALUEGREATERTHANCUTOFFMULTIPLIER,
                            @SECURITIESVALUECODE = WCF.SECURITIESVALUECODE,

                            @INCOMECOMPENSATIONINCLUDE = WCF.INCOMECOMPENSATIONINCLUDE,
                            @INCOMECOMPENSATIONCONFIRMEDONLY = WCF.INCOMECOMPENSATIONCONFIRMEDONLY,
                            @INCOMECOMPENSATIONVALUEMULTIPLIERTYPECODE = WCF.INCOMECOMPENSATIONVALUEMULTIPLIERTYPECODE,
                            @INCOMECOMPENSATIONVALUEMULTIPLIERCUTOFFVALUE = WCF.INCOMECOMPENSATIONVALUEMULTIPLIERCUTOFFVALUE,
                            @INCOMECOMPENSATIONVALUEMULTIPLIER = WCF.INCOMECOMPENSATIONVALUEMULTIPLIER,
                            @INCOMECOMPENSATIONVALUELESSTHANCUTOFFMULTIPLIER = WCF.INCOMECOMPENSATIONVALUELESSTHANCUTOFFMULTIPLIER,
                            @INCOMECOMPENSATIONVALUEGREATERTHANCUTOFFMULTIPLIER = WCF.INCOMECOMPENSATIONVALUEGREATERTHANCUTOFFMULTIPLIER,
                            @INCOMECOMPENSATIONINCLUDESALARY = WCF.INCOMECOMPENSATIONINCLUDESALARY,
                            @INCOMECOMPENSATIONINCLUDEBONUS = WCF.INCOMECOMPENSATIONINCLUDEBONUS,
                            @INCOMECOMPENSATIONINCLUDESHORTTERMCOMP = WCF.INCOMECOMPENSATIONINCLUDESHORTTERMCOMP,
                            @INCOMECOMPENSATIONINCLUDELONGTERMCOMP = WCF.INCOMECOMPENSATIONINCLUDELONGTERMCOMP,
                            @INCOMECOMPENSATIONINCLUDEEXERCISEDOPTIONS = WCF.INCOMECOMPENSATIONINCLUDEEXERCISEDOPTIONS,
                            @INCOMECOMPENSATIONINCLUDEUNEXERCISEDOPTIONS = WCF.INCOMECOMPENSATIONINCLUDEUNEXERCISEDOPTIONS,
                            @INCOMECOMPENSATIONINCLUDEUNEXERCISABLEOPTIONS = WCF.INCOMECOMPENSATIONINCLUDEUNEXERCISABLEOPTIONS,
              @INCOMECOMPENSATIONINCLUDEHISTORICAL = WCF.INCOMECOMPENSATIONINCLUDEHISTORICAL,

                            @OTHERASSETINCLUDE = WCF.OTHERASSETINCLUDE,
                            @OTHERASSETCONFIRMEDONLY = WCF.OTHERASSETCONFIRMEDONLY,
                            @OTHERASSETVALUEMULTIPLIERTYPECODE = WCF.OTHERASSETVALUEMULTIPLIERTYPECODE,
                            @OTHERASSETVALUEMULTIPLIERCUTOFFVALUE = WCF.OTHERASSETVALUEMULTIPLIERCUTOFFVALUE,
                            @OTHERASSETVALUEMULTIPLIER = WCF.OTHERASSETVALUEMULTIPLIER,
                            @OTHERASSETVALUELESSTHANCUTOFFMULTIPLIER = WCF.OTHERASSETVALUELESSTHANCUTOFFMULTIPLIER,
                            @OTHERASSETVALUEGREATERTHANCUTOFFMULTIPLIER = WCF.OTHERASSETVALUEGREATERTHANCUTOFFMULTIPLIER,
                            @OTHERASSETVALUECODE = WCF.OTHERASSETVALUECODE,

                            @NONPROFITAFFILIATIONINCLUDE = WCF.NONPROFITAFFILIATIONINCLUDE,
                            @NONPROFITAFFILIATIONCONFIRMEDONLY = WCF.NONPROFITAFFILIATIONCONFIRMEDONLY,
                            @NONPROFITAFFILIATIONVALUEMULTIPLIERTYPECODE = WCF.NONPROFITAFFILIATIONVALUEMULTIPLIERTYPECODE,
                            @NONPROFITAFFILIATIONVALUEMULTIPLIERCUTOFFVALUE = WCF.NONPROFITAFFILIATIONVALUEMULTIPLIERCUTOFFVALUE,
                            @NONPROFITAFFILIATIONVALUEMULTIPLIER = WCF.NONPROFITAFFILIATIONVALUEMULTIPLIER,
                            @NONPROFITAFFILIATIONVALUELESSTHANCUTOFFMULTIPLIER = WCF.NONPROFITAFFILIATIONVALUELESSTHANCUTOFFMULTIPLIER,
                            @NONPROFITAFFILIATIONVALUEGREATERTHANCUTOFFMULTIPLIER = WCF.NONPROFITAFFILIATIONVALUEGREATERTHANCUTOFFMULTIPLIER,
                            @NONPROFITAFFILIATIONVALUECODE = WCF.NONPROFITAFFILIATIONVALUECODE,

                            @PRIVATEFOUNDATIONINCLUDE = WCF.PRIVATEFOUNDATIONINCLUDE,
                            @PRIVATEFOUNDATIONCONFIRMEDONLY = WCF.PRIVATEFOUNDATIONCONFIRMEDONLY,
                            @PRIVATEFOUNDATIONVALUEMULTIPLIERTYPECODE = WCF.PRIVATEFOUNDATIONVALUEMULTIPLIERTYPECODE,
                            @PRIVATEFOUNDATIONVALUEMULTIPLIERCUTOFFVALUE = WCF.PRIVATEFOUNDATIONVALUEMULTIPLIERCUTOFFVALUE,
                            @PRIVATEFOUNDATIONVALUEMULTIPLIER = WCF.PRIVATEFOUNDATIONVALUEMULTIPLIER,
                            @PRIVATEFOUNDATIONVALUELESSTHANCUTOFFMULTIPLIER = WCF.PRIVATEFOUNDATIONVALUELESSTHANCUTOFFMULTIPLIER,
                            @PRIVATEFOUNDATIONVALUEGREATERTHANCUTOFFMULTIPLIER = WCF.PRIVATEFOUNDATIONVALUEGREATERTHANCUTOFFMULTIPLIER,
                            @PRIVATEFOUNDATIONVALUECODE = WCF.PRIVATEFOUNDATIONVALUECODE,

                            @OTHERSCANMODIFY = WCF.OTHERSCANMODIFY,

                            @PHILANTHROPICGIFTINCLUDE = WCF.PHILANTHROPICGIFTINCLUDE,
                            @PHILANTHROPICGIFTCONFIRMEDONLY = WCF.PHILANTHROPICGIFTCONFIRMEDONLY,
                            @PHILANTHROPICGIFTVALUEMULTIPLIERTYPECODE = WCF.PHILANTHROPICGIFTVALUEMULTIPLIERTYPECODE,
                            @PHILANTHROPICGIFTVALUEMULTIPLIERCUTOFFVALUE = WCF.PHILANTHROPICGIFTVALUEMULTIPLIERCUTOFFVALUE,
                            @PHILANTHROPICGIFTVALUEMULTIPLIER = WCF.PHILANTHROPICGIFTVALUEMULTIPLIER,
                            @PHILANTHROPICGIFTVALUELESSTHANCUTOFFMULTIPLIER = WCF.PHILANTHROPICGIFTVALUELESSTHANCUTOFFMULTIPLIER,
                            @PHILANTHROPICGIFTVALUEGREATERTHANCUTOFFMULTIPLIER = WCF.PHILANTHROPICGIFTVALUEGREATERTHANCUTOFFMULTIPLIER,
                            @PHILANTHROPICGIFTVALUECODE = WCF.PHILANTHROPICGIFTVALUECODE,

                            @POLITICALDONATIONINCLUDE = WCF.POLITICALDONATIONINCLUDE,
                            @POLITICALDONATIONCONFIRMEDONLY = WCF.POLITICALDONATIONCONFIRMEDONLY,
                            @POLITICALDONATIONVALUEMULTIPLIERTYPECODE = WCF.POLITICALDONATIONVALUEMULTIPLIERTYPECODE,
                            @POLITICALDONATIONVALUEMULTIPLIERCUTOFFVALUE = WCF.POLITICALDONATIONVALUEMULTIPLIERCUTOFFVALUE,
                            @POLITICALDONATIONVALUEMULTIPLIER = WCF.POLITICALDONATIONVALUEMULTIPLIER,
                            @POLITICALDONATIONVALUELESSTHANCUTOFFMULTIPLIER = WCF.POLITICALDONATIONVALUELESSTHANCUTOFFMULTIPLIER,
                            @POLITICALDONATIONVALUEGREATERTHANCUTOFFMULTIPLIER = WCF.POLITICALDONATIONVALUEGREATERTHANCUTOFFMULTIPLIER,
                            @POLITICALDONATIONVALUECODE = WCF.POLITICALDONATIONVALUECODE,

                            @GIVINGTOMYORGINCLUDE = WCF.GIVINGTOMYORGINCLUDE,
                            @GIVINGTOMYORGVALUEMULTIPLIERTYPECODE = WCF.GIVINGTOMYORGVALUEMULTIPLIERTYPECODE,
                            @GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE = WCF.GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE,
                            @GIVINGTOMYORGVALUEMULTIPLIER = WCF.GIVINGTOMYORGVALUEMULTIPLIER,
                            @GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER = WCF.GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER,
                            @GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER = WCF.GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER,
                            @GIVINGTOMYORGVALUECODE = WCF.GIVINGTOMYORGVALUECODE
                        from
                            dbo.WEALTHCAPACITYFORMULA WCF
                        where
                            ID = @ID;

                        set @REALESTATESOURCES =           dbo.UFN_WEALTHCAPACITYFORMULA_REALESTATE_GETSOURCES_TOITEMLISTXML(@ID);    
                        set @SECURITIESSOURCES =           dbo.UFN_WEALTHCAPACITYFORMULA_SECURITIES_GETSOURCES_TOITEMLISTXML(@ID);
                        set @INCOMECOMPENSATIONSOURCES =   dbo.UFN_WEALTHCAPACITYFORMULA_INCOMECOMPENSATION_GETSOURCES_TOITEMLISTXML(@ID);
                        set @NONPROFITAFFILIATIONSOURCES = dbo.UFN_WEALTHCAPACITYFORMULA_NONPROFITAFFILIATION_GETSOURCES_TOITEMLISTXML(@ID);
                        set @OTHERASSETSOURCES =           dbo.UFN_WEALTHCAPACITYFORMULA_OTHERASSET_GETSOURCES_TOITEMLISTXML(@ID);
                        set @PRIVATEFOUNDATIONSOURCES =    dbo.UFN_WEALTHCAPACITYFORMULA_PRIVATEFOUNDATION_GETSOURCES_TOITEMLISTXML(@ID);
                        set @BUSINESSOWNERSHIPSOURCES =    dbo.UFN_WEALTHCAPACITYFORMULA_BUSINESSOWNERSHIP_GETSOURCES_TOITEMLISTXML(@ID);
                        set @PHILANTHROPICGIFTSOURCES =    dbo.UFN_WEALTHCAPACITYFORMULA_PHILANTHROPICGIFT_GETSOURCES_TOITEMLISTXML(@ID);
                        set @POLITICALDONATIONSOURCES =    dbo.UFN_WEALTHCAPACITYFORMULA_POLITICALDONATION_GETSOURCES_TOITEMLISTXML(@ID);

                        return 0;