USP_DATAFORMTEMPLATE_VIEW_REVENUELIFECYCLECRITERIA

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

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUELIFECYCLECRITERIAID	uniqueidentifier	INOUT	ID
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@BUSINESSPROCESSPARAMETERSID	uniqueidentifier	INOUT	BUSINESSPROCESSPARAMETERSID
@PLANNEDGIVINGAVAILABLE	bit	INOUT	PLANNEDGIVINGAVAILABLE

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REVENUELIFECYCLECRITERIA
(
    @REVENUELIFECYCLECRITERIAID uniqueidentifier = null output,
    @DATALOADED bit = 0 output,
    @BUSINESSPROCESSPARAMETERSID uniqueidentifier = null output,
    @PLANNEDGIVINGAVAILABLE bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select top 1 
        @DATALOADED = 1,
        @REVENUELIFECYCLECRITERIAID = ID,
        @BUSINESSPROCESSPARAMETERSID = (select top 1 ID from dbo.REVENUELIFECYCLEPROCESS),
        @PLANNEDGIVINGAVAILABLE = (select case when dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046')= 1 or dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('0a07aa22-ed88-42b7-8c55-d80df4f4cea2')=1 then 1 else 0 end)
    from 
        dbo.REVENUELIFECYCLECRITERIA

    return 0;