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;