USP_DATAFORMTEMPLATE_EDIT_COAUPDATEBATCROW2

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

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.
@SEQUENCE	int	IN	Sequence
@STDADDRESSBLOCK	nvarchar(150)	IN	Standardized address
@STDCITY	nvarchar(50)	IN	Standardized city
@STDSTATEID	uniqueidentifier	IN	Standardized state
@STDPOSTCODE	nvarchar(12)	IN	Standardized ZIP
@STDDPC	nvarchar(8)	IN	Standardized DPC
@STDCART	nvarchar(10)	IN	Standardized CART
@STDLOT	nvarchar(5)	IN	Standardized LOT
@COAADDRESSBLOCK	nvarchar(150)	IN	Change of address
@COACITY	nvarchar(50)	IN	Change of address city
@COASTATEID	uniqueidentifier	IN	Change of address state
@COAPOSTCODE	nvarchar(12)	IN	Change of address ZIP
@COADPC	nvarchar(8)	IN	Change of address DPC
@COACART	nvarchar(10)	IN	Change of address CART
@COALOT	nvarchar(5)	IN	Change of address LOT
@MOVETYPECODE	int	IN	Move type
@COAUPDATEID	uniqueidentifier	IN	AddressFinder ID
@ADDRESSID	uniqueidentifier	IN	Address ID
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(50)	IN	City
@STATEID	uniqueidentifier	IN	State
@POSTCODE	nvarchar(12)	IN	ZIP
@NCOARETURNCODE	tinyint	IN	NCOA return code
@NCOARETURN	nvarchar(150)	IN	NCOA return code
@NCOAFOOTNOTECODE	tinyint	IN	NCOA footnote
@NCOAFOOTNOTE	nvarchar(150)	IN	NCOA footnote
@NCOADPVFOOTNOTECODE	tinyint	IN	NCOA DPV footnote
@NCOADPVFOOTNOTE	nvarchar(150)	IN	NCOA DPV footnote
@NCOAMOVEDATE	UDT_FUZZYDATE	IN	NCOA move date
@NCOADMASUPPRESSION	bit	IN	NCOA DMA suppression
@NCOAMAILGRADECODE	tinyint	IN	NCOA mail grade
@NCOAMAILGRADE	nvarchar(150)	IN	NCOA mail grade

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_COAUPDATEBATCROW2
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @SEQUENCE int,
                        @STDADDRESSBLOCK nvarchar(150),
                        @STDCITY nvarchar(50),
                        @STDSTATEID uniqueidentifier,
                        @STDPOSTCODE nvarchar(12),
                        @STDDPC nvarchar(8),
                        @STDCART nvarchar(10),
                        @STDLOT nvarchar(5),
                        @COAADDRESSBLOCK nvarchar(150),
                        @COACITY nvarchar(50),
                        @COASTATEID uniqueidentifier,
                        @COAPOSTCODE nvarchar(12),
                        @COADPC nvarchar(8),
                        @COACART nvarchar(10),
                        @COALOT nvarchar(5),
                        @MOVETYPECODE int,
                        @COAUPDATEID uniqueidentifier,
                        @ADDRESSID uniqueidentifier,
                        @CONSTITUENTID uniqueidentifier,
                        @ADDRESSBLOCK nvarchar(150),
                        @CITY nvarchar(50),
                        @STATEID uniqueidentifier,
                        @POSTCODE nvarchar(12),
                        @NCOARETURNCODE tinyint,
                        @NCOARETURN nvarchar(150),
                        @NCOAFOOTNOTECODE tinyint,
                        @NCOAFOOTNOTE nvarchar(150),
                        @NCOADPVFOOTNOTECODE tinyint,
                        @NCOADPVFOOTNOTE nvarchar(150),
                        @NCOAMOVEDATE UDT_FUZZYDATE,
                        @NCOADMASUPPRESSION bit,
                        @NCOAMAILGRADECODE tinyint,
                        @NCOAMAILGRADE nvarchar(150)
                    )
                    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;

                        set @MOVETYPECODE = coalesce(@MOVETYPECODE, 0);

                        update dbo.BATCHCOAUPDATE
                        set
                            STDADDRESSBLOCK = @STDADDRESSBLOCK,
                            STDCITY = @STDCITY,
                            STDSTATEID = @STDSTATEID,
                            STDPOSTCODE = @STDPOSTCODE,
                            STDDPC = @STDDPC,
                            STDCART = @STDCART,
                            STDLOT = @STDLOT,
                            COAADDRESSBLOCK = @COAADDRESSBLOCK,
                            COACITY = @COACITY,
                            COASTATEID = @COASTATEID,
                            COAPOSTCODE = @COAPOSTCODE,
                            COADPC = @COADPC,
                            COACART = @COACART,
                            COALOT = @COALOT,
                            MOVETYPECODE = @MOVETYPECODE,
                            SEQUENCE = @SEQUENCE,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where
                            ID = @ID;

                        return 0;