USP_DATAFORMTEMPLATE_EDITLOAD_BATCHMODELINGANDPROPENSITYUPDATEBATCHROW

The load procedure used by the edit dataform template "Modeling and Propensity Update Batch Row 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.
@SEQUENCE	int	INOUT	Sequence
@PRIMARYRECORDID	uniqueidentifier	INOUT	Constituent
@LOOKUP_ID	nvarchar(100)	INOUT	Lookup ID
@KEYNAME	nvarchar(100)	INOUT	Last 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 range
@SUGGESTEDMEMBERSHIPLEVELSCOREID	uniqueidentifier	INOUT	Suggested membership level score
@TARGETGIFTRANGEID	uniqueidentifier	INOUT	Target gift range
@TARGETGIFTRANGESCOREID	uniqueidentifier	INOUT	Target gift range score
@ANALYTICSPROJECTID	uniqueidentifier	INOUT
@ANALYTICSPROJECTREQUIRED	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHMODELINGANDPROPENSITYUPDATEBATCHROW(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @SEQUENCE int = null output,
    @PRIMARYRECORDID uniqueidentifier = 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;

select
    @DATALOADED = 1,
    @TSLONG = [TSLONG],
    @SEQUENCE = [SEQUENCE],
    @PRIMARYRECORDID = [PRIMARYRECORDID],
    @LOOKUP_ID = [LOOKUP_ID],
    @KEYNAME = [KEYNAME],
    @FIRSTNAME = [FIRSTNAME],
    @ANNUALGIFTLIKELIHOOD = [ANNUALGIFTLIKELIHOOD],
    @ANNUITYLIKELIHOOD = [ANNUITYLIKELIHOOD],
    @BEQUESTLIKELIHOOD = [BEQUESTLIKELIHOOD],
    @CRTLIKELIHOOD = [CRTLIKELIHOOD],
    @MAJORGIVINGLIKELIHOOD = [MAJORGIVINGLIKELIHOOD],
    @MEMBERSHIPLIKELIHOOD = [MEMBERSHIPLIKELIHOOD],
    @ONLINEGIVINGLIKELIHOOD = [ONLINEGIVINGLIKELIHOOD],
    @PATIENTRESPONSELIKELIHOOD = [PATIENTRESPONSELIKELIHOOD],
    @PLANNEDGIFTLIKELIHOOD = [PLANNEDGIFTLIKELIHOOD],
    @SUGGESTEDMEMBERSHIPLEVELID = [SUGGESTEDMEMBERSHIPLEVELID],
    @SUGGESTEDMEMBERSHIPLEVELSCOREID = [SUGGESTEDMEMBERSHIPLEVELID],
    @TARGETGIFTRANGEID = [TARGETGIFTRANGEID],
    @TARGETGIFTRANGESCOREID = [TARGETGIFTRANGEID],
    @ANALYTICSPROJECTID = [ANALYTICSPROJECTID]
from
    dbo.BATCHMODELINGANDPROPENSITYUPDATE
where
    BATCHMODELINGANDPROPENSITYUPDATE.ID = @ID;

return 0;