USP_DATAFORMTEMPLATE_EDITLOAD_SOLICITORCREDITRULES

The load procedure used by the edit dataform template "Solicitor Credit Rules Edit Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@PRIMARYMANAGERPERCENT	decimal(5, 2)	INOUT	Primary manager credit percent
@SECONDARYMANAGERPERCENT	decimal(5, 2)	INOUT	Secondary manager credit percent
@SECONDARYSOLICITORPERCENT	decimal(5, 2)	INOUT	Secondary solicitor credit percent
@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_EDITLOAD_SOLICITORCREDITRULES(
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 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;

    set @DATALOADED = 1   -- want to pretend we've loaded if there's no record

    set @TSLONG = 0

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