USP_DATAFORMTEMPLATE_VIEW_STEWARDSHIPPLANSTEP_PAGEDATA

The load procedure used by the view dataform template "Stewardship Plan Step Page Expression 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.
@PLANID	uniqueidentifier	INOUT	PLANID
@CONSTITUENTNAME	nvarchar(154)	INOUT	CONSTITUENTNAME
@DATE	datetime	INOUT	DATE
@ATTRIBUTEDEFINED	bit	INOUT	ATTRIBUTEDEFINED
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CONSTITUENTID	uniqueidentifier	INOUT	CONSTITUENTID
@PLANNAME	nvarchar(100)	INOUT	PLANNAME

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STEWARDSHIPPLANSTEP_PAGEDATA 
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @PLANID uniqueidentifier = null output,
  @CONSTITUENTNAME nvarchar(154) = null output,
  @DATE datetime = null output,
  @ATTRIBUTEDEFINED bit = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @CONSTITUENTID uniqueidentifier = null output,
  @PLANNAME nvarchar(100) = null output
)
as begin
  set nocount on;

  set @DATALOADED = 0;

  select 
    @DATALOADED = 1,
    @PLANID = STEWARDSHIPPLAN.ID,
    @PLANNAME = STEWARDSHIPPLAN.NAME,
    @CONSTITUENTID = STEWARDSHIPPLAN.CONSTITUENTID,
    @CONSTITUENTNAME = NF.NAME,
    @DATE = STEWARDSHIPPLANSTEP.DATE,
    @ATTRIBUTEDEFINED = dbo.UFN_ATTRIBUTECATEGORY_DEFINEDFORRECORDTYPE_FORAPPUSER('Stewardship Plan Step', @CURRENTAPPUSERID)
  from
    dbo.STEWARDSHIPPLANSTEP
  inner join
    dbo.STEWARDSHIPPLAN on STEWARDSHIPPLAN.ID = STEWARDSHIPPLANSTEP.PLANID
  cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(STEWARDSHIPPLAN.CONSTITUENTID) NF
  where
    STEWARDSHIPPLANSTEP.ID = @ID

  return 0;
end