USP_DATAFORMTEMPLATE_VIEW_REVENUELIFECYCLECRITERIASUMMARY

The load procedure used by the view dataform template "Donor Lifecycle Revenue Criteria Summary"

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.
@CONSIDERRECOGNITION	bit	INOUT	CONSIDERRECOGNITION
@SCHEDULEFREQUENCY	int	INOUT	SCHEDULEFREQUENCY
@SCHEDULEMODIFIED	bit	INOUT	SCHEDULEMODIFIED

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REVENUELIFECYCLECRITERIASUMMARY
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CONSIDERRECOGNITION bit = null output,
    @SCHEDULEFREQUENCY int = null output, 
    @SCHEDULEMODIFIED bit = null output
)
as
    set nocount on;    
    set @DATALOADED = 0;

    declare @BUSINESSPROCESSID uniqueidentifier = (select top 1 ID from dbo.REVENUELIFECYCLEPROCESS)

    select 
        @DATALOADED = 1,
        @CONSIDERRECOGNITION = CONSIDERRECOGNITION,
        @SCHEDULEMODIFIED = dbo.UFN_REVENUELIFECYCLE_SCHEDULEMODIFIED(@BUSINESSPROCESSID),
        @SCHEDULEFREQUENCY = isnull((select top 1 sysschedules.freq_type --weekly = 8 daily = 1

                                                    from 
                                                        msdb.dbo.sysschedules 
                                                        inner join msdb.dbo.sysjobschedules on sysschedules.schedule_id = sysjobschedules.schedule_id
                                                        inner join msdb.dbo.sysjobsteps on sysjobschedules.job_id = sysjobsteps.job_id
                                                        inner join msdb.dbo.sysjobs on sysjobschedules.job_id = sysjobs.job_id
                                                        inner join msdb.dbo.sysproxies on sysjobsteps.proxy_id = sysproxies.proxy_id
                                                    where 
                                                        sysjobsteps.subsystem = 'ActiveScripting' and 
                                                        sysproxies.name = 'Blackbaud ActiveX Proxy - ' + db_name() and 
                                                        sysjobsteps.step_name = 'Business process invoke' and 
                                                        (null is null or sysjobsteps.command like '%DatabaseName=' + null + '&%') and 
                                                        sysjobsteps.command like '%' + cast(@BUSINESSPROCESSID as nvarchar(36)) + '%'), 0)
    from 
        dbo.REVENUELIFECYCLECRITERIA
    where
        ID = @ID;

    return 0;