USP_DATAFORMTEMPLATE_EDITLOAD_INTERACTION_4

The load procedure used by the edit dataform template "Interaction Edit Form 4"

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.
@EXPECTEDDATE	datetime	INOUT	Expected date
@ACTUALDATE	datetime	INOUT	Actual date
@FUNDRAISERID	uniqueidentifier	INOUT	Owner
@INTERACTIONTYPECODEID	uniqueidentifier	INOUT	Contact method
@OBJECTIVE	nvarchar(100)	INOUT	Summary
@STATUSCODE	tinyint	INOUT	Status
@COMMENT	nvarchar(max)	INOUT	Comment
@ISSTEP	bit	INOUT	Is step
@EVENTID	uniqueidentifier	INOUT	Event
@PARTICIPANTS	xml	INOUT	Participants
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent ID
@CONSTITUENTNAME	nvarchar(700)	INOUT	Constituent name
@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
@ISALLDAYEVENT	bit	INOUT
@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_INTERACTION_4 (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @EXPECTEDDATE datetime = null output,
    @ACTUALDATE datetime = null output,
    @FUNDRAISERID uniqueidentifier = null output,
    @INTERACTIONTYPECODEID uniqueidentifier = null output,
    @OBJECTIVE nvarchar(100) = null output,
    @STATUSCODE tinyint = null output,
    @COMMENT nvarchar(max) = null output,
    @ISSTEP bit = null output,
    @EVENTID uniqueidentifier = null output,
    @PARTICIPANTS xml = null output,
    @CONSTITUENTID uniqueidentifier = null output,
    @CONSTITUENTNAME nvarchar(700) = 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,
    @ISALLDAYEVENT bit = null output, 
    @TIMEZONEENTRYID uniqueidentifier = null output,
    @ACTUALSTARTTIME dbo.UDT_HOURMINUTE = null output,
    @ACTUALENDTIME dbo.UDT_HOURMINUTE = null output
) as begin
    set nocount on;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_INTERACTION_5
        @ID,
        @DATALOADED = @DATALOADED output,
        @TSLONG = @TSLONG output,
        @EXPECTEDDATE = @EXPECTEDDATE output,
        @ACTUALDATE = @ACTUALDATE output,
        @FUNDRAISERID = @FUNDRAISERID output,
        @INTERACTIONTYPECODEID = @INTERACTIONTYPECODEID output,
        @OBJECTIVE = @OBJECTIVE output,
        @STATUSCODE = @STATUSCODE output,
        @COMMENT = @COMMENT output,
        @ISSTEP = @ISSTEP output,
        @EVENTID = @EVENTID output,
        @PARTICIPANTS = @PARTICIPANTS output,
        @CONSTITUENTID = @CONSTITUENTID output,
        @CONSTITUENTNAME = @CONSTITUENTNAME output,
        @INTERACTIONCATEGORYID = @INTERACTIONCATEGORYID output,
        @INTERACTIONSUBCATEGORYID = @INTERACTIONSUBCATEGORYID output,
        @SITES = @SITES output, 
        @EXPECTEDSTARTTIME = @EXPECTEDSTARTTIME output,
        @EXPECTEDENDTIME = @EXPECTEDENDTIME output,
        @ISALLDAYEVENT = @ISALLDAYEVENT output, 
        @TIMEZONEENTRYID = @TIMEZONEENTRYID output,
        @ACTUALSTARTTIME = @ACTUALSTARTTIME output,
        @ACTUALENDTIME = @ACTUALENDTIME output

    return 0;

end