USP_DATAFORMTEMPLATE_ADD_WEALTHCAPACITYFORMULA_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	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
@REALESTATEINCLUDEASSESSMENTANDDEEDRECORDS	tinyint	INOUT	Value to use in calculation
@REALESTATEAGGREGATETYPECODE	tinyint	INOUT	Real estate aggregate type
@REALESTATEUSETOTALMARKETVALUE	bit	INOUT	Total market value
@REALESTATEUSETOTALASSESSEDVALUE	bit	INOUT	Total assessed value
@REALESTATEUSESALEPRICE	bit	INOUT	Sale price
@REALESTATEUSELOANAMOUNT	bit	INOUT	Loan amount
@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
@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
@AFFLUENCEINDICATORINCLUDE	bit	INOUT	Affluence indicators
@AFFLUENCEINDICATORCONFIRMEDONLY	bit	INOUT	Use confirmed records only
@AFFLUENCEINDICATORVALUEMULTIPLIERTYPECODE	tinyint	INOUT	Affluence indicator multiplier type
@AFFLUENCEINDICATORVALUEMULTIPLIERCUTOFFVALUE	money	INOUT	If less than
@AFFLUENCEINDICATORVALUEMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@AFFLUENCEINDICATORVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Multiply value by
@AFFLUENCEINDICATORVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	INOUT	Otherwise multiply by
@AFFLUENCEINDICATORVALUECODE	tinyint	INOUT	Value to use in calculation
@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
@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
@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
@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
@APPLYTOCODE	tinyint	INOUT	Apply to
@OTHERSCANMODIFY	bit	INOUT	Other users may modify this formula

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_WEALTHCAPACITYFORMULA_PRELOAD (
                        @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,
                        @REALESTATEINCLUDEASSESSMENTANDDEEDRECORDS tinyint = null output,
                        @REALESTATEAGGREGATETYPECODE tinyint = null output,
                        @REALESTATEUSETOTALMARKETVALUE bit = null output,
                        @REALESTATEUSETOTALASSESSEDVALUE bit = null output,
                        @REALESTATEUSESALEPRICE bit = null output,
                        @REALESTATEUSELOANAMOUNT bit = 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,

                        @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,

                        @AFFLUENCEINDICATORINCLUDE bit = null output,
                        @AFFLUENCEINDICATORCONFIRMEDONLY bit = null output,
                        @AFFLUENCEINDICATORVALUEMULTIPLIERTYPECODE tinyint = null output,
                        @AFFLUENCEINDICATORVALUEMULTIPLIERCUTOFFVALUE money = null output,
                        @AFFLUENCEINDICATORVALUEMULTIPLIER decimal(20,4) = null output,
                        @AFFLUENCEINDICATORVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @AFFLUENCEINDICATORVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4) = null output,
                        @AFFLUENCEINDICATORVALUECODE tinyint = 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,

                        @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,

                        @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,

                        @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,

                        @APPLYTOCODE tinyint = null output,
                        @OTHERSCANMODIFY bit = null output
                    ) as
                        set nocount on;

                        select
                            @ISDEFAULT = case count(WCF.ID) when 0 then 1 else 0 end
                        from
                            dbo.WEALTHCAPACITYFORMULA WCF
                        where
                            WCF.ISDEFAULT = 1;

                        set @ASSETCALCULATIONMETHODCODE = 0;
                        set @MAJORGIVINGMULTIPLIERTYPECODE = 0;
                        set @MAJORGIVINGSETVALUEMULTIPLIER = 0.05;
                        set @MAJORGIVINGOVER70MULTIPLIER = 0.05;
                        set @MAJORGIVING60TO69MULTIPLIER = 0.04;
                        set @MAJORGIVING50TO59MULTIPLIER = 0.03;
                        set @MAJORGIVING40TO49MULTIPLIER = 0.02;
                        set @MAJORGIVINGUNDER40MULTIPLIER = 0.01;
                        set @MAJORGIVINGAGEUNKNOWNMULTIPLIER = 0.01;

                        set @REALESTATEINCLUDE = 1;
                        set @REALESTATECONFIRMEDONLY = 1;
                        set @REALESTATEVALUEMULTIPLIERTYPECODE = 0;
                        set @REALESTATEVALUEMULTIPLIERCUTOFFVALUE = 0;
                        set @REALESTATEVALUEMULTIPLIER = 1;
                        set @REALESTATEVALUELESSTHANCUTOFFMULTIPLIER = 0;
                        set @REALESTATEVALUEGREATERTHANCUTOFFMULTIPLIER = 0;
                        set @REALESTATEINCLUDEASSESSMENTANDDEEDRECORDS = 0;
                        set @REALESTATEAGGREGATETYPECODE = 0;
                        set @REALESTATEUSETOTALMARKETVALUE = 1;
                        set @REALESTATEUSETOTALASSESSEDVALUE = 1;
                        set @REALESTATEUSESALEPRICE = 1;
                        set @REALESTATEUSELOANAMOUNT = 1;

                        set @BUSINESSOWNERSHIPINCLUDE = 1;
                        set @BUSINESSOWNERSHIPCONFIRMEDONLY = 1;
                        set @BUSINESSOWNERSHIPVALUEMULTIPLIERTYPECODE = 0;
                        set @BUSINESSOWNERSHIPVALUEMULTIPLIERCUTOFFVALUE = 0;
                        set @BUSINESSOWNERSHIPVALUEMULTIPLIER = 1;
                        set @BUSINESSOWNERSHIPVALUELESSTHANCUTOFFMULTIPLIER = 0;
                        set @BUSINESSOWNERSHIPVALUEGREATERTHANCUTOFFMULTIPLIER = 0;
                        set @BUSINESSOWNERSHIPVALUECODE = 0;

                        set @SECURITIESINCLUDE = 1;
                        set @SECURITIESCONFIRMEDONLY = 1;
                        set @SECURITIESVALUEMULTIPLIERTYPECODE = 0;
                        set @SECURITIESVALUEMULTIPLIERCUTOFFVALUE = 0;
                        set @SECURITIESVALUEMULTIPLIER = 1;
                        set @SECURITIESVALUELESSTHANCUTOFFMULTIPLIER = 0;
                        set @SECURITIESVALUEGREATERTHANCUTOFFMULTIPLIER = 0;
                        set @SECURITIESVALUECODE = 0;

                        set @AFFLUENCEINDICATORINCLUDE = 1;
                        set @AFFLUENCEINDICATORCONFIRMEDONLY = 1;
                        set @AFFLUENCEINDICATORVALUEMULTIPLIERTYPECODE = 0;
                        set @AFFLUENCEINDICATORVALUEMULTIPLIERCUTOFFVALUE = 0;
                        set @AFFLUENCEINDICATORVALUEMULTIPLIER = 1;
                        set @AFFLUENCEINDICATORVALUELESSTHANCUTOFFMULTIPLIER = 0;
                        set @AFFLUENCEINDICATORVALUEGREATERTHANCUTOFFMULTIPLIER = 0;
                        set @AFFLUENCEINDICATORVALUECODE = 0;

                        set @INCOMECOMPENSATIONINCLUDE = 1;
                        set @INCOMECOMPENSATIONCONFIRMEDONLY = 1;
                        set @INCOMECOMPENSATIONVALUEMULTIPLIERTYPECODE = 0;
                        set @INCOMECOMPENSATIONVALUEMULTIPLIERCUTOFFVALUE = 0;
                        set @INCOMECOMPENSATIONVALUEMULTIPLIER = 1;
                        set @INCOMECOMPENSATIONVALUELESSTHANCUTOFFMULTIPLIER = 0;
                        set @INCOMECOMPENSATIONVALUEGREATERTHANCUTOFFMULTIPLIER = 0;
                        set @INCOMECOMPENSATIONINCLUDESALARY = 1;
                        set @INCOMECOMPENSATIONINCLUDEBONUS = 1;
                        set @INCOMECOMPENSATIONINCLUDESHORTTERMCOMP = 0;
                        set @INCOMECOMPENSATIONINCLUDELONGTERMCOMP = 0;
                        set @INCOMECOMPENSATIONINCLUDEEXERCISEDOPTIONS = 0;
                        set @INCOMECOMPENSATIONINCLUDEUNEXERCISEDOPTIONS = 0;
                        set @INCOMECOMPENSATIONINCLUDEUNEXERCISABLEOPTIONS = 0;

                        set @OTHERASSETINCLUDE = 1;
                        set @OTHERASSETCONFIRMEDONLY = 1;
                        set @OTHERASSETVALUEMULTIPLIERTYPECODE = 0;
                        set @OTHERASSETVALUEMULTIPLIERCUTOFFVALUE = 0;
                        set @OTHERASSETVALUEMULTIPLIER = 1;
                        set @OTHERASSETVALUELESSTHANCUTOFFMULTIPLIER = 0;
                        set @OTHERASSETVALUEGREATERTHANCUTOFFMULTIPLIER = 0;
                        set @OTHERASSETVALUECODE = 0;

                        set @NONPROFITAFFILIATIONINCLUDE = 0;
                        set @NONPROFITAFFILIATIONCONFIRMEDONLY = 1;
                        set @NONPROFITAFFILIATIONVALUEMULTIPLIERTYPECODE = 0;
                        set @NONPROFITAFFILIATIONVALUEMULTIPLIERCUTOFFVALUE = 0;
                        set @NONPROFITAFFILIATIONVALUEMULTIPLIER = 1;
                        set @NONPROFITAFFILIATIONVALUELESSTHANCUTOFFMULTIPLIER = 0;
                        set @NONPROFITAFFILIATIONVALUEGREATERTHANCUTOFFMULTIPLIER = 0;
                        set @NONPROFITAFFILIATIONVALUECODE = 0;

                        set @PRIVATEFOUNDATIONINCLUDE = 0;
                        set @PRIVATEFOUNDATIONCONFIRMEDONLY = 1;
                        set @PRIVATEFOUNDATIONVALUEMULTIPLIERTYPECODE = 0;
                        set @PRIVATEFOUNDATIONVALUEMULTIPLIERCUTOFFVALUE = 0;
                        set @PRIVATEFOUNDATIONVALUEMULTIPLIER = 1;
                        set @PRIVATEFOUNDATIONVALUELESSTHANCUTOFFMULTIPLIER = 0;
                        set @PRIVATEFOUNDATIONVALUEGREATERTHANCUTOFFMULTIPLIER = 0;
                        set @PRIVATEFOUNDATIONVALUECODE = 0;

                        set @APPLYTOCODE = 0;

                        set @OTHERSCANMODIFY = 1;

                        return 0;