USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITY_SIMPLE

The load procedure used by the edit dataform template "Simple Modeling and Propensity 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.
@ANNUALGIFTLIKELIHOOD	smallint	INOUT	Annual gift likelihood
@ANNUITYLIKELIHOOD	smallint	INOUT	Annuity likelihood
@BEQUESTLIKELIHOOD	smallint	INOUT	Bequest likelihood
@CRTLIKELIHOOD	smallint	INOUT	CRT likelihood
@MAJORGIVINGLIKELIHOOD	smallint	INOUT	Major giving likelihood
@PLANNEDGIFTLIKELIHOOD	smallint	INOUT	Planned gift likelihood
@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.

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MODELINGANDPROPENSITY_SIMPLE (
                        @ID                        uniqueidentifier,
                        @DATALOADED                bit =        0 output,
                        @ANNUALGIFTLIKELIHOOD    smallint =  null output,
                        @ANNUITYLIKELIHOOD        smallint =    null output,
                        @BEQUESTLIKELIHOOD        smallint =    null output,
                        @CRTLIKELIHOOD            smallint =    null output,
                        @MAJORGIVINGLIKELIHOOD    smallint =    null output,
                        @PLANNEDGIFTLIKELIHOOD    smallint =    null output,
                        @TSLONG                    bigint =    0 output
                    ) as
                        set nocount on;

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

                        select
                            @DATALOADED = 1,
                            @ANNUALGIFTLIKELIHOOD =        MODELINGANDPROPENSITY.ANNUALGIFTLIKELIHOOD,
                            @ANNUITYLIKELIHOOD =        MODELINGANDPROPENSITY.ANNUITYLIKELIHOOD,
                            @BEQUESTLIKELIHOOD =        MODELINGANDPROPENSITY.BEQUESTLIKELIHOOD,
                            @CRTLIKELIHOOD =            MODELINGANDPROPENSITY.CRTLIKELIHOOD,
                            @MAJORGIVINGLIKELIHOOD =    MODELINGANDPROPENSITY.MAJORGIVINGLIKELIHOOD,
                            @PLANNEDGIFTLIKELIHOOD =    MODELINGANDPROPENSITY.PLANNEDGIFTLIKELIHOOD,
                            @TSLONG =                    MODELINGANDPROPENSITY.TSLONG
                        from
                            dbo.CONSTITUENT
                        left join dbo.MODELINGANDPROPENSITY
                            on MODELINGANDPROPENSITY.ID = CONSTITUENT.ID
                        where
                            CONSTITUENT.ID=@ID;

                        set @ANNUALGIFTLIKELIHOOD =        case when @ANNUALGIFTLIKELIHOOD  = -1 then null else @ANNUALGIFTLIKELIHOOD end;
                        set @ANNUITYLIKELIHOOD =        case when @ANNUITYLIKELIHOOD     = -1 then null else @ANNUITYLIKELIHOOD end;                                  
                        set @BEQUESTLIKELIHOOD =        case when @BEQUESTLIKELIHOOD     = -1 then null else @BEQUESTLIKELIHOOD end;
                        set @CRTLIKELIHOOD =            case when @CRTLIKELIHOOD         = -1 then null else @CRTLIKELIHOOD end;
                        set @MAJORGIVINGLIKELIHOOD =    case when @MAJORGIVINGLIKELIHOOD = -1 then null else @MAJORGIVINGLIKELIHOOD end;
                        set @PLANNEDGIFTLIKELIHOOD =    case when @PLANNEDGIFTLIKELIHOOD = -1 then null else @PLANNEDGIFTLIKELIHOOD end;

                        return 0;