USP_DATAFORMTEMPLATE_EDITLOAD_BATCHINTERACTIONBATCHROW

The load procedure used by the edit dataform template "Interaction Batch Row 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.
@SEQUENCE	int	INOUT	Sequence
@INTERACTIONID	uniqueidentifier	INOUT	Interaction
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent lookup ID
@CONSTITUENTNAME	nvarchar(250)	INOUT	Constituent name
@CUSTOMIDENTIFIER	nvarchar(100)	INOUT	Interaction lookup ID
@INTERACTIONTYPECODEID	uniqueidentifier	INOUT	Contact method
@OBJECTIVE	nvarchar(100)	INOUT	Summary
@FUNDRAISERID	uniqueidentifier	INOUT	Owner
@EXPECTEDDATE	datetime	INOUT	Expected date
@ACTUALDATE	datetime	INOUT	Actual date
@STATUSCODE	tinyint	INOUT	Status
@COMMENT	nvarchar(max)	INOUT	Comment
@EVENTID	uniqueidentifier	INOUT	Event
@PARTICIPANTS	xml	INOUT	Participants
@INTERACTIONCATEGORYID	uniqueidentifier	INOUT	Category
@INTERACTIONSUBCATEGORYID	uniqueidentifier	INOUT	Subcategory
@SITES	xml	INOUT	Sites
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	INOUT	Expected start time
@EXPECTEDENDTIME	UDT_HOURMINUTE	INOUT	Expected end time
@TIMEZONEENTRYID	uniqueidentifier	INOUT	Time zone
@ACTUALSTARTTIME	UDT_HOURMINUTE	INOUT	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	INOUT	Actual end time

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHINTERACTIONBATCHROW(
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @SEQUENCE int = null output,
                        @INTERACTIONID uniqueidentifier = null output,
                        @CONSTITUENTID uniqueidentifier = null output,
                        @CONSTITUENTNAME nvarchar(250) = null output,
                        @CUSTOMIDENTIFIER nvarchar(100) = null output,
                        @INTERACTIONTYPECODEID uniqueidentifier = null output,
                        @OBJECTIVE nvarchar(100) = null output,
                        @FUNDRAISERID uniqueidentifier = null output,
                        @EXPECTEDDATE datetime = null output,
                        @ACTUALDATE datetime = null output,
                        @STATUSCODE tinyint = null output,
                        @COMMENT nvarchar(max) = null output,
                        @EVENTID uniqueidentifier = null output,
                        @PARTICIPANTS xml = null output,
                        @INTERACTIONCATEGORYID uniqueidentifier = null output,
                        @INTERACTIONSUBCATEGORYID uniqueidentifier = null output,
                        @SITES xml = null output,
                        @EXPECTEDSTARTTIME dbo.UDT_HOURMINUTE = null output,
                        @EXPECTEDENDTIME dbo.UDT_HOURMINUTE = null output,
                        @TIMEZONEENTRYID uniqueidentifier = null output,
                        @ACTUALSTARTTIME dbo.UDT_HOURMINUTE = null output,
                        @ACTUALENDTIME dbo.UDT_HOURMINUTE = null output
                    ) as
                    set nocount on;

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

                    select
                        @DATALOADED = 1,
                        @TSLONG = BATCHINTERACTION.[TSLONG],
                        @SEQUENCE = BATCHINTERACTION.[SEQUENCE],
                        @INTERACTIONID = BATCHINTERACTION.[INTERACTIONID],
                        @CONSTITUENTID = BATCHINTERACTION.[CONSTITUENTID],
                        @CONSTITUENTNAME = CONSTITUENT.[NAME],
                        @CUSTOMIDENTIFIER = BATCHINTERACTION.[BATCHINTERACTIONLOOKUPID],
                        @INTERACTIONTYPECODEID = BATCHINTERACTION.[INTERACTIONTYPECODEID],
                        @OBJECTIVE = BATCHINTERACTION.[OBJECTIVE],
                        @FUNDRAISERID = BATCHINTERACTION.[FUNDRAISERID],
                        @EXPECTEDDATE = BATCHINTERACTION.[EXPECTEDDATE],
                        @ACTUALDATE = BATCHINTERACTION.[ACTUALDATE],
                        @STATUSCODE = BATCHINTERACTION.[STATUSCODE],
                        @COMMENT = BATCHINTERACTION.[COMMENT],
                        @EVENTID = BATCHINTERACTION.[EVENTID],
                        @PARTICIPANTS = dbo.UFN_BATCHINTERACTION_GETPARTICIPANTS_TOITEMLISTXML(BATCHINTERACTION.[ID]),
                        @INTERACTIONCATEGORYID = BATCHINTERACTION.[INTERACTIONCATEGORYID],
                        @INTERACTIONSUBCATEGORYID = BATCHINTERACTION.[INTERACTIONSUBCATEGORYID],
                        @SITES = dbo.UFN_BATCHINTERACTION_GETSITES_TOITEMLISTXML(BATCHINTERACTION.[ID]),
                        @EXPECTEDSTARTTIME = BATCHINTERACTION.EXPECTEDSTARTTIME,
                        @EXPECTEDENDTIME = BATCHINTERACTION.EXPECTEDENDTIME,
                        @TIMEZONEENTRYID = BATCHINTERACTION.TIMEZONEENTRYID,
                        @ACTUALSTARTTIME = BATCHINTERACTION.ACTUALSTARTTIME,
                        @ACTUALENDTIME = BATCHINTERACTION.ACTUALENDTIME
                    from
                        dbo.BATCHINTERACTION 
                        inner join dbo.CONSTITUENT on CONSTITUENT.ID = BATCHINTERACTION.CONSTITUENTID
                    where
                        BATCHINTERACTION.ID = @ID;

                    return 0;