USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITYFORMULA_4

Parameters

Parameter	Parameter Type	Mode
@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
@PHILANTHROPICGIFTINCLUDE	bit	IN
@PHILANTHROPICGIFTCONFIRMEDONLY	bit	IN
@PHILANTHROPICGIFTVALUEMULTIPLIERTYPECODE	tinyint	IN
@PHILANTHROPICGIFTVALUEMULTIPLIERCUTOFFVALUE	money	IN
@PHILANTHROPICGIFTVALUEMULTIPLIER	decimal(20, 4)	IN
@PHILANTHROPICGIFTVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	IN
@PHILANTHROPICGIFTVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	IN
@PHILANTHROPICGIFTVALUECODE	tinyint	IN
@PHILANTHROPICGIFTSOURCES	xml	IN
@POLITICALDONATIONINCLUDE	bit	IN
@POLITICALDONATIONCONFIRMEDONLY	bit	IN
@POLITICALDONATIONVALUEMULTIPLIERTYPECODE	tinyint	IN
@POLITICALDONATIONVALUEMULTIPLIERCUTOFFVALUE	money	IN
@POLITICALDONATIONVALUEMULTIPLIER	decimal(20, 4)	IN
@POLITICALDONATIONVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	IN
@POLITICALDONATIONVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	IN
@POLITICALDONATIONVALUECODE	tinyint	IN
@POLITICALDONATIONSOURCES	xml	IN
@GIVINGTOMYORGINCLUDE	bit	IN
@GIVINGTOMYORGVALUEMULTIPLIERTYPECODE	tinyint	IN
@GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE	money	IN
@GIVINGTOMYORGVALUEMULTIPLIER	decimal(20, 4)	IN
@GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER	decimal(20, 4)	IN
@GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER	decimal(20, 4)	IN
@GIVINGTOMYORGVALUECODE	tinyint	IN

Definition

