USP_DATAFORMTEMPLATE_EDITLOAD_BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHROW

The load procedure used by the edit dataform template "Stewardship Plan Step Update 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.
@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.
@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
@PRIMARYRECORDID	uniqueidentifier	INOUT	Stewardship plan step
@STEPOWNERID	uniqueidentifier	INOUT
@STEPOWNERNAME	nvarchar(154)	INOUT	Constituent name
@STEPOWNERISINDIVIDUAL	bit	INOUT	Step owner is an individual
@STEWARDSHIPPLANID	uniqueidentifier	INOUT	Plan ID
@CATEGORYCODEID	uniqueidentifier	INOUT	Category
@OBJECTIVE	nvarchar(100)	INOUT	Objective
@TARGETDATE	date	INOUT	Target date
@DATELOCKED	bit	INOUT	Locked
@ACTUALDATE	date	INOUT	Actual date
@STARTDATE	date	INOUT	Frequency start date
@ENDDATE	date	INOUT	Frequency end date
@CONTACTMETHODCODEID	uniqueidentifier	INOUT	Contact method
@CONTACTPERSONID	uniqueidentifier	INOUT	Contact person
@CONSTITUENTID	uniqueidentifier	INOUT	Assigned to
@ASSOCIATEDPLANS	xml	INOUT	Associated plans
@TEMPLATE	nvarchar(100)	INOUT	Template
@RECURSCODE	smallint	INOUT	Frequency
@STATUSCODE	smallint	INOUT	Status
@NEXTTARGETDATE	date	INOUT	Next target date
@LINKTYPECODE	tinyint	INOUT	Connect to
@EVENTID	uniqueidentifier	INOUT	Event
@MAILINGID	uniqueidentifier	INOUT	Mailing
@BENEFITID	uniqueidentifier	INOUT	Benefit
@TARGETSTARTTIME	UDT_HOURMINUTE	INOUT	Target start time
@TARGETENDTIME	UDT_HOURMINUTE	INOUT	Target end time
@TIMEZONEENTRYID	uniqueidentifier	INOUT	Time zone
@ISALLDAYEVENT	bit	INOUT	Is all day event
@ACTUALSTARTTIME	UDT_HOURMINUTE	INOUT	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	INOUT	Actual end time
@STEPPARTICIPANTS	xml	INOUT	Plan participants

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHROW
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @SEQUENCE int = null output,
  @PRIMARYRECORDID uniqueidentifier = null output,
  @STEPOWNERID uniqueidentifier = null output,
  @STEPOWNERNAME nvarchar(154) = null output,
  @STEPOWNERISINDIVIDUAL bit = null output,
  @STEWARDSHIPPLANID uniqueidentifier = null output,
  @CATEGORYCODEID uniqueidentifier = null output,
  @OBJECTIVE nvarchar(100) = null output,
  @TARGETDATE date = null output,
  @DATELOCKED bit = null output,
  @ACTUALDATE date = null output,
  @STARTDATE date = null output,
  @ENDDATE date = null output,
  @CONTACTMETHODCODEID uniqueidentifier = null output,
  @CONTACTPERSONID uniqueidentifier = null output,
  @CONSTITUENTID uniqueidentifier = null output,
  @ASSOCIATEDPLANS xml = null output,
  @TEMPLATE nvarchar(100) = null output,
  @RECURSCODE smallint = null output,
  @STATUSCODE smallint = null output,
  @NEXTTARGETDATE date = null output,
  @LINKTYPECODE tinyint = null output,
  @EVENTID uniqueidentifier = null output,
  @MAILINGID uniqueidentifier = null output,
  @BENEFITID uniqueidentifier = null output,
  @TARGETSTARTTIME dbo.UDT_HOURMINUTE = null output,
  @TARGETENDTIME dbo.UDT_HOURMINUTE = null output,
  @TIMEZONEENTRYID uniqueidentifier = null output,
  @ISALLDAYEVENT bit = null output,
  @ACTUALSTARTTIME dbo.UDT_HOURMINUTE = null output,
  @ACTUALENDTIME dbo.UDT_HOURMINUTE = null output,
  @STEPPARTICIPANTS xml = null output
)
as
set nocount on;

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

