USP_DATAFORMTEMPLATE_PRELOAD_BATCHADDRESSVALIDATIONROW

The load procedure used by the edit dataform template "Address Validation Batch Row Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SEQUENCE	int	INOUT	Sequence
@ADDRESSVALIDATIONID	uniqueidentifier	INOUT	Address validation ID
@COUNTRYID	uniqueidentifier	INOUT	Country ID
@ADDRESSID	uniqueidentifier	INOUT	Address ID
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent
@ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@CITY	nvarchar(150)	INOUT	City
@STATEID	uniqueidentifier	INOUT	State
@POSTCODE	nvarchar(10)	INOUT	Zip
@NEWADDRESSBLOCK	nvarchar(150)	INOUT	Validated address
@NEWCITY	nvarchar(150)	INOUT	Validated city
@NEWSTATEID	uniqueidentifier	INOUT	Validated state
@NEWPOSTCODE	nvarchar(10)	INOUT	Validated zip
@NEWCOUNTYID	uniqueidentifier	INOUT	Validated county
@NEWCONGRESSIONALDISTRICTID	uniqueidentifier	INOUT	Validated congressional district
@NEWDPC	nvarchar(8)	INOUT	Validated DPC
@NEWCART	nvarchar(10)	INOUT	Validated CART
@NEWLOT	nvarchar(5)	INOUT	Validated LOT
@VALIDATIONMESSAGE	nvarchar(200)	INOUT	Validation message
@ADDRESSCHANGED	bit	INOUT	Address changed
@CERTIFICATIONDATA	int	INOUT	Certification data

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_BATCHADDRESSVALIDATIONROW
(
    @BATCHID uniqueidentifier,
    @SEQUENCE int = null output,
    @ADDRESSVALIDATIONID uniqueidentifier = null output,
    @COUNTRYID uniqueidentifier = null output,
    @ADDRESSID uniqueidentifier = null output,
    @CONSTITUENTID uniqueidentifier = null output,
    @ADDRESSBLOCK nvarchar(150) = null output,
    @CITY nvarchar(150) = null output,
    @STATEID uniqueidentifier = null output,
    @POSTCODE nvarchar(10) = null output,
    @NEWADDRESSBLOCK nvarchar(150) = null output,
    @NEWCITY nvarchar(150) = null output,
    @NEWSTATEID uniqueidentifier = null output,
    @NEWPOSTCODE nvarchar(10) = null output,
    @NEWCOUNTYID uniqueidentifier = null output,
    @NEWCONGRESSIONALDISTRICTID uniqueidentifier = null output,
    @NEWDPC nvarchar(8) = null output,
    @NEWCART nvarchar(10) = null output,
    @NEWLOT nvarchar(5) = null output,
    @VALIDATIONMESSAGE nvarchar(200) = null output,
    @ADDRESSCHANGED bit = null output,
    @CERTIFICATIONDATA integer = null output
)
as
    set nocount on;    

    return 0;