USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITYUPDATEBATCHTEMPLATE

The load procedure used by the edit dataform template "Modeling and Propensity Update Batch Template 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.
@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
@SUGGESTEDMEMBERSHIPLEVELSCORE	uniqueidentifier	INOUT	Suggested membership level score
@TARGETGIFTRANGEID	uniqueidentifier	INOUT	Target gift range ID
@TARGETGIFTRANGESCORE	uniqueidentifier	INOUT	Target gift range score
@ANALYTICSPROJECTID	uniqueidentifier	INOUT
@VALIDATEONLY	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITYUPDATEBATCHTEMPLATE(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 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,
    @SUGGESTEDMEMBERSHIPLEVELSCORE uniqueidentifier = null output,
    @TARGETGIFTRANGEID uniqueidentifier = null output,
    @TARGETGIFTRANGESCORE uniqueidentifier = null output,
    @ANALYTICSPROJECTID uniqueidentifier = null output,
    @VALIDATEONLY bit = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows
    set @DATALOADED = 0
    set @TSLONG = 0

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.  Also note that we fetch the TSLONG so that concurrency
    -- can be considered.
    select
        @TSLONG = MP.TSLONG,
        @ANNUALGIFTLIKELIHOOD = MP.ANNUALGIFTLIKELIHOOD,
        @ANNUITYLIKELIHOOD = MP.ANNUITYLIKELIHOOD,
        @BEQUESTLIKELIHOOD = MP.BEQUESTLIKELIHOOD,
        @CRTLIKELIHOOD = MP.CRTLIKELIHOOD,
        @MAJORGIVINGLIKELIHOOD = MP.MAJORGIVINGLIKELIHOOD,
        @MEMBERSHIPLIKELIHOOD = MP.MEMBERSHIPLIKELIHOOD,
        @ONLINEGIVINGLIKELIHOOD = MP.ONLINEGIVINGLIKELIHOOD,
        @PATIENTRESPONSELIKELIHOOD = MP.PATIENTRESPONSELIKELIHOOD,
        @PLANNEDGIFTLIKELIHOOD = MP.PLANNEDGIFTLIKELIHOOD,
        @SUGGESTEDMEMBERSHIPLEVELID = MP.SUGGESTEDMEMBERSHIPLEVELID,
        @SUGGESTEDMEMBERSHIPLEVELSCORE = MP.SUGGESTEDMEMBERSHIPLEVELID,
        @TARGETGIFTRANGEID = MP.TARGETGIFTRANGEID,
        @TARGETGIFTRANGESCORE = MP.TARGETGIFTRANGEID
    from
        dbo.MODELINGANDPROPENSITY MP
    where 
        MP.ID = @ID

    select
        @DATALOADED = 1,
        @LOOKUP_ID = C.LOOKUPID,
        @KEYNAME = C.KEYNAME,
        @FIRSTNAME = C.FIRSTNAME
    from
        dbo.CONSTITUENT C
    where
        C.ID = @ID

    return 0;