USP_DATAFORMTEMPLATE_EDIT_BATCHMODELINGANDPROPENSITYUPDATEBATCHROW_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SEQUENCE	int	IN
@PRIMARYRECORDID	uniqueidentifier	IN
@LOOKUP_ID	nvarchar(100)	IN
@KEYNAME	nvarchar(100)	IN
@FIRSTNAME	nvarchar(50)	IN
@ANNUALGIFTLIKELIHOOD	smallint	IN
@ANNUITYLIKELIHOOD	smallint	IN
@BEQUESTLIKELIHOOD	smallint	IN
@CRTLIKELIHOOD	smallint	IN
@MAJORGIVINGLIKELIHOOD	smallint	IN
@MEMBERSHIPLIKELIHOOD	smallint	IN
@ONLINEGIVINGLIKELIHOOD	smallint	IN
@PATIENTRESPONSELIKELIHOOD	smallint	IN
@PLANNEDGIFTLIKELIHOOD	smallint	IN
@SUGGESTEDMEMBERSHIPLEVELID	uniqueidentifier	IN
@SUGGESTEDMEMBERSHIPLEVELSCOREID	uniqueidentifier	IN
@TARGETGIFTRANGEID	uniqueidentifier	IN
@TARGETGIFTRANGESCOREID	uniqueidentifier	IN
@ANALYTICSPROJECTID	uniqueidentifier	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHMODELINGANDPROPENSITYUPDATEBATCHROW_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SEQUENCE int,
    @PRIMARYRECORDID uniqueidentifier,
    @LOOKUP_ID nvarchar(100),
    @KEYNAME nvarchar(100),
    @FIRSTNAME nvarchar(50),
    @ANNUALGIFTLIKELIHOOD smallint,
    @ANNUITYLIKELIHOOD smallint,
    @BEQUESTLIKELIHOOD smallint,
    @CRTLIKELIHOOD smallint,
    @MAJORGIVINGLIKELIHOOD smallint,
    @MEMBERSHIPLIKELIHOOD smallint,
    @ONLINEGIVINGLIKELIHOOD smallint,
    @PATIENTRESPONSELIKELIHOOD smallint,
    @PLANNEDGIFTLIKELIHOOD smallint,
    @SUGGESTEDMEMBERSHIPLEVELID uniqueidentifier,
    @SUGGESTEDMEMBERSHIPLEVELSCOREID uniqueidentifier,
    @TARGETGIFTRANGEID uniqueidentifier,
    @TARGETGIFTRANGESCOREID uniqueidentifier,
    @ANALYTICSPROJECTID uniqueidentifier
) as
set nocount on;

declare @CURRENTDATE datetime;

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

set @CURRENTDATE = getdate();

if @SUGGESTEDMEMBERSHIPLEVELSCOREID is not null
    set @SUGGESTEDMEMBERSHIPLEVELID = @SUGGESTEDMEMBERSHIPLEVELSCOREID
else
    set @SUGGESTEDMEMBERSHIPLEVELSCOREID = @SUGGESTEDMEMBERSHIPLEVELID

if @TARGETGIFTRANGESCOREID is not null
    set @TARGETGIFTRANGEID = @TARGETGIFTRANGESCOREID
else
    set @TARGETGIFTRANGESCOREID = @TARGETGIFTRANGEID

