USP_DATAFORMTEMPLATE_EDITLOAD_BATCHMODELINGANDPROPENSITYUPDATEBATCHCOMMIT

The load procedure used by the edit dataform template "Modeling and Propensity Update Batch Row Commit Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@VALIDATEONLY	bit	INOUT	Validate only
@LOOKUP_ID	nvarchar(100)	INOUT	Constituent/Lookup ID
@KEYNAME	nvarchar(100)	INOUT	Last/org/group/household name
@FIRSTNAME	nvarchar(50)	INOUT	First name
@ANNUALGIFTLIKELIHOOD	smallint	INOUT	Annual giving likelihood
@ANNUITYLIKELIHOOD	smallint	INOUT	Annuity likelihood
@BEQUESTLIKELIHOOD	smallint	INOUT	Bequest likelihood
@CRTLIKELIHOOD	smallint	INOUT	CRT likelihood
@MAJORGIVINGLIKELIHOOD	smallint	INOUT	Major giving likelihood
@MEMBERSHIPLIKELIHOOD	smallint	INOUT	Membership likelihood
@ONLINEGIVINGLIKELIHOOD	smallint	INOUT	Online giving likelihood
@PATIENTRESPONSELIKELIHOOD	smallint	INOUT	Patient response likelihood
@PLANNEDGIFTLIKELIHOOD	smallint	INOUT	Planned giving likelihood
@SUGGESTEDMEMBERSHIPLEVELID	uniqueidentifier	INOUT	Suggested membership level ID
@SUGGESTEDMEMBERSHIPLEVELSCOREID	uniqueidentifier	INOUT	Suggested membership level score
@TARGETGIFTRANGEID	uniqueidentifier	INOUT	Target gift range ID
@TARGETGIFTRANGESCOREID	uniqueidentifier	INOUT	Target gift range score
@ANALYTICSPROJECTID	uniqueidentifier	INOUT
@ANALYTICSPROJECTREQUIRED	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHMODELINGANDPROPENSITYUPDATEBATCHCOMMIT(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @VALIDATEONLY bit = null output,
    @LOOKUP_ID nvarchar(100) = null output,
    @KEYNAME nvarchar(100) = null output,
    @FIRSTNAME nvarchar(50) = null output,
    @ANNUALGIFTLIKELIHOOD smallint = null output,
    @ANNUITYLIKELIHOOD smallint = null output,
    @BEQUESTLIKELIHOOD smallint = null output,
    @CRTLIKELIHOOD smallint = null output,
    @MAJORGIVINGLIKELIHOOD smallint = null output,
    @MEMBERSHIPLIKELIHOOD smallint = null output,
    @ONLINEGIVINGLIKELIHOOD smallint = null output,
    @PATIENTRESPONSELIKELIHOOD smallint = null output,
    @PLANNEDGIFTLIKELIHOOD smallint = null output,
    @SUGGESTEDMEMBERSHIPLEVELID uniqueidentifier = null output,
    @SUGGESTEDMEMBERSHIPLEVELSCOREID uniqueidentifier = null output,
    @TARGETGIFTRANGEID uniqueidentifier = null output,
    @TARGETGIFTRANGESCOREID uniqueidentifier = null output,
    @ANALYTICSPROJECTID uniqueidentifier = null output,
    @ANALYTICSPROJECTREQUIRED bit = null output
) as
set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    declare @USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITYUPDATEBATCHTEMPLATE_DATALOADED bit;
    declare @USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITYUPDATEBATCHTEMPLATE_TSLONG bigint;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITYUPDATEBATCHTEMPLATE @ID = @ID,
        @DATALOADED = @USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITYUPDATEBATCHTEMPLATE_DATALOADED output,
        @TSLONG = @USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITYUPDATEBATCHTEMPLATE_TSLONG output,
        @LOOKUP_ID = @LOOKUP_ID output, @KEYNAME = @KEYNAME output, @FIRSTNAME = @FIRSTNAME output, @ANNUALGIFTLIKELIHOOD = @ANNUALGIFTLIKELIHOOD output,
        @ANNUITYLIKELIHOOD = @ANNUITYLIKELIHOOD output, @BEQUESTLIKELIHOOD = @BEQUESTLIKELIHOOD output, @CRTLIKELIHOOD = @CRTLIKELIHOOD output,
        @MAJORGIVINGLIKELIHOOD = @MAJORGIVINGLIKELIHOOD output, @MEMBERSHIPLIKELIHOOD = @MEMBERSHIPLIKELIHOOD output,
        @ONLINEGIVINGLIKELIHOOD = @ONLINEGIVINGLIKELIHOOD output, @PATIENTRESPONSELIKELIHOOD = @PATIENTRESPONSELIKELIHOOD output,
        @PLANNEDGIFTLIKELIHOOD = @PLANNEDGIFTLIKELIHOOD output, @SUGGESTEDMEMBERSHIPLEVELID = @SUGGESTEDMEMBERSHIPLEVELID output,
        @TARGETGIFTRANGEID = @TARGETGIFTRANGEID output, @ANALYTICSPROJECTID = @ANALYTICSPROJECTID output, @VALIDATEONLY = @VALIDATEONLY output;

    set @SUGGESTEDMEMBERSHIPLEVELSCOREID = @SUGGESTEDMEMBERSHIPLEVELID
    set @TARGETGIFTRANGESCOREID = @TARGETGIFTRANGEID

    --bez WI 141661 nulls are treated as 0 from number smallint fields.  Since RP is already using -1 to represent blank\null values we are going to return those values when null values are returned

    set @ANNUALGIFTLIKELIHOOD = coalesce(@ANNUALGIFTLIKELIHOOD, -1)
    set @ANNUITYLIKELIHOOD = coalesce(@ANNUITYLIKELIHOOD, -1)
    set @BEQUESTLIKELIHOOD = coalesce(@BEQUESTLIKELIHOOD, -1)
    set @CRTLIKELIHOOD = coalesce(@CRTLIKELIHOOD, -1)
    set @MAJORGIVINGLIKELIHOOD = coalesce(@MAJORGIVINGLIKELIHOOD, -1)
    set @MEMBERSHIPLIKELIHOOD = coalesce(@MEMBERSHIPLIKELIHOOD, -1)
    set @ONLINEGIVINGLIKELIHOOD = coalesce(@ONLINEGIVINGLIKELIHOOD, -1)
    set @PATIENTRESPONSELIKELIHOOD = coalesce(@PATIENTRESPONSELIKELIHOOD, -1)
    set @PLANNEDGIFTLIKELIHOOD = coalesce(@PLANNEDGIFTLIKELIHOOD, -1)

    set @DATALOADED = @DATALOADED | @USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITYUPDATEBATCHTEMPLATE_DATALOADED;
    select @TSLONG = convert(bigint,((@TSLONG + @USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITYUPDATEBATCHTEMPLATE_TSLONG) + ABS(@TSLONG - @USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITYUPDATEBATCHTEMPLATE_TSLONG))/2);

return 0;