USP_DATAFORMTEMPLATE_VIEW_STEWARDSHIPPLANSTEP

The load procedure used by the view dataform template "Stewardship Plan Step 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.
@CATEGORY	nvarchar(100)	INOUT	Category
@OBJECTIVE	nvarchar(100)	INOUT	Objective
@STATUS	nvarchar(50)	INOUT	Status
@STATUSCODE	smallint	INOUT	Status code
@DATELOCKED	bit	INOUT	Locked
@TARGETDATE	datetime	INOUT	Target date
@ACTUALDATE	datetime	INOUT	Actual date
@STARTDATE	datetime	INOUT	Start date
@ENDDATE	datetime	INOUT	End date
@CONTACTPERSON	nvarchar(154)	INOUT	Contact person
@CONTACTMETHOD	nvarchar(100)	INOUT	Contact method
@ASSIGNEDTO	nvarchar(154)	INOUT	Assigned to
@TEMPLATE	nvarchar(100)	INOUT	Template
@ASSOCIATEDPLANS	xml	INOUT	Associated plans
@FREQUENCY	nvarchar(50)	INOUT	Frequency
@RECURSCODE	smallint	INOUT	Recurs code
@ISOWNERINDIVIDUAL	bit	INOUT	Is owner an individual
@BENEFITID	uniqueidentifier	INOUT	Benefit
@EVENTID	uniqueidentifier	INOUT	Event
@MAILINGID	uniqueidentifier	INOUT	Mailing
@BENEFITNAME	nvarchar(100)	INOUT	Benefit
@BENEFITVALUE	money	INOUT	Value
@EVENTNAME	nvarchar(100)	INOUT	Event
@EVENTSTARTDATE	datetime	INOUT	Start date
@EVENTENDDATE	datetime	INOUT	End date
@EVENTLOCATION	nvarchar(100)	INOUT	Location
@EVENTCONTACT	nvarchar(154)	INOUT	Contact
@MAILINGNAME	nvarchar(100)	INOUT	Mailing
@MAILINGPLAN	nvarchar(max)	INOUT	Plan
@MAILDATE	datetime	INOUT	Mail date
@MAILINGACTIVATED	bit	INOUT	Activated
@MAILINGTESTS	int	INOUT	Tests
@MAILINGDESCRIPTION	nvarchar(255)	INOUT	Description
@MAILINGCODE	nvarchar(10)	INOUT	Code
@TARGETSTARTTIME	UDT_HOURMINUTE	INOUT	Target start time
@TARGETENDTIME	UDT_HOURMINUTE	INOUT	Target end time
@TIMEZONEENTRYID	nvarchar(255)	INOUT	Time zone
@ACTUALSTARTTIME	UDT_HOURMINUTE	INOUT	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	INOUT	Actual end time
@PARTICIPANTS	nvarchar(1000)	INOUT	Participants

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STEWARDSHIPPLANSTEP(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CATEGORY nvarchar(100) = null output,
    @OBJECTIVE nvarchar(100) = null output,
    @STATUS nvarchar(50) = null output,
    @STATUSCODE smallint = null output,
    @DATELOCKED bit = null output,
    @TARGETDATE datetime = null output,
    @ACTUALDATE datetime = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output,
    @CONTACTPERSON nvarchar(154) = null output,
    @CONTACTMETHOD nvarchar(100) = null output,
    @ASSIGNEDTO nvarchar(154) = null output,
    @TEMPLATE nvarchar(100) = null output,
    @ASSOCIATEDPLANS xml = null output,
    @FREQUENCY nvarchar(50) = null output,
    @RECURSCODE smallint = null output,
    @ISOWNERINDIVIDUAL bit = null output,

    @BENEFITID uniqueidentifier = null output,
    @EVENTID uniqueidentifier = null output,
    @MAILINGID uniqueidentifier = null output,

    @BENEFITNAME nvarchar(100) = null output,
    @BENEFITVALUE money = null output,

    @EVENTNAME nvarchar(100) = null output,
    @EVENTSTARTDATE datetime = null output,
    @EVENTENDDATE datetime = null output,
    @EVENTLOCATION nvarchar(100) = null output,
    @EVENTCONTACT nvarchar(154) = null output,

    @MAILINGNAME nvarchar(100) = null output,
    @MAILINGPLAN nvarchar(max) = null output,
    @MAILDATE datetime = null output,
    @MAILINGACTIVATED bit = null output,
    @MAILINGTESTS integer = null output,
    @MAILINGDESCRIPTION nvarchar(255) = null output,
    @MAILINGCODE nvarchar(10) = null output,

    @TARGETSTARTTIME dbo.UDT_HOURMINUTE = null output,
    @TARGETENDTIME dbo.UDT_HOURMINUTE = null output,
    @TIMEZONEENTRYID nvarchar(255) = null output,
    @ACTUALSTARTTIME dbo.UDT_HOURMINUTE = null output,
    @ACTUALENDTIME dbo.UDT_HOURMINUTE = null output,
    @PARTICIPANTS nvarchar(1000) = null output

) as begin
    set nocount on;

    exec dbo.USP_STEWARDSHIPPLANSTEP_GETDETAILS
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @DATALOADED = @DATALOADED output,
        @CATEGORY = @CATEGORY output,
        @OBJECTIVE = @OBJECTIVE output,
        @STATUS = @STATUS output,
        @STATUSCODE = @STATUSCODE output,
        @DATELOCKED = @DATELOCKED output,
        @TARGETDATE = @TARGETDATE output,
        @ACTUALDATE = @ACTUALDATE output,
        @STARTDATE = @STARTDATE output,
        @ENDDATE = @ENDDATE output,
        @CONTACTPERSON = @CONTACTPERSON output,
        @CONTACTMETHOD = @CONTACTMETHOD output,
        @ASSIGNEDTO = @ASSIGNEDTO output,
        @TEMPLATE = @TEMPLATE output,
        @ASSOCIATEDPLANS = @ASSOCIATEDPLANS output,
        @FREQUENCY = @FREQUENCY output,
        @RECURSCODE = @RECURSCODE output,
        @ISOWNERINDIVIDUAL = @ISOWNERINDIVIDUAL output,
        @BENEFITID = @BENEFITID output,
        @EVENTID = @EVENTID output,
        @MAILINGID = @MAILINGID output,
        @BENEFITNAME = @BENEFITNAME output,
        @BENEFITVALUE = @BENEFITVALUE output,
        @EVENTNAME = @EVENTNAME output,
        @EVENTSTARTDATE = @EVENTSTARTDATE output,
        @EVENTENDDATE = @EVENTENDDATE output,
        @EVENTLOCATION = @EVENTLOCATION output,
        @EVENTCONTACT = @EVENTCONTACT output,
        @MAILINGNAME = @MAILINGNAME output,
        @MAILINGPLAN = @MAILINGPLAN output,
        @MAILDATE = @MAILDATE output,
        @MAILINGACTIVATED = @MAILINGACTIVATED output,
        @MAILINGTESTS = @MAILINGTESTS output,
        @MAILINGDESCRIPTION = @MAILINGDESCRIPTION output,
        @MAILINGCODE = @MAILINGCODE output,
        @TARGETSTARTTIME = @TARGETSTARTTIME output,
        @TARGETENDTIME = @TARGETENDTIME output,
        @TIMEZONEENTRYID = @TIMEZONEENTRYID output,
        @ACTUALSTARTTIME = @ACTUALSTARTTIME output,
        @ACTUALENDTIME = @ACTUALENDTIME output,
        @PARTICIPANTS = @PARTICIPANTS output

    return 0

end