USP_DATAFORMTEMPLATE_VIEW_DECEASEDFINDERTUNEUP

The load procedure used by the view dataform template "DeceasedRecordFinder Tune-Up 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.
@DATELASTRUN	datetime	INOUT	Date last run
@DESCRIPTION	nvarchar(250)	INOUT	Description
@STEP	nvarchar(250)	INOUT	Step
@STEPCODE	tinyint	INOUT	Step
@SELECTIONNAME	nvarchar(250)	INOUT	Selected constituents
@ADDRESSINCLUDECODE	tinyint	INOUT	All addresses
@ADDRESSTYPECODE	nvarchar(250)	INOUT	Address type code
@PRIMARYCONTACTNAME	nvarchar(250)	INOUT	Primary contact name
@PRIMARYCONTACTEMAIL	UDT_EMAILADDRESS	INOUT	Primary contact email address
@PRIMARYCONTACTPHONE	nvarchar(20)	INOUT	Primary contact phone number
@FILEAVAILABLE	bit	INOUT	FILEAVAILABLE

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DECEASEDFINDERTUNEUP
        (
          @ID uniqueidentifier,
          @DATALOADED bit = 0 output,
          @DATELASTRUN datetime = null output,
          @DESCRIPTION nvarchar(250) = null output,
          @STEP nvarchar(250) = null output,
          @STEPCODE tinyint = null output,
          @SELECTIONNAME nvarchar(250) = null output,
          @ADDRESSINCLUDECODE    tinyint = null output,
          @ADDRESSTYPECODE nvarchar(250) = null output,
          @PRIMARYCONTACTNAME nvarchar(250) = null output,
          @PRIMARYCONTACTEMAIL dbo.UDT_EMAILADDRESS = null output,
          @PRIMARYCONTACTPHONE nvarchar(20) = null output,
          @FILEAVAILABLE bit = null output
        )
        as
        set nocount on;

        set @DATALOADED = 0;

        select 
          @DATALOADED = 1,
          @DATELASTRUN = DECEASEDFINDER.DATELASTRUN,
          @DESCRIPTION = DECEASEDFINDER.DESCRIPTION,
          @STEP = DECEASEDFINDER.STEP,
          @STEPCODE = DECEASEDFINDER.STEPCODE,
          @SELECTIONNAME = coalesce(dbo.UFN_IDSET_GETNAME([CREATE].IDSETREGISTERID), 'All constituents'),
          @ADDRESSINCLUDECODE = [CREATE].ADDRESSINCLUDECODE,
          @ADDRESSTYPECODE = dbo.UFN_ADDRESSTYPECODE_GETDESCRIPTION([CREATE].ADDRESSTYPECODEID),
          @PRIMARYCONTACTNAME = DECEASEDFINDER.PRIMARYCONTACTNAME,
          @PRIMARYCONTACTEMAIL = DECEASEDFINDER.PRIMARYCONTACTEMAIL,
          @PRIMARYCONTACTPHONE = DECEASEDFINDER.PRIMARYCONTACTPHONE,
          @FILEAVAILABLE = DECEASEDFINDER.FILEAVAILABLE
        from 
          dbo.DECEASEDFINDER
        left join 
          dbo.DECEASEDFINDERCREATEPROCESS [CREATE] 
        on 
          [CREATE].DECEASEDFINDERID = DECEASEDFINDER.ID
        where 
          DECEASEDFINDER.ID = @ID;

        return 0;