USP_DATAFORMTEMPLATE_VIEW_STEWARDSHIPPLANSTEPDETAILS

The load procedure used by the view dataform template "Stewardship Plan Step Details View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@OBJECTIVE	nvarchar(100)	INOUT	Objective
@STATUS	nvarchar(50)	INOUT	Status
@ASSIGNEDTO	nvarchar(154)	INOUT	Assigned to
@CATEGORY	nvarchar(100)	INOUT	Category
@TEMPLATE	nvarchar(100)	INOUT	Template
@CONTACTMETHOD	nvarchar(100)	INOUT	Contact method
@TARGETDATE	datetime	INOUT	Target date
@TARGETSTARTTIME	UDT_HOURMINUTE	INOUT	Target start time
@TARGETENDTIME	UDT_HOURMINUTE	INOUT	Target end time
@TIMEZONE	nvarchar(255)	INOUT	Time zone
@ASSOCIATEDPLANS	nvarchar(255)	INOUT	Associated plans
@FREQUENCY	nvarchar(50)	INOUT	Frequency
@STARTDATE	datetime	INOUT	Start date
@ENDDATE	datetime	INOUT	End date

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STEWARDSHIPPLANSTEPDETAILS
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @OBJECTIVE nvarchar(100) = null output,
    @STATUS nvarchar(50) = null output,
    @ASSIGNEDTO nvarchar(154) = null output,
    @CATEGORY nvarchar(100) = null output,
    @TEMPLATE nvarchar(100) = null output,
    @CONTACTMETHOD nvarchar(100) = null output,
    @TARGETDATE datetime = null output,
    @TARGETSTARTTIME dbo.UDT_HOURMINUTE = null output,
    @TARGETENDTIME dbo.UDT_HOURMINUTE = null output,
    @TIMEZONE nvarchar(255) = null output,
    @ASSOCIATEDPLANS nvarchar(255) = null output,
    @FREQUENCY nvarchar(50) = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output
)
as
    set nocount on;

    declare @ASSOCIATEDPLANSXML xml;

    exec dbo.USP_STEWARDSHIPPLANSTEP_GETDETAILS
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @DATALOADED = @DATALOADED output,
        @CATEGORY = @CATEGORY output,
        @OBJECTIVE = @OBJECTIVE output,
        @STATUS = @STATUS output,
        @TARGETDATE = @TARGETDATE output,
        @STARTDATE = @STARTDATE output,
        @ENDDATE = @ENDDATE output,
        @ASSIGNEDTO = @ASSIGNEDTO output,
        @CONTACTMETHOD = @CONTACTMETHOD output,
        @TEMPLATE = @TEMPLATE output,
        @ASSOCIATEDPLANS = @ASSOCIATEDPLANSXML output,
        @FREQUENCY = @FREQUENCY output,
        @TARGETSTARTTIME = @TARGETSTARTTIME output,
        @TARGETENDTIME = @TARGETENDTIME output,
        @TIMEZONEENTRYID = @TIMEZONE output

    select @ASSOCIATEDPLANS = dbo.UDA_BUILDLIST(T.c.value('(PLANNAME)[1]','nvarchar(100)')) from @ASSOCIATEDPLANSXML.nodes('/ASSOCIATEDPLANS/ITEM') T(c)

    return 0;