USP_DATAFORMTEMPLATE_VIEW_MODELINGANDPROPENSITY_SIMPLE

The load procedure used by the view dataform template "Simple Modeling and Propensity View 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

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_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
                ) as 
                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @ANNUALGIFTLIKELIHOOD =        MODELINGANDPROPENSITY.ANNUALGIFTLIKELIHOOD,
                        @ANNUITYLIKELIHOOD =        MODELINGANDPROPENSITY.ANNUITYLIKELIHOOD,
                        @BEQUESTLIKELIHOOD =        MODELINGANDPROPENSITY.BEQUESTLIKELIHOOD,
                        @CRTLIKELIHOOD =            MODELINGANDPROPENSITY.CRTLIKELIHOOD,
                        @MAJORGIVINGLIKELIHOOD =    MODELINGANDPROPENSITY.MAJORGIVINGLIKELIHOOD,
                        @PLANNEDGIFTLIKELIHOOD =    MODELINGANDPROPENSITY.PLANNEDGIFTLIKELIHOOD
                    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;