USP_DATAFORMTEMPLATE_ADD_MODELINGANDPROPENSITYCOMMITRATING

The save procedure used by the add dataform template "Modeling and Propensity Ratings Commit Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@IMPORTID	nvarchar(36)	IN	Constituent
@ANNUALGIFTLIKELIHOOD	smallint	IN	Annual giving likelihood
@ANNUITYLIKELIHOOD	smallint	IN	Annuity likelihood
@BEQUESTLIKELIHOOD	smallint	IN	Bequest likelihood
@CRTLIKELIHOOD	smallint	IN	CRT likelihood
@MAJORGIVINGLIKELIHOOD	smallint	IN	Major giving likelihood
@PLANNEDGIFTLIKELIHOOD	smallint	IN	Planned giving likelihood
@VALIDATEONLY	bit	IN	Validate only
@PATIENTRESPONSELIKELIHOOD	smallint	IN	Patient response likelihood
@WPSCREENINGINDICATOR	nvarchar(1)	IN	WealthPoint screening indicator
@ANALYTICSPROJECTID	uniqueidentifier	IN

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MODELINGANDPROPENSITYCOMMITRATING(
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @IMPORTID nvarchar(36),
                        @ANNUALGIFTLIKELIHOOD smallint = -1,
                        @ANNUITYLIKELIHOOD smallint = -1,
                        @BEQUESTLIKELIHOOD smallint = -1,
                        @CRTLIKELIHOOD smallint = -1,
                        @MAJORGIVINGLIKELIHOOD smallint = -1,
                        @PLANNEDGIFTLIKELIHOOD smallint = -1,
                        @VALIDATEONLY bit = null,
                        @PATIENTRESPONSELIKELIHOOD smallint = -1,
                        @WPSCREENINGINDICATOR nvarchar(1) = '',
                        @ANALYTICSPROJECTID uniqueidentifier = null
                    ) as

                        set nocount on;

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

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

                        begin try
                            if @VALIDATEONLY = 0
                            begin
                                if (exists(select 1 from dbo.MODELINGANDPROPENSITY where ID=@IMPORTID))
                                begin
                                    update dbo.MODELINGANDPROPENSITY set
                                        ANNUALGIFTLIKELIHOOD = @ANNUALGIFTLIKELIHOOD,
                                        ANNUITYLIKELIHOOD = @ANNUITYLIKELIHOOD,
                                        BEQUESTLIKELIHOOD = @BEQUESTLIKELIHOOD,
                                        CRTLIKELIHOOD = @CRTLIKELIHOOD,
                                        MAJORGIVINGLIKELIHOOD = @MAJORGIVINGLIKELIHOOD,
                                        PLANNEDGIFTLIKELIHOOD = @PLANNEDGIFTLIKELIHOOD,
                                        PATIENTRESPONSELIKELIHOOD = @PATIENTRESPONSELIKELIHOOD,
                                        WPSCREENINGINDICATOR = @WPSCREENINGINDICATOR,
                                        DATECHANGED = @CURRENTDATE,
                                        CHANGEDBYID = @CHANGEAGENTID
                                    where 
                                        ID = @IMPORTID;
                                end
                                else begin
                                    insert into dbo.MODELINGANDPROPENSITY
                                    (
                                        ID,
                                        ANNUALGIFTLIKELIHOOD,
                                        ANNUITYLIKELIHOOD,
                                        BEQUESTLIKELIHOOD,
                                        CRTLIKELIHOOD,
                                        MAJORGIVINGLIKELIHOOD,
                                        PLANNEDGIFTLIKELIHOOD,
                                        PATIENTRESPONSELIKELIHOOD,
                                        WPSCREENINGINDICATOR,
                                        ADDEDBYID,
                                        CHANGEDBYID,
                                        DATEADDED,
                                        DATECHANGED
                                    )
                                    values
                                    (
                                        @IMPORTID,
                                        @ANNUALGIFTLIKELIHOOD,
                                        @ANNUITYLIKELIHOOD,
                                        @BEQUESTLIKELIHOOD,
                                        @CRTLIKELIHOOD,
                                        @MAJORGIVINGLIKELIHOOD,
                                        @PLANNEDGIFTLIKELIHOOD,
                                        @PATIENTRESPONSELIKELIHOOD,
                                        @WPSCREENINGINDICATOR,
                                        @CHANGEAGENTID,
                                        @CHANGEAGENTID,
                                        @CURRENTDATE,
                                        @CURRENTDATE
                                    );
                                end

                                exec dbo.USP_MODELINGANDPROPENSITYDELIVERY_SYNCHRONIZE @IMPORTID, @ANALYTICSPROJECTID, @ANNUALGIFTLIKELIHOOD, @ANNUITYLIKELIHOOD,
                                    @BEQUESTLIKELIHOOD, @CRTLIKELIHOOD, @MAJORGIVINGLIKELIHOOD, null, null,
                                    @PATIENTRESPONSELIKELIHOOD, @PLANNEDGIFTLIKELIHOOD, null, null, null, null;
                                    --these are used in the Model Scores and Ratings Update batch
                                    --@MEMBERSHIPLIKELIHOOD, @ONLINEGIVINGLIKELIHOOD, @SUGGESTEDMEMBERSHIPLEVELID, @NCOAMOVEDINDICATOR, @TARGETGIFTRANGEID, @WEALTHESTIMATORRATINGID
                                    --,@WPSCREENINGINDICATOR --not used right now

                                set @ID = @IMPORTID;
                            end
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                        return 0;