USP_DATAFORMTEMPLATE_VIEW_INTERACTIONBATCH

The load procedure used by the view dataform template "Interaction Batch 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.
@CONSTITUENTID	uniqueidentifier	INOUT	CONSTITUENTID
@CONSTITUENTNAME	nvarchar(250)	INOUT	CONSTITUENTNAME
@CUSTOMIDENTIFIER	nvarchar(100)	INOUT	CUSTOMIDENTIFIER
@INTERACTIONTYPECODEID	uniqueidentifier	INOUT	INTERACTIONTYPECODEID
@OBJECTIVE	nvarchar(100)	INOUT	OBJECTIVE
@FUNDRAISERID	uniqueidentifier	INOUT	FUNDRAISERID
@EXPECTEDDATE	datetime	INOUT	EXPECTEDDATE
@ACTUALDATE	datetime	INOUT	ACTUALDATE
@STATUSCODE	tinyint	INOUT	STATUSCODE
@COMMENT	nvarchar(max)	INOUT	COMMENT
@EVENTID	uniqueidentifier	INOUT	EVENTID
@PARTICIPANTS	xml	INOUT	PARTICIPANTS
@INTERACTIONCATEGORYID	uniqueidentifier	INOUT	INTERACTIONCATEGORYID
@INTERACTIONSUBCATEGORYID	uniqueidentifier	INOUT	INTERACTIONSUBCATEGORYID
@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_VIEW_INTERACTIONBATCH
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 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;

                    select
                        @DATALOADED = 1,
                        @CONSTITUENTID = CONSTITUENT.ID,
                        @CONSTITUENTNAME = CONSTITUENT.NAME,
                        @CUSTOMIDENTIFIER = INTERACTION.LOOKUPID,
                        @INTERACTIONTYPECODEID = INTERACTION.INTERACTIONTYPECODEID,
                        @OBJECTIVE = INTERACTION.OBJECTIVE,
                        @FUNDRAISERID = INTERACTION.FUNDRAISERID,
                        @EXPECTEDDATE = INTERACTION.EXPECTEDDATE,
                        @ACTUALDATE = INTERACTION.ACTUALDATE,
                        @STATUSCODE = INTERACTION.STATUSCODE,
                        @COMMENT = INTERACTION.COMMENT,
                        @EVENTID = INTERACTION.EVENTID,
                        @PARTICIPANTS = dbo.UFN_INTERACTION_PARTICIPANTS_TOITEMLISTXML(INTERACTION.ID),
                        @INTERACTIONCATEGORYID = INTERACTIONSUBCATEGORY.INTERACTIONCATEGORYID,
                        @INTERACTIONSUBCATEGORYID = INTERACTION.INTERACTIONSUBCATEGORYID,
                        @SITES = dbo.UFN_CONSTITUENTINTERACTION_GETSITES_TOITEMLISTXML(INTERACTION.ID),
                        @EXPECTEDSTARTTIME = INTERACTION.EXPECTEDSTARTTIME,
                        @EXPECTEDENDTIME = INTERACTION.EXPECTEDENDTIME,
                        @TIMEZONEENTRYID = INTERACTION.TIMEZONEENTRYID,
                        @ACTUALSTARTTIME = INTERACTION.ACTUALSTARTTIME,
                        @ACTUALENDTIME = INTERACTION.ACTUALENDTIME
                    from
                        dbo.INTERACTION
                        inner join dbo.CONSTITUENT on INTERACTION.CONSTITUENTID = CONSTITUENT.ID
                        left outer join dbo.INTERACTIONSUBCATEGORY on INTERACTIONSUBCATEGORY.ID = INTERACTION.INTERACTIONSUBCATEGORYID
                    where
                        INTERACTION.ID = @ID