USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTINTERACTIONDETAIL

The load procedure used by the view dataform template "Constituent Interaction Detail View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@PARTICIPANTS	nvarchar(max)	INOUT	Participants
@COMMENT	nvarchar(max)	INOUT	Comment
@BELONGSTO	nvarchar(700)	INOUT	Belongs to
@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
@OBJECTIVE	nvarchar(100)	INOUT	Summary
@OWNER	nvarchar(154)	INOUT	Owner
@TYPE	nvarchar(100)	INOUT	Contact method
@INTERACTIONCATEGORY	nvarchar(100)	INOUT	Category
@INTERACTIONSUBCATEGORY	nvarchar(100)	INOUT	Subcategory
@SITES	nvarchar(1024)	INOUT	Sites
@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_CONSTITUENTINTERACTIONDETAIL
        (
          @ID uniqueidentifier,
          @PARTICIPANTS nvarchar(max) = null output,
          @COMMENT nvarchar(max) = null output,
          @BELONGSTO nvarchar(700) = null output,
          @DATALOADED bit = 0 output,
          @EXPECTEDDATE datetime = null output,
          @ACTUALDATE datetime = null output,
          @STATUS nvarchar(100) = null output,
          @OBJECTIVE nvarchar(100) = null output,
          @OWNER nvarchar(154) = null output,
          @TYPE nvarchar(100) = null output,
          @INTERACTIONCATEGORY nvarchar(100) = null output,
          @INTERACTIONSUBCATEGORY nvarchar(100) = null output,
          @SITES nvarchar(1024) = 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
          set nocount on;

          select
            @PARTICIPANTS = 
              belongs.NAME + 
                (select
                  case
                    when dbo.UDA_BUILDLIST(distinct NF.NAME) = '' then ''
                    else '; ' + dbo.UDA_BUILDLIST(distinct NF.NAME)
                  end
                from dbo.INTERACTIONPARTICIPANT IP
                  outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(IP.CONSTITUENTID) NF
                where IP.INTERACTIONID = @ID),
            @COMMENT = i.COMMENT,
            @BELONGSTO = belongs.NAME,
            @DATALOADED = 1,
            @EXPECTEDDATE = EXPECTEDDATE,
            @ACTUALDATE = ACTUALDATE,
            @STATUS = i.STATUS,
            @OBJECTIVE = i.OBJECTIVE,
            @TYPE = dbo.UFN_INTERACTIONTYPECODE_GETDESCRIPTION(i.INTERACTIONTYPECODEID),
            @OWNER = owns.NAME,
            @INTERACTIONCATEGORY = ic.NAME,
            @INTERACTIONSUBCATEGORY = isc.NAME,
            @SITES = dbo.UFN_CONSTITUENTINTERACTION_GETSITELIST(I.ID),
            @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
            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(i.CONSTITUENTID) belongs
            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(i.FUNDRAISERID) owns
            left join dbo.INTERACTIONSUBCATEGORY isc on i.INTERACTIONSUBCATEGORYID = isc.ID
            left join dbo.INTERACTIONCATEGORY ic on isc.INTERACTIONCATEGORYID = ic.ID
          where I.ID = @ID