USP_BBAWEALTHESTIMATORRATINGSFILEIMPORT_INSERT

This procedure is used by the Target Analytics Wealth Estimator Ratings File Import Record Operation for saving the information from a Target Analytics Target Gift Ranges Import File to the database.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@SCORE	int	IN
@VALUERANGE	nvarchar(50)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@MINIMUMAMOUNT	money	IN

Definition

Copy



            create procedure dbo.USP_BBAWEALTHESTIMATORRATINGSFILEIMPORT_INSERT (
                @ID uniqueidentifier,
                @SCORE int,
                @VALUERANGE nvarchar(50),
                @CHANGEAGENTID uniqueidentifier,
                @MINIMUMAMOUNT money = 0
            ) as
                set nocount on;

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

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

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

                    insert into dbo.WEALTHESTIMATORRATING (
                        ID,
                        SCORE,
                        RANGE,
                        MINIMUMAMOUNT,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    )
                    values (
                        @ID,
                        @SCORE,
                        @VALUERANGE,
                        @MINIMUMAMOUNT,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE
                    );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;