USP_DATAFORMTEMPLATE_PRELOAD_ORGANIZATIONHIERARCHYPOSITIONFUNDRAISERADD

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

Parameters

Parameter	Parameter Type	Mode	Description
@ORGANIZATIONPOSITIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@NAME	nvarchar(50)	INOUT	Title
@SITE	nvarchar(1024)	INOUT	Site
@CURRENTCONSTITUENT	nvarchar(250)	INOUT	Fundraiser
@CURRENTDATEFROM	datetime	INOUT	Start date
@CURRENTPOSITIONHOLDERID	uniqueidentifier	INOUT	CURRENTPOSITIONHOLDERID
@BUSINESSUNIT	nvarchar(100)	INOUT	Business unit

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ORGANIZATIONHIERARCHYPOSITIONFUNDRAISERADD
                    (
                        @ORGANIZATIONPOSITIONID uniqueidentifier,
                        @NAME nvarchar(50) = null output,
                        @SITE nvarchar(1024) = null output,
                        @CURRENTCONSTITUENT nvarchar(250) = null output,
                        @CURRENTDATEFROM datetime = null output,
                        @CURRENTPOSITIONHOLDERID uniqueidentifier = 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,
                                @CURRENTCONSTITUENT = case when ORGANIZATIONPOSITIONHOLDER.ID is null then null else coalesce(CONSTITUENT.NAME, '<Vacant>') end,
                                @CURRENTDATEFROM = ORGANIZATIONPOSITIONHOLDER.DATEFROM,
                                @CURRENTPOSITIONHOLDERID = ORGANIZATIONPOSITIONHOLDER.ID
                        from dbo.ORGANIZATIONPOSITION
                        left outer join dbo.SITE
                            on ORGANIZATIONPOSITION.SITEID = SITE.ID
                        left outer join dbo.ORGANIZATIONPOSITIONHOLDER
                            on ORGANIZATIONPOSITIONHOLDER.POSITIONID = ORGANIZATIONPOSITION.ID
                        left outer join dbo.CONSTITUENT
                            on CONSTITUENT.ID = CONSTITUENTID
                        where ORGANIZATIONPOSITION.ID = @ORGANIZATIONPOSITIONID
                        order by DATEFROM desc;

                        return 0;

                    end