USP_DATAFORMTEMPLATE_EDIT_DFUPDATEBATCHROW

The save procedure used by the edit dataform template "DeceasedRecordFinder Batch Row Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DECEASEDFINDERID	uniqueidentifier	IN	DeceasedRecordFinder ID
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(50)	IN	City
@STATEID	uniqueidentifier	IN	State
@POSTCODE	nvarchar(12)	IN	ZIP
@DECEASEDDATE	UDT_FUZZYDATE	IN	Deceased date
@DECEASEDCONFIRMATIONCODE	tinyint	IN	Death confirmation
@DECEASEDSOURCECODEID	uniqueidentifier	IN	Source
@SEQUENCE	int	IN	Sequence

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DFUPDATEBATCHROW
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @DECEASEDFINDERID uniqueidentifier,
                        @CONSTITUENTID uniqueidentifier,
                        @ADDRESSBLOCK nvarchar(150),
                        @CITY nvarchar(50),
                        @STATEID uniqueidentifier,
                        @POSTCODE nvarchar(12),
                        @DECEASEDDATE UDT_FUZZYDATE,
                        @DECEASEDCONFIRMATIONCODE tinyint,
                        @DECEASEDSOURCECODEID uniqueidentifier,
                        @SEQUENCE int
                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                        if @ID is null
                            set @ID = NewID();

                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        update 
                            dbo.BATCHDECEASEDFINDER
                        set
                            DECEASEDDATE = @DECEASEDDATE,
                            DECEASEDCONFIRMATIONCODE = @DECEASEDCONFIRMATIONCODE,
                            DECEASEDSOURCECODEID = @DECEASEDSOURCECODEID,
                            SEQUENCE = @SEQUENCE,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where
                            ID = @ID;

                        return 0;