USP_DATAFORMTEMPLATE_EDITLOAD_ORGANIZATIONHIERARCHYPOSITIONFUNDRAISEREDIT

The load procedure used by the edit dataform template "Organization Hierarchy Position Current Fundraiser Edit Form"

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.
@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.
@ORGANIZATIONPOSITIONHOLDERID	uniqueidentifier	INOUT	ORGANIZATIONPOSITIONHOLDERID
@NAME	nvarchar(50)	INOUT	Title
@SITE	nvarchar(1024)	INOUT	Site
@CONSTITUENT	nvarchar(250)	INOUT	Fundraiser
@CURRENTDATEFROM	datetime	INOUT	Start date
@DATEFROM	datetime	INOUT	Start date
@BUSINESSUNIT	nvarchar(100)	INOUT	Business unit

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ORGANIZATIONHIERARCHYPOSITIONFUNDRAISEREDIT
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @ORGANIZATIONPOSITIONHOLDERID uniqueidentifier = null output,
                        @NAME nvarchar(50) = null output,
                        @SITE nvarchar(1024) = null output,
                        @CONSTITUENT nvarchar(250) = null output,
                        @CURRENTDATEFROM datetime = null output,
                        @DATEFROM datetime = null output,
                        @BUSINESSUNIT nvarchar(100) = null output
                    )
                    as
                    begin
                        set nocount on;

                        --Grab the most current information

                        select top 1 
                                @NAME = ORGANIZATIONPOSITION.NAME,
                                @BUSINESSUNIT = dbo.UFN_BUSINESSUNITCODE_GETDESCRIPTION(ORGANIZATIONPOSITION.BUSINESSUNITCODEID),
                                @SITE = SITE.NAME,
                                @CONSTITUENT = coalesce(CONSTITUENT.NAME, '<Vacant>'),
                                @CURRENTDATEFROM = ORGANIZATIONPOSITIONHOLDER.DATEFROM,
                                @DATEFROM  = ORGANIZATIONPOSITIONHOLDER.DATEFROM,
                                @ORGANIZATIONPOSITIONHOLDERID = ORGANIZATIONPOSITIONHOLDER.ID,
                                @DATALOADED = 1,
                                @TSLONG = ORGANIZATIONPOSITION.TSLONG
                        from dbo.ORGANIZATIONPOSITION
                        left outer join dbo.SITE
                            on ORGANIZATIONPOSITION.SITEID = SITE.ID
                        inner join dbo.ORGANIZATIONPOSITIONHOLDER
                            on ORGANIZATIONPOSITIONHOLDER.POSITIONID = ORGANIZATIONPOSITION.ID
                        left outer join dbo.CONSTITUENT
                            on CONSTITUENT.ID = CONSTITUENTID
                        where ORGANIZATIONPOSITION.ID = @ID
                        order by ORGANIZATIONPOSITIONHOLDER.DATEFROM desc;

                        return 0;

                    end