USP_DATAFORMTEMPLATE_VIEW_MODELSCORESANDRATINGSCURRENTVALUESUPDATEBATCH

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@ANNUALGIFTLIKELIHOOD	int	INOUT
@ANNUITYLIKELIHOOD	int	INOUT
@BEQUESTLIKELIHOOD	int	INOUT
@CRTLIKELIHOOD	int	INOUT
@MAJORGIVINGLIKELIHOOD	int	INOUT
@MEMBERSHIPLIKELIHOOD	int	INOUT
@ONLINEGIVINGLIKELIHOOD	int	INOUT
@PATIENTRESPONSELIKELIHOOD	int	INOUT
@PLANNEDGIFTLIKELIHOOD	int	INOUT
@SUGGESTEDMEMBERSHIPLEVELID	uniqueidentifier	INOUT
@TARGETGIFTRANGEID	uniqueidentifier	INOUT
@WEALTHESTIMATORRATINGID	uniqueidentifier	INOUT

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MODELSCORESANDRATINGSCURRENTVALUESUPDATEBATCH
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ANNUALGIFTLIKELIHOOD int = null output,
    @ANNUITYLIKELIHOOD int = null output,
    @BEQUESTLIKELIHOOD int = null output,
    @CRTLIKELIHOOD int = null output,
    @MAJORGIVINGLIKELIHOOD int = null output,
    @MEMBERSHIPLIKELIHOOD int = null output,
    @ONLINEGIVINGLIKELIHOOD int = null output,
    @PATIENTRESPONSELIKELIHOOD int = null output,
    @PLANNEDGIFTLIKELIHOOD int = null output,
    @SUGGESTEDMEMBERSHIPLEVELID uniqueidentifier = null output,
    @TARGETGIFTRANGEID uniqueidentifier = null output,
    @WEALTHESTIMATORRATINGID uniqueidentifier = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @ANNUALGIFTLIKELIHOOD = ANNUALGIFTLIKELIHOOD,
        @ANNUITYLIKELIHOOD = ANNUITYLIKELIHOOD,
        @BEQUESTLIKELIHOOD = BEQUESTLIKELIHOOD,
        @CRTLIKELIHOOD = CRTLIKELIHOOD,
        @MAJORGIVINGLIKELIHOOD = MAJORGIVINGLIKELIHOOD,
        @MEMBERSHIPLIKELIHOOD = MEMBERSHIPLIKELIHOOD,
        @ONLINEGIVINGLIKELIHOOD = ONLINEGIVINGLIKELIHOOD,
        @PATIENTRESPONSELIKELIHOOD = PATIENTRESPONSELIKELIHOOD,
        @PLANNEDGIFTLIKELIHOOD = PLANNEDGIFTLIKELIHOOD,
        @SUGGESTEDMEMBERSHIPLEVELID = SUGGESTEDMEMBERSHIPLEVELID,
        @TARGETGIFTRANGEID = TARGETGIFTRANGEID,
        @WEALTHESTIMATORRATINGID = WEALTHESTIMATORRATINGID
    from
        dbo.MODELINGANDPROPENSITY
    where
        ID = @ID;

    return 0;