USP_DATAFORMTEMPLATE_ADD_BATCHADDRESSVALIDATIONROW

The save procedure used by the add dataform template "Address Validation 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.
@SEQUENCE	int	IN	Sequence
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ADDRESSVALIDATIONID	uniqueidentifier	IN	Address validation ID
@COUNTRYID	uniqueidentifier	IN	Country ID
@ADDRESSID	uniqueidentifier	IN	Address ID
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(150)	IN	City
@STATEID	uniqueidentifier	IN	State
@POSTCODE	nvarchar(10)	IN	Zip
@NEWADDRESSBLOCK	nvarchar(150)	IN	Validated address
@NEWCITY	nvarchar(150)	IN	Validated city
@NEWSTATEID	uniqueidentifier	IN	Validated state
@NEWPOSTCODE	nvarchar(10)	IN	Validated zip
@NEWCOUNTYID	uniqueidentifier	IN	Validated county
@NEWCONGRESSIONALDISTRICTID	uniqueidentifier	IN	Validated congressional district
@NEWDPC	nvarchar(8)	IN	Validated DPC
@NEWCART	nvarchar(10)	IN	Validated CART
@NEWLOT	nvarchar(5)	IN	Validated LOT
@VALIDATIONMESSAGE	nvarchar(200)	IN	Validation message
@ADDRESSCHANGED	bit	IN	Address changed
@CERTIFICATIONDATA	int	IN	Certification data

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHADDRESSVALIDATIONROW
(
    @ID uniqueidentifier = null output,
    @BATCHID uniqueidentifier,
    @SEQUENCE int,
    @CHANGEAGENTID uniqueidentifier,
    @ADDRESSVALIDATIONID uniqueidentifier = null,
    @COUNTRYID uniqueidentifier = null,
    @ADDRESSID uniqueidentifier = null,
    @CONSTITUENTID uniqueidentifier = null,
    @ADDRESSBLOCK nvarchar(150) = '',
    @CITY nvarchar(150) = '',
    @STATEID uniqueidentifier = null,
    @POSTCODE nvarchar(10) = '',
    @NEWADDRESSBLOCK nvarchar(150) = '',
    @NEWCITY nvarchar(150) = '',
    @NEWSTATEID uniqueidentifier = null,
    @NEWPOSTCODE nvarchar(10) = '',
    @NEWCOUNTYID uniqueidentifier = null,
    @NEWCONGRESSIONALDISTRICTID uniqueidentifier = null,
    @NEWDPC nvarchar(8) = '',
    @NEWCART nvarchar(10) = '',
    @NEWLOT nvarchar(5) = '',
    @VALIDATIONMESSAGE nvarchar(200) = '',
    @ADDRESSCHANGED bit = null,
    @CERTIFICATIONDATA integer = 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.BATCHADDRESSVALIDATION
    (
        ID,
        BATCHID,
        ADDRESSVALIDATIONID,
        COUNTRYID,
        ADDRESSID,
        CONSTITUENTID,
        ADDRESSBLOCK,
        CITY,
        STATEID,
        POSTCODE,
        NEWADDRESSBLOCK,
        NEWCITY,
        NEWSTATEID,
        NEWPOSTCODE,
        NEWCOUNTYID,
        NEWCONGRESSIONALDISTRICTID,
        NEWDPC,
        NEWCART,
        NEWLOT,
        VALIDATIONMESSAGE,
        ADDRESSCHANGED,
        CERTIFICATIONDATA,
        SEQUENCE,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED
    )
    values
    (
        @ID,
        @BATCHID,
        @ADDRESSVALIDATIONID,
        @COUNTRYID,
        @ADDRESSID,
        @CONSTITUENTID,
        @ADDRESSBLOCK,
        @CITY,
        @STATEID,
        @POSTCODE,
        @NEWADDRESSBLOCK,
        @NEWCITY,
        @NEWSTATEID,
        @NEWPOSTCODE,
        @NEWCOUNTYID,
        @NEWCONGRESSIONALDISTRICTID,
        @NEWDPC,
        @NEWCART,
        @NEWLOT,
        @VALIDATIONMESSAGE,
        @ADDRESSCHANGED,
        @CERTIFICATIONDATA,
        @SEQUENCE,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
    );

    return 0;