USP_DATAFORMTEMPLATE_ADD_BATCHDFUPDATECOMMIT

The save procedure used by the add dataform template "DeceasedRecordFinder Batch Commit Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@VALIDATEONLY	bit	IN	Validate only
@BATCHNUMBER	nvarchar(100)	IN	Batch number
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DECEASEDFINDERID	uniqueidentifier	IN	DeceasedRecordFinder ID
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@DECEASEDDATE	UDT_FUZZYDATE	IN	Deceased date
@DECEASEDCONFIRMATIONCODE	tinyint	IN	Death confirmation
@DECEASEDSOURCECODEID	uniqueidentifier	IN	Source

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHDFUPDATECOMMIT
                    (
                        @ID uniqueidentifier = null output,
                        @VALIDATEONLY bit = 0,
                        @BATCHNUMBER nvarchar(100),
                        @CHANGEAGENTID uniqueidentifier,
                        @DECEASEDFINDERID uniqueidentifier,
                        @CONSTITUENTID uniqueidentifier = null,
                        @DECEASEDDATE UDT_FUZZYDATE = null,
                        @DECEASEDCONFIRMATIONCODE tinyint = null,
                        @DECEASEDSOURCECODEID uniqueidentifier = null
                    )
                    as
                        set nocount on;

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

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

                        declare @STEPCODE tinyint;

                        select
                            @STEPCODE = STEPCODE
                        from 
                            dbo.DECEASEDFINDER
                        where
                            ID = @DECEASEDFINDERID;

                        -- Update DeceasedRecordFinder process step code
                        if @STEPCODE <> 3
                            update 
                                dbo.DECEASEDFINDER
                            set
                                STEPCODE = 3,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE
                            where
                                ID = @DECEASEDFINDERID;

                        if @CONSTITUENTID is not null
                            begin
                                set @ID = @CONSTITUENTID

                                -- make sure the record hasn't already been deceased
                                if exists(select ID from dbo.DECEASEDCONSTITUENT where DECEASEDCONSTITUENT.ID = @CONSTITUENTID)
                                    begin
                                        raiserror ('ERR_CONSTITUENT_ALREADY_DECEASED',13,1);
                                        return 1;
                                    end

                                insert into dbo.DECEASEDCONSTITUENT
                                (
                                    ID, 
                                    DECEASEDDATE, 
                                    ADDEDBYID, 
                                    CHANGEDBYID, 
                                    DATEADDED, 
                                    DATECHANGED, 
                                    DECEASEDCONFIRMATIONCODE, 
                                    DECEASEDSOURCECODEID
                                )
                                values
                                ( 
                                    @CONSTITUENTID,
                                    @DECEASEDDATE, 
                                    @CHANGEAGENTID, 
                                    @CHANGEAGENTID, 
                                    @CURRENTDATE, 
                                    @CURRENTDATE, 
                                    @DECEASEDCONFIRMATIONCODE, 
                                    @DECEASEDSOURCECODEID
                                );

                                exec dbo.USP_CONSTITUENT_DECEASEFROMRULES @CONSTITUENTID, @CHANGEAGENTID;
                            end

                        return 0;