USP_DATAFORMTEMPLATE_VIEW_MARKINDIVIDUALDECEASED

The load procedure used by the view dataform template "Individual Mark Deceased 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.
@DECEASED	bit	INOUT	Deceased?
@DECEASEDDATE	UDT_FUZZYDATE	INOUT	Deceased date
@DECEASEDCONFIRMATION	nvarchar(100)	INOUT	Confirmation
@DECEASEDSOURCE	nvarchar(100)	INOUT	Source

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MARKINDIVIDUALDECEASED
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @DECEASED bit = null output,
                    @DECEASEDDATE dbo.UDT_FUZZYDATE = null output,
                    @DECEASEDCONFIRMATION nvarchar(100) = null output,
                    @DECEASEDSOURCE nvarchar(100) = null output
                )
                as
                set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @DECEASED = case when DECEASEDCONSTITUENT.ID is null then 0 else 1 end,
                    @DECEASEDDATE = DECEASEDCONSTITUENT.DECEASEDDATE,
                    @DECEASEDCONFIRMATION = DECEASEDCONSTITUENT.DECEASEDCONFIRMATION,
                    @DECEASEDSOURCE = DECEASEDSOURCECODE.DESCRIPTION
                from
                    dbo.CONSTITUENT
                left join 
                    dbo.DECEASEDCONSTITUENT 
                on 
                    DECEASEDCONSTITUENT.ID = CONSTITUENT.ID
                left join
                    dbo.DECEASEDSOURCECODE
                on
                    DECEASEDSOURCECODE.ID = DECEASEDCONSTITUENT.DECEASEDSOURCECODEID
                where
                    CONSTITUENT.ID = @ID;

                return 0;