USP_DATAFORMTEMPLATE_VIEW_DECEASEDFINDERCREATEPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@DATELASTRUN	datetime	INOUT
@DESCRIPTION	nvarchar(250)	INOUT
@STEP	nvarchar(100)	INOUT
@STEPCODE	tinyint	INOUT
@SELECTIONNAME	nvarchar(250)	INOUT
@ADDRESSINCLUDECODE	tinyint	INOUT
@ADDRESSTYPECODE	nvarchar(250)	INOUT
@CREATEOUTPUTIDSET	bit	INOUT
@OUTPUTIDSETNAME	nvarchar(100)	INOUT
@OVERWRITEOUTPUTIDSET	bit	INOUT
@PARAMETERSID	uniqueidentifier	INOUT
@FILEUPLOADED	bit	INOUT
@FILEDOWNLOADED	bit	INOUT
@DECEASEDFINDERID	uniqueidentifier	INOUT
@DECEASEDFINDERRESUBMITPROCESSID	uniqueidentifier	INOUT
@PROCESSCAPTION	nvarchar(300)	INOUT
@BATCHSTATUSCODE	tinyint	INOUT

Definition

Copy



        create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DECEASEDFINDERCREATEPROCESS
        (
          @ID uniqueidentifier,
          @DATALOADED bit = 0 output,
          @DATELASTRUN datetime = null output,
          @DESCRIPTION nvarchar(250) = null output,
          @STEP nvarchar(100) = null output,
          @STEPCODE tinyint = null output,
          @SELECTIONNAME nvarchar(250) = null output,
          @ADDRESSINCLUDECODE tinyint = null output,
          @ADDRESSTYPECODE nvarchar(250) = null output,
          @CREATEOUTPUTIDSET bit = null output,
          @OUTPUTIDSETNAME nvarchar(100) = null output,
          @OVERWRITEOUTPUTIDSET bit = null output,
          @PARAMETERSID uniqueidentifier = null output,
          @FILEUPLOADED bit = null output,
          @FILEDOWNLOADED bit = null output,
          @DECEASEDFINDERID uniqueidentifier = null output,
          @DECEASEDFINDERRESUBMITPROCESSID uniqueidentifier = null output,
          @PROCESSCAPTION nvarchar(300) = null output,
          @BATCHSTATUSCODE tinyint = 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),
            @CREATEOUTPUTIDSET = [CREATE].CREATEOUTPUTIDSET,
            @OUTPUTIDSETNAME = [CREATE].OUTPUTIDSETNAME,
            @OVERWRITEOUTPUTIDSET = [CREATE].OVERWRITEOUTPUTIDSET,
            @PARAMETERSID = @ID,
            @FILEUPLOADED = DECEASEDFINDER.FILEUPLOADED,
            @FILEDOWNLOADED = DECEASEDFINDER.FILEDOWNLOADED,
            @DECEASEDFINDERID = DECEASEDFINDER.ID,
            @DECEASEDFINDERRESUBMITPROCESSID = RESUBMIT.ID,
            @PROCESSCAPTION = coalesce(SITE.NAME + ' - ', '') + coalesce(DECEASEDFINDER.NAME, ''),
            @BATCHSTATUSCODE = dbo.UFN_BATCH_GETSTATUSCODE(DECEASEDFINDER.BATCHID)
          from 
            dbo.DECEASEDFINDERCREATEPROCESS [CREATE]
          inner join 
            dbo.DECEASEDFINDER 
          on 
            DECEASEDFINDER.ID = [CREATE].DECEASEDFINDERID
          left join 
            dbo.SITE 
          on 
            DECEASEDFINDER.SITEID = dbo.SITE.ID
          inner join 
            dbo.DECEASEDFINDERGETPROCESS GET 
          on 
            DECEASEDFINDER.ID = GET.DECEASEDFINDERID
          inner join 
            dbo.DECEASEDFINDERRESUBMITPROCESS RESUBMIT 
          on 
            RESUBMIT.DECEASEDFINDERID = DECEASEDFINDER.ID
          where 
            [CREATE].ID = @ID;

          return 0;