USP_DATAFORMTEMPLATE_VIEW_SOLICITORCREDITRULES

The load procedure used by the view dataform template "Solicitor Credit Rules View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PRIMARYMANAGERPERCENT	decimal(5, 2)	INOUT	PRIMARYMANAGERPERCENT
@SECONDARYMANAGERPERCENT	decimal(5, 2)	INOUT	SECONDARYMANAGERPERCENT
@SECONDARYSOLICITORPERCENT	decimal(5, 2)	INOUT	SECONDARYSOLICITORPERCENT
@APPLYTOPLEDGES	bit	INOUT	Pledge
@APPLYTODONATIONS	bit	INOUT	Donation
@APPLYTOPLANNEDGIFTS	bit	INOUT	Planned gift
@APPLYTOGRANTAWARDS	bit	INOUT	Grant award
@APPLYTOMATCHINGGIFTCLAIMS	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SOLICITORCREDITRULES
(
    @DATALOADED bit = 0 output,
    @PRIMARYMANAGERPERCENT decimal(5,2) = null output,
    @SECONDARYMANAGERPERCENT decimal(5,2) = null output,
    @SECONDARYSOLICITORPERCENT decimal(5,2) = null output,
    @APPLYTOPLEDGES bit = null output,
    @APPLYTODONATIONS bit = null output,
    @APPLYTOPLANNEDGIFTS bit = null output,
    @APPLYTOGRANTAWARDS bit = null output,
    @APPLYTOMATCHINGGIFTCLAIMS bit = null output
)
as
    set nocount on;

    -- Load zeroes for a consistent display even if there's no record.

    select @DATALOADED = 1,
        @PRIMARYMANAGERPERCENT = 0,
        @SECONDARYMANAGERPERCENT = 0,
        @SECONDARYSOLICITORPERCENT = 0,
        @APPLYTOPLEDGES = 0,
        @APPLYTODONATIONS = 0,
        @APPLYTOPLANNEDGIFTS = 0,
        @APPLYTOGRANTAWARDS = 0,
        @APPLYTOMATCHINGGIFTCLAIMS = 0


    select top 1
        @PRIMARYMANAGERPERCENT = PRIMARYMANAGERPERCENT,
        @SECONDARYMANAGERPERCENT = SECONDARYMANAGERPERCENT,
        @SECONDARYSOLICITORPERCENT = SECONDARYSOLICITORPERCENT,
        @APPLYTOPLEDGES = APPLYTOPLEDGES,
        @APPLYTODONATIONS = APPLYTODONATIONS,
        @APPLYTOPLANNEDGIFTS = APPLYTOPLANNEDGIFTS,
        @APPLYTOGRANTAWARDS = APPLYTOGRANTAWARDS,
        @APPLYTOMATCHINGGIFTCLAIMS = APPLYTOMATCHINGGIFTCLAIMS
    from dbo.SOLICITORCREDITRULES
    return 0;