USP_DATAFORMTEMPLATE_ADD_BATCHCOAUPDATEROW
The save procedure used by the add dataform template "AddressFinder 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 |
| @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_ADD_BATCHCOAUPDATEROW
(
@ID uniqueidentifier = null output,
@BATCHID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@SEQUENCE int,
@STDADDRESSBLOCK nvarchar(150) = '',
@STDCITY nvarchar(50) = '',
@STDSTATEID uniqueidentifier = null,
@STDPOSTCODE nvarchar(12) = '',
@STDDPC nvarchar(8) = '',
@STDCART nvarchar(10) = '',
@STDLOT nvarchar(5) = '',
@COAADDRESSBLOCK nvarchar(150) = '',
@COACITY nvarchar(50) = '',
@COASTATEID uniqueidentifier = null,
@COAPOSTCODE nvarchar(12) = '',
@COADPC nvarchar(8) = '',
@COACART nvarchar(10) = '',
@COALOT nvarchar(5) = '',
@MOVETYPECODE int = 0,
@COAUPDATEID uniqueidentifier = null,
@ADDRESSID uniqueidentifier = null,
@CONSTITUENTID uniqueidentifier = null,
@ADDRESSBLOCK nvarchar(150) = '',
@CITY nvarchar(50) = '',
@STATEID uniqueidentifier = null,
@POSTCODE nvarchar(12) = '',
@NCOARETURNCODE tinyint = 0,
@NCOARETURN nvarchar(150) = '',
@NCOAFOOTNOTECODE tinyint = 0,
@NCOAFOOTNOTE nvarchar(150) = '',
@NCOADPVFOOTNOTECODE tinyint = 0,
@NCOADPVFOOTNOTE nvarchar(150) = '',
@NCOAMOVEDATE UDT_FUZZYDATE = '00000000',
@NCOADMASUPPRESSION bit = 0,
@NCOAMAILGRADECODE tinyint = 0,
@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);
insert into dbo.BATCHCOAUPDATE
(
ID,
BATCHID,
STDADDRESSBLOCK,
STDCITY,
STDSTATEID,
STDPOSTCODE,
STDDPC,
STDCART,
STDLOT,
COAADDRESSBLOCK,
COACITY,
COASTATEID,
COAPOSTCODE,
COADPC,
COACART,
COALOT,
MOVETYPECODE,
SEQUENCE,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED,
COAUPDATEID,
ADDRESSID,
CONSTITUENTID,
ADDRESSBLOCK,
CITY,
STATEID,
POSTCODE,
NCOARETURNCODE,
NCOAFOOTNOTECODE,
NCOADPVFOOTNOTECODE,
NCOAMOVEDATE,
NCOADMASUPPRESSION,
NCOAMAILGRADECODE
)
values
(
@ID,
@BATCHID,
@STDADDRESSBLOCK,
@STDCITY,
@STDSTATEID,
@STDPOSTCODE,
@STDDPC,
@STDCART,
@STDLOT,
@COAADDRESSBLOCK,
@COACITY,
@COASTATEID,
@COAPOSTCODE,
@COADPC,
@COACART,
@COALOT,
@MOVETYPECODE,
@SEQUENCE,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE,
@COAUPDATEID,
@ADDRESSID,
@CONSTITUENTID,
@ADDRESSBLOCK,
@CITY,
@STATEID,
@POSTCODE,
@NCOARETURNCODE,
@NCOAFOOTNOTECODE,
@NCOADPVFOOTNOTECODE,
@NCOAMOVEDATE,
@NCOADMASUPPRESSION,
@NCOAMAILGRADECODE
);
return 0;