USP_DATAFORMTEMPLATE_VIEW_DECEASEDFINDERGETPROCESS

The load procedure used by the view dataform template "DeceasedRecordFinder Get Process 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(100)	INOUT	Step
@STEPCODE	tinyint	INOUT	Step
@SELECTIONNAME	nvarchar(250)	INOUT	Selected constituents
@ADDRESSINCLUDECODE	tinyint	INOUT	Address include code
@ADDRESSTYPECODE	nvarchar(250)	INOUT	Address type code
@CREATEOUTPUTIDSET	bit	INOUT	Create output selection
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@PARAMETERSID	uniqueidentifier	INOUT	Parameterset ID
@FILEUPLOADED	bit	INOUT	File uploaded
@FILEAVAILABLE	bit	INOUT	File available
@FILEDOWNLOADED	bit	INOUT	File downloaded
@DECEASEDFINDERID	uniqueidentifier	INOUT	DeceasedRecordFinder ID
@PROCESSCAPTION	nvarchar(300)	INOUT	Process caption

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DECEASEDFINDERGETPROCESS
                (
                    @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,
                    @FILEAVAILABLE bit = null output,
                    @FILEDOWNLOADED bit = null output,
                    @DECEASEDFINDERID uniqueidentifier = null output,
                    @PROCESSCAPTION nvarchar(300) = 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(SUBMIT.IDSETREGISTERID), 'All constituents'),
                        @ADDRESSINCLUDECODE = SUBMIT.ADDRESSINCLUDECODE,
                        @ADDRESSTYPECODE = dbo.UFN_ADDRESSTYPECODE_GETDESCRIPTION(SUBMIT.ADDRESSTYPECODEID),
                        @CREATEOUTPUTIDSET = SUBMIT.CREATEOUTPUTIDSET,
                        @OUTPUTIDSETNAME = SUBMIT.OUTPUTIDSETNAME,
                        @OVERWRITEOUTPUTIDSET = SUBMIT.OVERWRITEOUTPUTIDSET,
                        @PARAMETERSID = @ID,
                        @FILEUPLOADED = DECEASEDFINDER.FILEUPLOADED,
                        @FILEAVAILABLE = DECEASEDFINDER.FILEAVAILABLE,
                        @FILEDOWNLOADED = DECEASEDFINDER.FILEDOWNLOADED,
                        @DECEASEDFINDERID = DECEASEDFINDER.ID,
                        @PROCESSCAPTION = coalesce(SITE.NAME + ' - ', '') + coalesce(DECEASEDFINDER.NAME, '')
                    from 
                        dbo.DECEASEDFINDERGETPROCESS GET
                    inner join 
                        dbo.DECEASEDFINDER 
                    on 
                        DECEASEDFINDER.ID = GET.DECEASEDFINDERID
                    left join 
                        dbo.SITE 
                    on 
                        DECEASEDFINDER.SITEID = SITE.ID
                    inner join 
                        dbo.DECEASEDFINDERSUBMITPROCESS SUBMIT 
                    on 
                        SUBMIT.DECEASEDFINDERID = DECEASEDFINDER.ID
                    where 
                        GET.ID = @ID;

                    return 0;