USP_DATAFORMTEMPLATE_VIEW_INTERACTIONMOVE

The load procedure used by the view dataform template "Interaction Move View 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.
@EXPECTEDDATE	datetime	INOUT	Expected date
@ACTUALDATE	datetime	INOUT	Actual date
@FUNDRAISER	nvarchar(700)	INOUT	Owner
@INTERACTIONTYPE	nvarchar(100)	INOUT	Contact method
@STATUS	nvarchar(100)	INOUT	Status
@OBJECTIVE	nvarchar(100)	INOUT	Objective
@COMMENT	nvarchar(max)	INOUT	Comments
@PROSPECTPLANTYPE	nvarchar(100)	INOUT	Plan type
@PROSPECTPLANSTAGETYPE	nvarchar(100)	INOUT	Plan stage

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_INTERACTIONMOVE(
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @EXPECTEDDATE datetime = null output,
                    @ACTUALDATE datetime = null output,
                    @FUNDRAISER nvarchar(700) = null output,
                    @INTERACTIONTYPE nvarchar(100) = null output,
                    @STATUS nvarchar(100) = null output,
                    @OBJECTIVE nvarchar(100) = null output,
                    @COMMENT nvarchar(max) = null output,
                    @PROSPECTPLANTYPE nvarchar(100) = null output,
                    @PROSPECTPLANSTAGETYPE nvarchar(100) = null output
                ) as begin
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @EXPECTEDDATE = I.EXPECTEDDATE,
                        @ACTUALDATE = I.ACTUALDATE,
                        @FUNDRAISER = FUNDRAISER_NF.NAME,
                        @INTERACTIONTYPE = dbo.UFN_INTERACTIONTYPECODE_GETDESCRIPTION(I.INTERACTIONTYPECODEID),
                        @STATUS = I.STATUS,
                        @OBJECTIVE = I.OBJECTIVE,
                        @COMMENT = I.COMMENT,
                        @PROSPECTPLANTYPE = dbo.UFN_PROSPECTPLANTYPECODE_GETDESCRIPTION(PP.PROSPECTPLANTYPECODEID),
                        @PROSPECTPLANSTAGETYPE = dbo.UFN_PROSPECTPLANSTATUSCODE_GETDESCRIPTION(I.PROSPECTPLANSTATUSCODEID)
                    from
                        dbo.INTERACTION I
                        inner join dbo.PROSPECTPLAN PP on PP.ID=I.PROSPECTPLANID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(I.FUNDRAISERID) FUNDRAISER_NF
                    where
                        I.ID = @ID

                    return 0

                end