USP_DATAFORMTEMPLATE_VIEW_DECEASEDFINDERPAGEDATA

The load procedure used by the view dataform template "DeceasedRecordFinder Page Expression View"

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.
@FILEUPLOADED	bit	INOUT	File uploaded
@FILEAVAILABLE	bit	INOUT	File available
@FILEDOWNLOADED	bit	INOUT	File downloaded
@DECEASEDFINDERSUBMITPROCESSID	uniqueidentifier	INOUT	DeceasedRecordFinder submit process ID
@DECEASEDFINDERGETPROCESSID	uniqueidentifier	INOUT	DeceasedRecordFinder get process ID
@BATCHID	uniqueidentifier	INOUT	Batch ID
@BATCHSTATUSCODE	tinyint	INOUT	Batch status code
@STEPCODE	tinyint	INOUT	Step code
@NAME	nvarchar(150)	INOUT	Name
@DESCRIPTION	nvarchar(250)	INOUT	Description
@SITEID	uniqueidentifier	INOUT	Site ID
@SITENAME	nvarchar(150)	INOUT	Site name
@PAGECAPTION	nvarchar(300)	INOUT	Page caption
@OUTPUTIDSETNAME	nvarchar(150)	INOUT	Batch output selection name
@CREATEOUTPUTIDSET	bit	INOUT	Batch creates output selection
@DECEASINGOPTIONSSET	nvarchar(150)	INOUT	Deceasing options set
@ALLOWCOMMIT	bit	INOUT	Allow commit
@DECEASEDFINDERCREATEPROCESSID	uniqueidentifier	INOUT

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DECEASEDFINDERPAGEDATA
        (
          @ID uniqueidentifier,
          @DATALOADED bit = 0 output,
          @FILEUPLOADED bit = null output,
          @FILEAVAILABLE bit = null output,
          @FILEDOWNLOADED bit = null output,
          @DECEASEDFINDERSUBMITPROCESSID uniqueidentifier = null output,
          @DECEASEDFINDERGETPROCESSID uniqueidentifier = null output,
          @BATCHID uniqueidentifier = null output,
          @BATCHSTATUSCODE tinyint = null output,
          @STEPCODE tinyint = null output,
          @NAME nvarchar(150) = null output,
          @DESCRIPTION nvarchar(250) = null output,
          @SITEID uniqueidentifier = null output,
          @SITENAME nvarchar(150) = null output,
          @PAGECAPTION nvarchar(300) = null output,
          @OUTPUTIDSETNAME nvarchar(150) = null output,
          @CREATEOUTPUTIDSET bit = null output,
          @DECEASINGOPTIONSSET nvarchar(150) = null output,
          @ALLOWCOMMIT bit = null output,
          @DECEASEDFINDERCREATEPROCESSID uniqueidentifier = null output
        )
        as
          set nocount on;

          set @DATALOADED = 0;

          select @DATALOADED = 1,
            @FILEUPLOADED = DECEASEDFINDER.FILEUPLOADED,
            @FILEAVAILABLE = DECEASEDFINDER.FILEAVAILABLE,
            @FILEDOWNLOADED = DECEASEDFINDER.FILEDOWNLOADED,
            @DECEASEDFINDERSUBMITPROCESSID = SUBMIT.ID,
            @DECEASEDFINDERGETPROCESSID = GET.ID,
            @BATCHID = DECEASEDFINDER.BATCHID,
            @BATCHSTATUSCODE = dbo.UFN_BATCH_GETSTATUSCODE(DECEASEDFINDER.BATCHID),
            @STEPCODE = DECEASEDFINDER.STEPCODE,
            @NAME = DECEASEDFINDER.NAME,
            @DESCRIPTION = DECEASEDFINDER.DESCRIPTION,
            @SITEID = DECEASEDFINDER.SITEID,
            @SITENAME = SITE.NAME,
            @PAGECAPTION = coalesce(SITE.NAME + ' - ', '') + coalesce(DECEASEDFINDER.NAME, ''),
            @CREATEOUTPUTIDSET = BATCH.CREATEOUTPUTIDSET,
            @OUTPUTIDSETNAME = BATCH.OUTPUTIDSETNAME,
            @DECEASEDFINDERCREATEPROCESSID = [DECEASEDFINDERCREATEPROCESS].[ID]
          from 
            dbo.DECEASEDFINDER
          inner join
            dbo.[DECEASEDFINDERCREATEPROCESS]
          on
            [DECEASEDFINDER].[ID] = [DECEASEDFINDERCREATEPROCESS].[DECEASEDFINDERID]
          inner join 
            dbo.DECEASEDFINDERSUBMITPROCESS SUBMIT 
          on 
            SUBMIT.DECEASEDFINDERID = DECEASEDFINDER.ID
          inner join 
            dbo.DECEASEDFINDERGETPROCESS GET 
          on 
            GET.DECEASEDFINDERID = DECEASEDFINDER.ID
          inner join
            dbo.BATCH
          on
            BATCH.ID = DECEASEDFINDER.BATCHID
          left join 
            dbo.SITE 
          on 
            DECEASEDFINDER.SITEID = SITE.ID
          where 
            DECEASEDFINDER.ID = @ID;

          if @DATALOADED = 1
            select @ALLOWCOMMIT = BWS.ALLOWCOMMIT
            from dbo.BATCHWORKFLOWSTATE BWS
            inner join dbo.BATCHWORKFLOW BW on BW.ID = BWS.BATCHWORKFLOWID
            where BW.BATCHTYPECATALOGID = 'CAE84EC7-C986-43CF-ABE1-2974A91A6EA8'

          select 
            @DECEASINGOPTIONSSET = dbo.UFN_DECEASINGOPTION_GETRULES.RULESSET
          from            
            dbo.UFN_DECEASINGOPTION_GETRULES();

          return 0;