select
  @DATALOADED = 1,
  @TSLONG = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[TSLONG],
  @SEQUENCE = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[SEQUENCE],
  @PRIMARYRECORDID = [PRIMARYRECORDID],
  @STEPOWNERID = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[STEPOWNERID],
  @STEPOWNERNAME = NF.NAME,
  @STEPOWNERISINDIVIDUAL = 
      case 
        when OWNER.ISGROUP = 1 or OWNER.ISORGANIZATION = 1 then 0
        else 1
      end,
  @STEWARDSHIPPLANID = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[STEWARDSHIPPLANID],
  @CATEGORYCODEID = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[CATEGORYCODEID],
  @OBJECTIVE = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[OBJECTIVE],
  @TARGETDATE = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[TARGETDATE],
  @DATELOCKED = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[DATELOCKED],
  @ACTUALDATE = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[ACTUALDATE],
  @STARTDATE = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[STARTDATE],
  @ENDDATE = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[ENDDATE],
  @CONTACTMETHODCODEID = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[CONTACTMETHODCODEID],
  @CONTACTPERSONID = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[CONTACTPERSONID],
  @CONSTITUENTID = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[CONSTITUENTID],
  @ASSOCIATEDPLANS = dbo.UFN_BATCHSTEWARDSHIPPLANSTEPUPDATE_GETASSOCIATEDPLANS_TOITEMLISTXML(BATCHSTEWARDSHIPPLANSTEPUPDATE.ID,@CURRENTAPPUSERID),
  @TEMPLATE = [STEP].[TEMPLATE],
  @RECURSCODE = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[RECURSCODE],
  @STATUSCODE = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[STATUSCODE],
  @NEXTTARGETDATE = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[NEXTTARGETDATE],
  @LINKTYPECODE = 
      case
        when not BATCHSTEWARDSHIPPLANSTEPUPDATE.EVENTID is null then 1
        when not BATCHSTEWARDSHIPPLANSTEPUPDATE.MAILINGID is null then 2
        else 0
      end,
  @EVENTID = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[EVENTID],
  @MAILINGID = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[MAILINGID],
  @BENEFITID = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[BENEFITID],
  @TARGETSTARTTIME = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[TARGETSTARTTIME],
  @TARGETENDTIME = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[TARGETENDTIME],
  @TIMEZONEENTRYID = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[TIMEZONEENTRYID],
  @ISALLDAYEVENT = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[ISALLDAYEVENT],
  @ACTUALSTARTTIME = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[ACTUALSTARTTIME],
  @ACTUALENDTIME = [BATCHSTEWARDSHIPPLANSTEPUPDATE].[ACTUALENDTIME],
  @STEPPARTICIPANTS = dbo.UFN_BATCHSTEWARDSHIPPLANSTEPUPDATE_GETSTEPPARTICIPANTS_TOITEMLISTXML(BATCHSTEWARDSHIPPLANSTEPUPDATE.ID)
from
  dbo.BATCHSTEWARDSHIPPLANSTEPUPDATE
left join dbo.STEWARDSHIPPLAN [PLAN]
  on BATCHSTEWARDSHIPPLANSTEPUPDATE.STEWARDSHIPPLANID = [PLAN].ID
inner join dbo.STEWARDSHIPPLANSTEP [STEP]
  on [STEP].ID = BATCHSTEWARDSHIPPLANSTEPUPDATE.PRIMARYRECORDID
left join dbo.CONSTITUENT OWNER
    on [PLAN].CONSTITUENTID = OWNER.ID
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME([PLAN].CONSTITUENTID) NF
where
  BATCHSTEWARDSHIPPLANSTEPUPDATE.ID = @ID;

return 0;