USP_DATAFORMTEMPLATE_VIEW_STEP

The load procedure used by the view dataform template "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.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@EXPECTEDDATE	datetime	INOUT	Expected date
@ACTUALDATE	datetime	INOUT	Actual date
@STATUS	nvarchar(100)	INOUT	Status
@FUNDRAISER	nvarchar(700)	INOUT	Owner
@OBJECTIVE	nvarchar(100)	INOUT	Objective
@PROSPECTPLANSTATUS	nvarchar(100)	INOUT	Stage
@COMMENT	nvarchar(max)	INOUT	Comment
@INTERACTIONTYPE	nvarchar(100)	INOUT	Contact method
@ADDITIONALFUNDRAISERS	nvarchar(max)	INOUT	Additional solicitors
@PROSPECTPLANTYPE	nvarchar(100)	INOUT	Plan type
@PROSPECTPLANSTAGETYPE	nvarchar(100)	INOUT	plan stage
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	INOUT	Expected start time
@EXPECTEDENDTIME	UDT_HOURMINUTE	INOUT	Expected end time
@TIMEZONE	nvarchar(255)	INOUT	Time zone
@ACTUALSTARTTIME	UDT_HOURMINUTE	INOUT	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	INOUT	Actual end time
@LOCATION	nvarchar(300)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STEP
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @EXPECTEDDATE datetime = null output,
  @ACTUALDATE datetime = null output,
  @STATUS nvarchar(100) = null output,
  @FUNDRAISER nvarchar(700) = null output,
  @OBJECTIVE nvarchar(100) = null output,
  @PROSPECTPLANSTATUS nvarchar(100) = null output,
  @COMMENT nvarchar(max) = null output,
  @INTERACTIONTYPE nvarchar(100) = null output,
  @ADDITIONALFUNDRAISERS nvarchar(max) = null output,
  @PROSPECTPLANTYPE nvarchar(100) = null output,
  @PROSPECTPLANSTAGETYPE nvarchar(100) = null output,
  @EXPECTEDSTARTTIME dbo.UDT_HOURMINUTE = null output,
  @EXPECTEDENDTIME dbo.UDT_HOURMINUTE = null output,
  @TIMEZONE nvarchar(255) = null output,
  @ACTUALSTARTTIME dbo.UDT_HOURMINUTE = null output,
  @ACTUALENDTIME dbo.UDT_HOURMINUTE = null output,
  @LOCATION nvarchar(300) = null output
) as begin
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @EXPECTEDDATE = I.EXPECTEDDATE,
    @ACTUALDATE = I.ACTUALDATE,
    @STATUS = I.STATUS,
    @FUNDRAISER = FUNDRAISER_NF.NAME,
    @OBJECTIVE = I.OBJECTIVE,
    @PROSPECTPLANSTATUS = dbo.UFN_PROSPECTPLANSTATUSCODE_GETDESCRIPTION(I.PROSPECTPLANSTATUSCODEID),
    @COMMENT = I.COMMENT,
    @INTERACTIONTYPE = ITC.DESCRIPTION,
    @ADDITIONALFUNDRAISERS = dbo.UFN_BUILDSTEPFUNDRAISERSLIST(I.ID),
    -- PROSPECTPLANTYPE and PROSPECTPLANSTAGETYPE are included for backwards compatibility

    -- since this dataform replaced InteractionMove.View.xml in Step.Page.xml

    @PROSPECTPLANTYPE = dbo.UFN_PROSPECTPLANTYPECODE_GETDESCRIPTION(PP.PROSPECTPLANTYPECODEID),
    @PROSPECTPLANSTAGETYPE = dbo.UFN_PROSPECTPLANSTATUSCODE_GETDESCRIPTION(I.PROSPECTPLANSTATUSCODEID),
    @EXPECTEDSTARTTIME = I.EXPECTEDSTARTTIME,
    @EXPECTEDENDTIME = I.EXPECTEDENDTIME,
    @TIMEZONE = (select DISPLAYNAME from TIMEZONEENTRY where TIMEZONEENTRY.ID = I.TIMEZONEENTRYID),
    @ACTUALSTARTTIME = I.ACTUALSTARTTIME,
    @ACTUALENDTIME = I.ACTUALENDTIME,
    @LOCATION = I.LOCATION
  from dbo.INTERACTION I
    inner join dbo.PROSPECTPLAN PP on I.PROSPECTPLANID = PP.ID
    left join dbo.INTERACTIONTYPECODE ITC on I.INTERACTIONTYPECODEID = ITC.ID
    left join dbo.INTERACTIONADDITIONALFUNDRAISER IAF on I.ID = IAF.INTERACTIONID
    left join dbo.CONSTITUENT AFC on IAF.FUNDRAISERID = AFC.ID
    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(I.FUNDRAISERID) FUNDRAISER_NF
  where I.ID = @ID;

  return 0;
end