USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITYFORMULA_3
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @NAME | nvarchar(100) | IN | |
| @DESCRIPTION | nvarchar(255) | IN | |
| @ISDEFAULT | bit | IN | |
| @ASSETCALCULATIONMETHODCODE | tinyint | IN | |
| @MAJORGIVINGMULTIPLIERTYPECODE | tinyint | IN | |
| @MAJORGIVINGSETVALUEMULTIPLIER | decimal(20, 4) | IN | |
| @MAJORGIVINGOVER70MULTIPLIER | decimal(20, 4) | IN | |
| @MAJORGIVING60TO69MULTIPLIER | decimal(20, 4) | IN | |
| @MAJORGIVING50TO59MULTIPLIER | decimal(20, 4) | IN | |
| @MAJORGIVING40TO49MULTIPLIER | decimal(20, 4) | IN | |
| @MAJORGIVINGUNDER40MULTIPLIER | decimal(20, 4) | IN | |
| @MAJORGIVINGAGEUNKNOWNMULTIPLIER | decimal(20, 4) | IN | |
| @REALESTATEINCLUDE | bit | IN | |
| @REALESTATECONFIRMEDONLY | bit | IN | |
| @REALESTATEVALUEMULTIPLIERTYPECODE | tinyint | IN | |
| @REALESTATEVALUEMULTIPLIERCUTOFFVALUE | money | IN | |
| @REALESTATEVALUEMULTIPLIER | decimal(20, 4) | IN | |
| @REALESTATEVALUELESSTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @REALESTATEVALUEGREATERTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @REALESTATEAGGREGATETYPECODE | tinyint | IN | |
| @REALESTATEUSEPROPERTYVALUATION | bit | IN | |
| @REALESTATEUSEPROPERTYVALUEESTIMATE | bit | IN | |
| @REALESTATESOURCES | xml | IN | |
| @BUSINESSOWNERSHIPINCLUDE | bit | IN | |
| @BUSINESSOWNERSHIPCONFIRMEDONLY | bit | IN | |
| @BUSINESSOWNERSHIPVALUEMULTIPLIERTYPECODE | tinyint | IN | |
| @BUSINESSOWNERSHIPVALUEMULTIPLIERCUTOFFVALUE | money | IN | |
| @BUSINESSOWNERSHIPVALUEMULTIPLIER | decimal(20, 4) | IN | |
| @BUSINESSOWNERSHIPVALUELESSTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @BUSINESSOWNERSHIPVALUEGREATERTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @BUSINESSOWNERSHIPVALUECODE | tinyint | IN | |
| @BUSINESSOWNERSHIPSOURCES | xml | IN | |
| @SECURITIESINCLUDE | bit | IN | |
| @SECURITIESCONFIRMEDONLY | bit | IN | |
| @SECURITIESVALUEMULTIPLIERTYPECODE | tinyint | IN | |
| @SECURITIESVALUEMULTIPLIERCUTOFFVALUE | money | IN | |
| @SECURITIESVALUEMULTIPLIER | decimal(20, 4) | IN | |
| @SECURITIESVALUELESSTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @SECURITIESVALUEGREATERTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @SECURITIESVALUECODE | tinyint | IN | |
| @SECURITIESSOURCES | xml | IN | |
| @INCOMECOMPENSATIONINCLUDE | bit | IN | |
| @INCOMECOMPENSATIONCONFIRMEDONLY | bit | IN | |
| @INCOMECOMPENSATIONVALUEMULTIPLIERTYPECODE | tinyint | IN | |
| @INCOMECOMPENSATIONVALUEMULTIPLIERCUTOFFVALUE | money | IN | |
| @INCOMECOMPENSATIONVALUEMULTIPLIER | decimal(20, 4) | IN | |
| @INCOMECOMPENSATIONVALUELESSTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @INCOMECOMPENSATIONVALUEGREATERTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @INCOMECOMPENSATIONINCLUDESALARY | bit | IN | |
| @INCOMECOMPENSATIONINCLUDEBONUS | bit | IN | |
| @INCOMECOMPENSATIONINCLUDESHORTTERMCOMP | bit | IN | |
| @INCOMECOMPENSATIONINCLUDELONGTERMCOMP | bit | IN | |
| @INCOMECOMPENSATIONINCLUDEEXERCISEDOPTIONS | bit | IN | |
| @INCOMECOMPENSATIONINCLUDEUNEXERCISEDOPTIONS | bit | IN | |
| @INCOMECOMPENSATIONINCLUDEUNEXERCISABLEOPTIONS | bit | IN | |
| @INCOMECOMPENSATIONSOURCES | xml | IN | |
| @OTHERASSETINCLUDE | bit | IN | |
| @OTHERASSETCONFIRMEDONLY | bit | IN | |
| @OTHERASSETVALUEMULTIPLIERTYPECODE | tinyint | IN | |
| @OTHERASSETVALUEMULTIPLIERCUTOFFVALUE | money | IN | |
| @OTHERASSETVALUEMULTIPLIER | decimal(20, 4) | IN | |
| @OTHERASSETVALUELESSTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @OTHERASSETVALUEGREATERTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @OTHERASSETVALUECODE | tinyint | IN | |
| @OTHERASSETSOURCES | xml | IN | |
| @NONPROFITAFFILIATIONINCLUDE | bit | IN | |
| @NONPROFITAFFILIATIONCONFIRMEDONLY | bit | IN | |
| @NONPROFITAFFILIATIONVALUEMULTIPLIERTYPECODE | tinyint | IN | |
| @NONPROFITAFFILIATIONVALUEMULTIPLIERCUTOFFVALUE | money | IN | |
| @NONPROFITAFFILIATIONVALUEMULTIPLIER | decimal(20, 4) | IN | |
| @NONPROFITAFFILIATIONVALUELESSTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @NONPROFITAFFILIATIONVALUEGREATERTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @NONPROFITAFFILIATIONVALUECODE | tinyint | IN | |
| @NONPROFITAFFILIATIONSOURCES | xml | IN | |
| @PRIVATEFOUNDATIONINCLUDE | bit | IN | |
| @PRIVATEFOUNDATIONCONFIRMEDONLY | bit | IN | |
| @PRIVATEFOUNDATIONVALUEMULTIPLIERTYPECODE | tinyint | IN | |
| @PRIVATEFOUNDATIONVALUEMULTIPLIERCUTOFFVALUE | money | IN | |
| @PRIVATEFOUNDATIONVALUEMULTIPLIER | decimal(20, 4) | IN | |
| @PRIVATEFOUNDATIONVALUELESSTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @PRIVATEFOUNDATIONVALUEGREATERTHANCUTOFFMULTIPLIER | decimal(20, 4) | IN | |
| @PRIVATEFOUNDATIONVALUECODE | tinyint | IN | |
| @PRIVATEFOUNDATIONSOURCES | xml | IN | |
| @OTHERSCANMODIFY | bit | IN | |
| @REALESTATEINCLUDEHISTORICAL | bit | IN | |
| @INCOMECOMPENSATIONINCLUDEHISTORICAL | bit | IN |
Definition
Copy
CREATE procedure USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITYFORMULA_3
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@CURRENTAPPUSERID uniqueidentifier,
@NAME nvarchar(100),
@DESCRIPTION nvarchar(255),
@ISDEFAULT bit,
@ASSETCALCULATIONMETHODCODE tinyint,
@MAJORGIVINGMULTIPLIERTYPECODE tinyint,
@MAJORGIVINGSETVALUEMULTIPLIER decimal(20,4),
@MAJORGIVINGOVER70MULTIPLIER decimal(20,4),
@MAJORGIVING60TO69MULTIPLIER decimal(20,4),
@MAJORGIVING50TO59MULTIPLIER decimal(20,4),
@MAJORGIVING40TO49MULTIPLIER decimal(20,4),
@MAJORGIVINGUNDER40MULTIPLIER decimal(20,4),
@MAJORGIVINGAGEUNKNOWNMULTIPLIER decimal(20,4),
@REALESTATEINCLUDE bit,
@REALESTATECONFIRMEDONLY bit,
@REALESTATEVALUEMULTIPLIERTYPECODE tinyint,
@REALESTATEVALUEMULTIPLIERCUTOFFVALUE money,
@REALESTATEVALUEMULTIPLIER decimal(20,4),
@REALESTATEVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4),
@REALESTATEVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4),
@REALESTATEAGGREGATETYPECODE tinyint,
@REALESTATEUSEPROPERTYVALUATION bit,
@REALESTATEUSEPROPERTYVALUEESTIMATE bit,
@REALESTATESOURCES xml,
@BUSINESSOWNERSHIPINCLUDE bit,
@BUSINESSOWNERSHIPCONFIRMEDONLY bit,
@BUSINESSOWNERSHIPVALUEMULTIPLIERTYPECODE tinyint,
@BUSINESSOWNERSHIPVALUEMULTIPLIERCUTOFFVALUE money,
@BUSINESSOWNERSHIPVALUEMULTIPLIER decimal(20,4),
@BUSINESSOWNERSHIPVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4),
@BUSINESSOWNERSHIPVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4),
@BUSINESSOWNERSHIPVALUECODE tinyint,
@BUSINESSOWNERSHIPSOURCES xml,
@SECURITIESINCLUDE bit,
@SECURITIESCONFIRMEDONLY bit,
@SECURITIESVALUEMULTIPLIERTYPECODE tinyint,
@SECURITIESVALUEMULTIPLIERCUTOFFVALUE money,
@SECURITIESVALUEMULTIPLIER decimal(20,4),
@SECURITIESVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4),
@SECURITIESVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4),
@SECURITIESVALUECODE tinyint,
@SECURITIESSOURCES xml,
@INCOMECOMPENSATIONINCLUDE bit,
@INCOMECOMPENSATIONCONFIRMEDONLY bit,
@INCOMECOMPENSATIONVALUEMULTIPLIERTYPECODE tinyint,
@INCOMECOMPENSATIONVALUEMULTIPLIERCUTOFFVALUE money,
@INCOMECOMPENSATIONVALUEMULTIPLIER decimal(20,4),
@INCOMECOMPENSATIONVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4),
@INCOMECOMPENSATIONVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4),
@INCOMECOMPENSATIONINCLUDESALARY bit,
@INCOMECOMPENSATIONINCLUDEBONUS bit,
@INCOMECOMPENSATIONINCLUDESHORTTERMCOMP bit,
@INCOMECOMPENSATIONINCLUDELONGTERMCOMP bit,
@INCOMECOMPENSATIONINCLUDEEXERCISEDOPTIONS bit,
@INCOMECOMPENSATIONINCLUDEUNEXERCISEDOPTIONS bit,
@INCOMECOMPENSATIONINCLUDEUNEXERCISABLEOPTIONS bit,
@INCOMECOMPENSATIONSOURCES xml,
@OTHERASSETINCLUDE bit,
@OTHERASSETCONFIRMEDONLY bit,
@OTHERASSETVALUEMULTIPLIERTYPECODE tinyint,
@OTHERASSETVALUEMULTIPLIERCUTOFFVALUE money,
@OTHERASSETVALUEMULTIPLIER decimal(20,4),
@OTHERASSETVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4),
@OTHERASSETVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4),
@OTHERASSETVALUECODE tinyint,
@OTHERASSETSOURCES xml,
@NONPROFITAFFILIATIONINCLUDE bit,
@NONPROFITAFFILIATIONCONFIRMEDONLY bit,
@NONPROFITAFFILIATIONVALUEMULTIPLIERTYPECODE tinyint,
@NONPROFITAFFILIATIONVALUEMULTIPLIERCUTOFFVALUE money,
@NONPROFITAFFILIATIONVALUEMULTIPLIER decimal(20,4),
@NONPROFITAFFILIATIONVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4),
@NONPROFITAFFILIATIONVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4),
@NONPROFITAFFILIATIONVALUECODE tinyint,
@NONPROFITAFFILIATIONSOURCES xml,
@PRIVATEFOUNDATIONINCLUDE bit,
@PRIVATEFOUNDATIONCONFIRMEDONLY bit,
@PRIVATEFOUNDATIONVALUEMULTIPLIERTYPECODE tinyint,
@PRIVATEFOUNDATIONVALUEMULTIPLIERCUTOFFVALUE money,
@PRIVATEFOUNDATIONVALUEMULTIPLIER decimal(20,4),
@PRIVATEFOUNDATIONVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4),
@PRIVATEFOUNDATIONVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4),
@PRIVATEFOUNDATIONVALUECODE tinyint,
@PRIVATEFOUNDATIONSOURCES xml,
@OTHERSCANMODIFY bit,
@REALESTATEINCLUDEHISTORICAL bit,
@INCOMECOMPENSATIONINCLUDEHISTORICAL bit
)
as
set nocount on;
declare @PHILANTHROPICGIFTINCLUDE bit;
declare @PHILANTHROPICGIFTCONFIRMEDONLY bit;
declare @PHILANTHROPICGIFTVALUEMULTIPLIERTYPECODE tinyint;
declare @PHILANTHROPICGIFTVALUEMULTIPLIERCUTOFFVALUE money;
declare @PHILANTHROPICGIFTVALUEMULTIPLIER decimal(20,4);
declare @PHILANTHROPICGIFTVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4);
declare @PHILANTHROPICGIFTVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4);
declare @PHILANTHROPICGIFTVALUECODE tinyint;
declare @PHILANTHROPICGIFTSOURCES xml;
declare @POLITICALDONATIONINCLUDE bit;
declare @POLITICALDONATIONCONFIRMEDONLY bit;
declare @POLITICALDONATIONVALUEMULTIPLIERTYPECODE tinyint;
declare @POLITICALDONATIONVALUEMULTIPLIERCUTOFFVALUE money;
declare @POLITICALDONATIONVALUEMULTIPLIER decimal(20,4);
declare @POLITICALDONATIONVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4);
declare @POLITICALDONATIONVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4);
declare @POLITICALDONATIONVALUECODE tinyint;
declare @POLITICALDONATIONSOURCES xml;
declare @GIVINGTOMYORGINCLUDE bit;
declare @GIVINGTOMYORGVALUEMULTIPLIERTYPECODE tinyint;
declare @GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE money;
declare @GIVINGTOMYORGVALUEMULTIPLIER decimal(20,4);
declare @GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4);
declare @GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4);
declare @GIVINGTOMYORGVALUECODE tinyint;
exec dbo.USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITYFORMULA_LOAD_2
@ID = @ID,
@CURRENTAPPUSERID = @CURRENTAPPUSERID,
@PHILANTHROPICGIFTINCLUDE = @PHILANTHROPICGIFTINCLUDE output,
@PHILANTHROPICGIFTCONFIRMEDONLY = @PHILANTHROPICGIFTCONFIRMEDONLY output,
@PHILANTHROPICGIFTVALUEMULTIPLIERTYPECODE = @PHILANTHROPICGIFTVALUEMULTIPLIERTYPECODE output,
@PHILANTHROPICGIFTVALUEMULTIPLIERCUTOFFVALUE = @PHILANTHROPICGIFTVALUEMULTIPLIERCUTOFFVALUE output,
@PHILANTHROPICGIFTVALUEMULTIPLIER = @PHILANTHROPICGIFTVALUEMULTIPLIER output,
@PHILANTHROPICGIFTVALUELESSTHANCUTOFFMULTIPLIER = @PHILANTHROPICGIFTVALUELESSTHANCUTOFFMULTIPLIER output,
@PHILANTHROPICGIFTVALUEGREATERTHANCUTOFFMULTIPLIER = @PHILANTHROPICGIFTVALUEGREATERTHANCUTOFFMULTIPLIER output,
@PHILANTHROPICGIFTVALUECODE = @PHILANTHROPICGIFTVALUECODE output,
@PHILANTHROPICGIFTSOURCES = @PHILANTHROPICGIFTSOURCES output,
@POLITICALDONATIONINCLUDE = @POLITICALDONATIONINCLUDE output,
@POLITICALDONATIONCONFIRMEDONLY = @POLITICALDONATIONCONFIRMEDONLY output,
@POLITICALDONATIONVALUEMULTIPLIERTYPECODE = @POLITICALDONATIONVALUEMULTIPLIERTYPECODE output,
@POLITICALDONATIONVALUEMULTIPLIERCUTOFFVALUE = @POLITICALDONATIONVALUEMULTIPLIERCUTOFFVALUE output,
@POLITICALDONATIONVALUEMULTIPLIER = @POLITICALDONATIONVALUEMULTIPLIER output,
@POLITICALDONATIONVALUELESSTHANCUTOFFMULTIPLIER = @POLITICALDONATIONVALUELESSTHANCUTOFFMULTIPLIER output,
@POLITICALDONATIONVALUEGREATERTHANCUTOFFMULTIPLIER = @POLITICALDONATIONVALUEGREATERTHANCUTOFFMULTIPLIER output,
@POLITICALDONATIONVALUECODE = @POLITICALDONATIONVALUECODE output,
@POLITICALDONATIONSOURCES = @POLITICALDONATIONSOURCES output,
@GIVINGTOMYORGINCLUDE = @GIVINGTOMYORGINCLUDE output,
@GIVINGTOMYORGVALUEMULTIPLIERTYPECODE = @GIVINGTOMYORGVALUEMULTIPLIERTYPECODE output,
@GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE = @GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE output,
@GIVINGTOMYORGVALUEMULTIPLIER = @GIVINGTOMYORGVALUEMULTIPLIER output,
@GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER = @GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER output,
@GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER = @GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER output,
@GIVINGTOMYORGVALUECODE = @GIVINGTOMYORGVALUECODE output;
exec dbo.USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITYFORMULA_4
@ID,
@CHANGEAGENTID,
@CURRENTAPPUSERID,
@NAME,
@DESCRIPTION,
@ISDEFAULT,
@ASSETCALCULATIONMETHODCODE,
@MAJORGIVINGMULTIPLIERTYPECODE,
@MAJORGIVINGSETVALUEMULTIPLIER,
@MAJORGIVINGOVER70MULTIPLIER,
@MAJORGIVING60TO69MULTIPLIER,
@MAJORGIVING50TO59MULTIPLIER,
@MAJORGIVING40TO49MULTIPLIER,
@MAJORGIVINGUNDER40MULTIPLIER,
@MAJORGIVINGAGEUNKNOWNMULTIPLIER,
@REALESTATEINCLUDE,
@REALESTATECONFIRMEDONLY,
@REALESTATEVALUEMULTIPLIERTYPECODE,
@REALESTATEVALUEMULTIPLIERCUTOFFVALUE,
@REALESTATEVALUEMULTIPLIER,
@REALESTATEVALUELESSTHANCUTOFFMULTIPLIER,
@REALESTATEVALUEGREATERTHANCUTOFFMULTIPLIER,
@REALESTATEAGGREGATETYPECODE,
@REALESTATEUSEPROPERTYVALUATION,
@REALESTATEUSEPROPERTYVALUEESTIMATE,
@REALESTATESOURCES,
@BUSINESSOWNERSHIPINCLUDE,
@BUSINESSOWNERSHIPCONFIRMEDONLY,
@BUSINESSOWNERSHIPVALUEMULTIPLIERTYPECODE,
@BUSINESSOWNERSHIPVALUEMULTIPLIERCUTOFFVALUE,
@BUSINESSOWNERSHIPVALUEMULTIPLIER,
@BUSINESSOWNERSHIPVALUELESSTHANCUTOFFMULTIPLIER,
@BUSINESSOWNERSHIPVALUEGREATERTHANCUTOFFMULTIPLIER,
@BUSINESSOWNERSHIPVALUECODE,
@BUSINESSOWNERSHIPSOURCES,
@SECURITIESINCLUDE,
@SECURITIESCONFIRMEDONLY,
@SECURITIESVALUEMULTIPLIERTYPECODE,
@SECURITIESVALUEMULTIPLIERCUTOFFVALUE,
@SECURITIESVALUEMULTIPLIER,
@SECURITIESVALUELESSTHANCUTOFFMULTIPLIER,
@SECURITIESVALUEGREATERTHANCUTOFFMULTIPLIER,
@SECURITIESVALUECODE,
@SECURITIESSOURCES,
@INCOMECOMPENSATIONINCLUDE,
@INCOMECOMPENSATIONCONFIRMEDONLY,
@INCOMECOMPENSATIONVALUEMULTIPLIERTYPECODE,
@INCOMECOMPENSATIONVALUEMULTIPLIERCUTOFFVALUE,
@INCOMECOMPENSATIONVALUEMULTIPLIER,
@INCOMECOMPENSATIONVALUELESSTHANCUTOFFMULTIPLIER,
@INCOMECOMPENSATIONVALUEGREATERTHANCUTOFFMULTIPLIER,
@INCOMECOMPENSATIONINCLUDESALARY,
@INCOMECOMPENSATIONINCLUDEBONUS,
@INCOMECOMPENSATIONINCLUDESHORTTERMCOMP,
@INCOMECOMPENSATIONINCLUDELONGTERMCOMP,
@INCOMECOMPENSATIONINCLUDEEXERCISEDOPTIONS,
@INCOMECOMPENSATIONINCLUDEUNEXERCISEDOPTIONS,
@INCOMECOMPENSATIONINCLUDEUNEXERCISABLEOPTIONS,
@INCOMECOMPENSATIONSOURCES,
@OTHERASSETINCLUDE,
@OTHERASSETCONFIRMEDONLY,
@OTHERASSETVALUEMULTIPLIERTYPECODE,
@OTHERASSETVALUEMULTIPLIERCUTOFFVALUE,
@OTHERASSETVALUEMULTIPLIER,
@OTHERASSETVALUELESSTHANCUTOFFMULTIPLIER,
@OTHERASSETVALUEGREATERTHANCUTOFFMULTIPLIER,
@OTHERASSETVALUECODE,
@OTHERASSETSOURCES,
@NONPROFITAFFILIATIONINCLUDE,
@NONPROFITAFFILIATIONCONFIRMEDONLY,
@NONPROFITAFFILIATIONVALUEMULTIPLIERTYPECODE,
@NONPROFITAFFILIATIONVALUEMULTIPLIERCUTOFFVALUE,
@NONPROFITAFFILIATIONVALUEMULTIPLIER,
@NONPROFITAFFILIATIONVALUELESSTHANCUTOFFMULTIPLIER,
@NONPROFITAFFILIATIONVALUEGREATERTHANCUTOFFMULTIPLIER,
@NONPROFITAFFILIATIONVALUECODE,
@NONPROFITAFFILIATIONSOURCES,
@PRIVATEFOUNDATIONINCLUDE,
@PRIVATEFOUNDATIONCONFIRMEDONLY,
@PRIVATEFOUNDATIONVALUEMULTIPLIERTYPECODE,
@PRIVATEFOUNDATIONVALUEMULTIPLIERCUTOFFVALUE,
@PRIVATEFOUNDATIONVALUEMULTIPLIER,
@PRIVATEFOUNDATIONVALUELESSTHANCUTOFFMULTIPLIER,
@PRIVATEFOUNDATIONVALUEGREATERTHANCUTOFFMULTIPLIER,
@PRIVATEFOUNDATIONVALUECODE,
@PRIVATEFOUNDATIONSOURCES,
@OTHERSCANMODIFY,
@REALESTATEINCLUDEHISTORICAL,
@INCOMECOMPENSATIONINCLUDEHISTORICAL,
@PHILANTHROPICGIFTINCLUDE,
@PHILANTHROPICGIFTCONFIRMEDONLY,
@PHILANTHROPICGIFTVALUEMULTIPLIERTYPECODE,
@PHILANTHROPICGIFTVALUEMULTIPLIERCUTOFFVALUE,
@PHILANTHROPICGIFTVALUEMULTIPLIER,
@PHILANTHROPICGIFTVALUELESSTHANCUTOFFMULTIPLIER,
@PHILANTHROPICGIFTVALUEGREATERTHANCUTOFFMULTIPLIER,
@PHILANTHROPICGIFTVALUECODE,
@PHILANTHROPICGIFTSOURCES,
@POLITICALDONATIONINCLUDE,
@POLITICALDONATIONCONFIRMEDONLY,
@POLITICALDONATIONVALUEMULTIPLIERTYPECODE,
@POLITICALDONATIONVALUEMULTIPLIERCUTOFFVALUE,
@POLITICALDONATIONVALUEMULTIPLIER,
@POLITICALDONATIONVALUELESSTHANCUTOFFMULTIPLIER,
@POLITICALDONATIONVALUEGREATERTHANCUTOFFMULTIPLIER,
@POLITICALDONATIONVALUECODE,
@POLITICALDONATIONSOURCES,
@GIVINGTOMYORGINCLUDE,
@GIVINGTOMYORGVALUEMULTIPLIERTYPECODE,
@GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE,
@GIVINGTOMYORGVALUEMULTIPLIER,
@GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER,
@GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER,
@GIVINGTOMYORGVALUECODE;
return 0;