USP_DATAFORMTEMPLATE_EDITLOAD_FEPPROCESS

The load procedure used by the edit dataform template "FEP Process Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@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.
@NAME	nvarchar(150)	INOUT	Name
@DESCRIPTION	nvarchar(250)	INOUT	Description
@SITEID	uniqueidentifier	INOUT	Site
@ORGANIZATIONNAME	nvarchar(50)	INOUT	Organization name
@COUNTRYID	uniqueidentifier	INOUT	Country
@POSTCODE	nvarchar(12)	INOUT	ZIP Code
@IDNUMBER	nvarchar(15)	INOUT	Identification number
@CONTACTNAME	nvarchar(50)	INOUT	Contact person
@CONTACTEMAIL	nvarchar(100)	INOUT	Email address
@CONTACTPHONE	nvarchar(20)	INOUT	Phone
@AFP	bit	INOUT	AFP (Association of Fundraising Professionals)
@CASE	bit	INOUT	CASE (Council for Advancement and Support of Education)
@AHP	bit	INOUT	AHP (Association for Healthcare Philanthropy)
@ALDE	bit	INOUT	ALDE (Association of Lutheran Development Executives)
@NCPG	bit	INOUT	NCPG (National Committee on Planned Giving)
@CRD	bit	INOUT	CRD (Council for Resource Development)
@OTHER	bit	INOUT	Other (please specify)
@OTHERAFFILIATION	nvarchar(50)	INOUT
@INITIALYEAR	UDT_YEAR	INOUT	Year development program initiated (YYYY)
@SUBSECTORCODE	tinyint	INOUT	Subsector or type of organization
@FUNDRAISINGEXPENSES	money	INOUT	Fundraising Expenses
@FTEPROFESSIONAL	decimal(20, 2)	INOUT	Full-time Professional staff (Period 2)
@FTESUPPORT	decimal(20, 2)	INOUT	Full-time Support staff (Period 2)
@FTECONSULTANT	decimal(20, 2)	INOUT	Consultant full-time equivalent (Period 2)
@FTEVOLUNTEER	decimal(20, 2)	INOUT	Full-time Volunteer fundraisers (Period 2)
@COMMENTS	nvarchar(250)	INOUT	Comments
@SITEREQUIRED	bit	INOUT	Site required

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_FEPPROCESS
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,    
    @NAME nvarchar(150) = null output,
    @DESCRIPTION nvarchar(250) = null output,
    @SITEID uniqueidentifier = null output,
    @ORGANIZATIONNAME nvarchar(50) = null output,
    @COUNTRYID uniqueidentifier = null output,
    @POSTCODE nvarchar(12) = null output,
    @IDNUMBER nvarchar(15) = null output,
    @CONTACTNAME nvarchar(50) = null output,
    @CONTACTEMAIL nvarchar(100) = null output,
    @CONTACTPHONE nvarchar(20) = null output,
    @AFP bit = null output,
    @CASE bit = null output,
    @AHP bit = null output,
    @ALDE bit = null output,
    @NCPG bit = null output,
    @CRD bit = null output,
    @OTHER bit = null output,
    @OTHERAFFILIATION nvarchar(50) = null output,
    @INITIALYEAR dbo.UDT_YEAR = null output,
    @SUBSECTORCODE tinyint = null output,
    @FUNDRAISINGEXPENSES money = null output,
    @FTEPROFESSIONAL decimal(20,2) = null output,
    @FTESUPPORT decimal(20,2) = null output,
    @FTECONSULTANT decimal(20,2) = null output,
    @FTEVOLUNTEER decimal(20,2) = null output,
    @COMMENTS nvarchar(250) = null output,
    @SITEREQUIRED bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @TSLONG = FEPPROCESS.TSLONG,
        @NAME = FEPPROCESS.[NAME],
        @DESCRIPTION = FEPPROCESS.DESCRIPTION,
        @SITEID = FEPPROCESS.SITEID,
        @ORGANIZATIONNAME = FEPPROCESS.ORGANIZATIONNAME,
        @COUNTRYID = FEPPROCESS.COUNTRYID,
        @POSTCODE = FEPPROCESS.POSTCODE,
        @IDNUMBER = FEPPROCESS.IDNUMBER,
        @CONTACTNAME = FEPPROCESS.CONTACTNAME,
        @CONTACTEMAIL = FEPPROCESS.CONTACTEMAIL,
        @CONTACTPHONE = FEPPROCESS.CONTACTPHONE,
        @AFP = FEPPROCESS.AFP,
        @CASE = FEPPROCESS.[CASE],
        @AHP = FEPPROCESS.AHP,
        @ALDE = FEPPROCESS.ALDE,
        @NCPG = FEPPROCESS.NCPG,
        @CRD = FEPPROCESS.CRD,
        @OTHER = FEPPROCESS.OTHER,
        @OTHERAFFILIATION = FEPPROCESS.OTHERAFFILIATION,
        @INITIALYEAR = FEPPROCESS.INITIALYEAR,
        @SUBSECTORCODE = FEPPROCESS.SUBSECTORCODE,
        @FUNDRAISINGEXPENSES = FEPPROCESS.FUNDRAISINGEXPENSES,
        @FTEPROFESSIONAL = FEPPROCESS.FTEPROFESSIONAL,
        @FTESUPPORT = FEPPROCESS.FTESUPPORT,
        @FTECONSULTANT = FEPPROCESS.FTECONSULTANT,
        @FTEVOLUNTEER = FEPPROCESS.FTEVOLUNTEER,
        @COMMENTS = FEPPROCESS.COMMENTS,
        @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID)
    from dbo.FEPPROCESS
    where ID = @ID;

    return 0;