begin try
update dbo.BATCHMODELINGANDPROPENSITYUPDATE
    set [SEQUENCE] = @SEQUENCE,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE,
        [PRIMARYRECORDID] = @PRIMARYRECORDID,
        [LOOKUP_ID] = coalesce(@LOOKUP_ID, LOOKUP_ID),
        [KEYNAME] = coalesce(@KEYNAME, KEYNAME),
        [FIRSTNAME] = coalesce(@FIRSTNAME, FIRSTNAME),
        [ANNUALGIFTLIKELIHOOD] = coalesce(nullif(@ANNUALGIFTLIKELIHOOD, -1), nullif(ANNUALGIFTLIKELIHOOD, -1), (select ANNUALGIFTLIKELIHOOD from dbo.MODELINGANDPROPENSITY where ID = @PRIMARYRECORDID), -1),
        [ANNUITYLIKELIHOOD] = coalesce(nullif(@ANNUITYLIKELIHOOD, -1), nullif(ANNUITYLIKELIHOOD, -1), (select ANNUITYLIKELIHOOD from dbo.MODELINGANDPROPENSITY where ID = @PRIMARYRECORDID), -1),
        [BEQUESTLIKELIHOOD] = coalesce(nullif(@BEQUESTLIKELIHOOD, -1), nullif(BEQUESTLIKELIHOOD, -1), (select BEQUESTLIKELIHOOD from dbo.MODELINGANDPROPENSITY where ID = @PRIMARYRECORDID), -1),
        [CRTLIKELIHOOD] = coalesce(nullif(@CRTLIKELIHOOD, -1), nullif(CRTLIKELIHOOD, -1), (select CRTLIKELIHOOD from dbo.MODELINGANDPROPENSITY where ID = @PRIMARYRECORDID), -1),
        [MAJORGIVINGLIKELIHOOD] = coalesce(nullif(@MAJORGIVINGLIKELIHOOD, -1), nullif(MAJORGIVINGLIKELIHOOD, -1), (select MAJORGIVINGLIKELIHOOD from dbo.MODELINGANDPROPENSITY where ID = @PRIMARYRECORDID), -1),
        [MEMBERSHIPLIKELIHOOD] = coalesce(nullif(@MEMBERSHIPLIKELIHOOD, -1), nullif(MEMBERSHIPLIKELIHOOD, -1), (select MEMBERSHIPLIKELIHOOD from dbo.MODELINGANDPROPENSITY where ID = @PRIMARYRECORDID), -1),
        [ONLINEGIVINGLIKELIHOOD] = coalesce(nullif(@ONLINEGIVINGLIKELIHOOD, -1), nullif(ONLINEGIVINGLIKELIHOOD, -1), (select ONLINEGIVINGLIKELIHOOD from dbo.MODELINGANDPROPENSITY where ID = @PRIMARYRECORDID), -1),
        [PATIENTRESPONSELIKELIHOOD] = coalesce(nullif(@PATIENTRESPONSELIKELIHOOD, -1), nullif(PATIENTRESPONSELIKELIHOOD, -1), (select PATIENTRESPONSELIKELIHOOD from dbo.MODELINGANDPROPENSITY where ID = @PRIMARYRECORDID), -1),
        [PLANNEDGIFTLIKELIHOOD] = coalesce(nullif(@PLANNEDGIFTLIKELIHOOD, -1), nullif(PLANNEDGIFTLIKELIHOOD, -1), (select PLANNEDGIFTLIKELIHOOD from dbo.MODELINGANDPROPENSITY where ID = @PRIMARYRECORDID), -1),
        [SUGGESTEDMEMBERSHIPLEVELID] = coalesce(@SUGGESTEDMEMBERSHIPLEVELID, SUGGESTEDMEMBERSHIPLEVELID),
        [SUGGESTEDMEMBERSHIPLEVELSCOREID] = coalesce(@SUGGESTEDMEMBERSHIPLEVELSCOREID, SUGGESTEDMEMBERSHIPLEVELID),
        [TARGETGIFTRANGEID] = coalesce(@TARGETGIFTRANGEID, TARGETGIFTRANGEID),
        [TARGETGIFTRANGESCOREID] = coalesce(@TARGETGIFTRANGESCOREID, TARGETGIFTRANGEID),
        [ANALYTICSPROJECTID] = @ANALYTICSPROJECTID
    where
        ID = @ID
end try
begin catch
    exec.dbo.USP_RAISE_ERROR;
    return 1;
end catch

return 0;