USP_DATAFORMTEMPLATE_ADD_BATCHDFUPDATEROW

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@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

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHDFUPDATEROW
                    (
                        @ID uniqueidentifier = null output,
                        @BATCHID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @SEQUENCE int,
                        @DECEASEDFINDERID uniqueidentifier = null,
                        @CONSTITUENTID uniqueidentifier = null,
                        @ADDRESSBLOCK nvarchar(150) = null,
                        @CITY nvarchar(50) = null,
                        @STATEID uniqueidentifier = null,
                        @POSTCODE nvarchar(12) = null,
                        @DECEASEDDATE UDT_FUZZYDATE = '00000000',
                        @DECEASEDCONFIRMATIONCODE tinyint = 0,
                        @DECEASEDSOURCECODEID uniqueidentifier = null                        
                    )
                    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;

                        insert into dbo.BATCHDECEASEDFINDER
                        (
                            ID,
                            BATCHID,
                            DECEASEDFINDERID,
                            CONSTITUENTID,
                            ADDRESSBLOCK,
                            CITY,
                            STATEID,
                            POSTCODE,
                            DECEASEDDATE,
                            DECEASEDCONFIRMATIONCODE,
                            DECEASEDSOURCECODEID,
                            SEQUENCE,
                            ADDEDBYID,
                            CHANGEDBYID,
                            DATEADDED,
                            DATECHANGED
                        )
                        values
                        (
                            @ID,
                            @BATCHID,
                            @DECEASEDFINDERID,
                            @CONSTITUENTID,
                            @ADDRESSBLOCK,
                            @CITY,
                            @STATEID,
                            @POSTCODE,
                            @DECEASEDDATE,
                            @DECEASEDCONFIRMATIONCODE,
                            @DECEASEDSOURCECODEID,
                            @SEQUENCE,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );

                        return 0;