Copy



                    create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITYFORMULA_4 (
                        @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,

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

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

                        @GIVINGTOMYORGINCLUDE bit,
                        @GIVINGTOMYORGVALUEMULTIPLIERTYPECODE tinyint,
                        @GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE money,
                        @GIVINGTOMYORGVALUEMULTIPLIER decimal(20,4),
                        @GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER decimal(20,4),
                        @GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER decimal(20,4),
                        @GIVINGTOMYORGVALUECODE tinyint
                    ) with execute as owner as
                        set nocount on;

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                        if @ID is null
                            set @ID = newid();

                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;


                        declare @USERCANMODIFY bit;
                        declare @OLDISDEFAULT bit;
                        declare @OLDOTHERSCANMODIFY bit;
                        declare @OWNERID uniqueidentifier;
                        set @USERCANMODIFY = 0;

                        select
                            @OLDISDEFAULT = WCF.ISDEFAULT,
                            @OLDOTHERSCANMODIFY = WCF.OTHERSCANMODIFY,
                            @OWNERID = case when WCF.OWNERID is null then @CURRENTAPPUSERID else WCF.OWNERID end
                        from
                            dbo.WEALTHCAPACITYFORMULA WCF
                        where
                            WCF.ID = @ID;

                        select
                            @USERCANMODIFY = 1
                        from
                            dbo.WEALTHCAPACITYFORMULA WCF
                        where
                            WCF.ID = @ID and
                            (WCF.OTHERSCANMODIFY = 1 or
                             WCF.OWNERID = @CURRENTAPPUSERID or
                             WCF.OWNERID is null or
                             dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1);

                        if @USERCANMODIFY <> 1 begin
                            raiserror ('ERR_WEALTHCAPACITYFORMULA_CANNOTMODIFY',13,1);
                            return 0;
                        end

                        if @ISDEFAULT = 0 and @OLDISDEFAULT = 1 begin
                            set @USERCANMODIFY = 0;
                            raiserror ('ERR_WEALTHCAPACITYFORMULA_DEFAULTCANNOTBEREMOVED',13,1);
                            return 0;
                        end

                        if @OTHERSCANMODIFY <> @OLDOTHERSCANMODIFY and @CURRENTAPPUSERID <> @OWNERID and dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) <> 1 begin
                            set @USERCANMODIFY = 0;
                            raiserror ('ERR_WEALTHCAPACITYFORMULA_NONOWNERCANNOTCHANGEOTHERSCANMODIFY',13,1);
                            return 0;
                        end                        

                        begin try
                            if @USERCANMODIFY = 1 begin
                                if @ISDEFAULT = 1 begin
                                    update
                                        dbo.WEALTHCAPACITYFORMULA 
                                    set
                                        ISDEFAULT = 0,
                                        DATECHANGED = @CURRENTDATE,
                                        CHANGEDBYID = @CHANGEAGENTID
                                    where
                                        ID <> @ID and
                                        ISDEFAULT = 1;
                                end

                                update
                                    dbo.WEALTHCAPACITYFORMULA 
                                set
                                    NAME = @NAME,
                                    DESCRIPTION = @DESCRIPTION,
                                    ISDEFAULT = @ISDEFAULT,

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

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

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

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

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

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

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

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

                                    OWNERID = @OWNERID,
                                    OTHERSCANMODIFY = @OTHERSCANMODIFY,
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE,

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

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

                                    GIVINGTOMYORGINCLUDE = @GIVINGTOMYORGINCLUDE,
                                    GIVINGTOMYORGVALUEMULTIPLIERTYPECODE = @GIVINGTOMYORGVALUEMULTIPLIERTYPECODE,
                                    GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE = @GIVINGTOMYORGVALUEMULTIPLIERCUTOFFVALUE,
                                    GIVINGTOMYORGVALUEMULTIPLIER = @GIVINGTOMYORGVALUEMULTIPLIER,
                                    GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER = @GIVINGTOMYORGVALUELESSTHANCUTOFFMULTIPLIER,
                                    GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER = @GIVINGTOMYORGVALUEGREATERTHANCUTOFFMULTIPLIER,
                                    GIVINGTOMYORGVALUECODE = @GIVINGTOMYORGVALUECODE
                                where
                                    ID = @ID;

                                exec dbo.USP_WEALTHCAPACITYFORMULA_REALESTATE_GETSOURCES_UPDATEFROMXML @ID, @REALESTATESOURCES, @CHANGEAGENTID, @CURRENTDATE;        
                                exec dbo.USP_WEALTHCAPACITYFORMULA_SECURITIES_GETSOURCES_UPDATEFROMXML @ID, @SECURITIESSOURCES, @CHANGEAGENTID, @CURRENTDATE;    
                                exec dbo.USP_WEALTHCAPACITYFORMULA_INCOMECOMPENSATION_GETSOURCES_UPDATEFROMXML @ID, @INCOMECOMPENSATIONSOURCES, @CHANGEAGENTID, @CURRENTDATE;    
                                exec dbo.USP_WEALTHCAPACITYFORMULA_NONPROFITAFFILIATION_GETSOURCES_UPDATEFROMXML @ID, @NONPROFITAFFILIATIONSOURCES, @CHANGEAGENTID, @CURRENTDATE;    
                                exec dbo.USP_WEALTHCAPACITYFORMULA_OTHERASSET_GETSOURCES_UPDATEFROMXML @ID, @OTHERASSETSOURCES, @CHANGEAGENTID, @CURRENTDATE;    
                                exec dbo.USP_WEALTHCAPACITYFORMULA_PRIVATEFOUNDATION_GETSOURCES_UPDATEFROMXML @ID, @PRIVATEFOUNDATIONSOURCES, @CHANGEAGENTID, @CURRENTDATE;    
                                exec dbo.USP_WEALTHCAPACITYFORMULA_BUSINESSOWNERSHIP_GETSOURCES_UPDATEFROMXML @ID, @BUSINESSOWNERSHIPSOURCES, @CHANGEAGENTID, @CURRENTDATE;
                                exec dbo.USP_WEALTHCAPACITYFORMULA_PHILANTHROPICGIFT_GETSOURCES_UPDATEFROMXML @ID, @PHILANTHROPICGIFTSOURCES, @CHANGEAGENTID, @CURRENTDATE;
                                exec dbo.USP_WEALTHCAPACITYFORMULA_POLITICALDONATION_GETSOURCES_UPDATEFROMXML @ID, @POLITICALDONATIONSOURCES, @CHANGEAGENTID, @CURRENTDATE;
                            end
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                        return 0;