USP_DATAFORMTEMPLATE_EDITLOAD_BATCHADDRESSVALIDATION

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@SEQUENCE	int	INOUT	Sequence
@ADDRESSVALIDATIONID	uniqueidentifier	INOUT	Address validation ID
@COUNTRYID	uniqueidentifier	INOUT	Address 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_EDITLOAD_BATCHADDRESSVALIDATION
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @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;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select @DATALOADED = 1,
        @TSLONG = TSLONG,
        @ADDRESSVALIDATIONID = ADDRESSVALIDATIONID,
        @COUNTRYID = COUNTRYID,
        @ADDRESSID = ADDRESSID,
        @CONSTITUENTID = CONSTITUENTID,
        @ADDRESSBLOCK = ADDRESSBLOCK,
        @CITY = CITY,
        @STATEID = STATEID,
        @POSTCODE = POSTCODE,
        @NEWADDRESSBLOCK = NEWADDRESSBLOCK,
        @NEWCITY = NEWCITY,
        @NEWSTATEID = NEWSTATEID,
        @NEWPOSTCODE = NEWPOSTCODE,
        @NEWCOUNTYID = NEWCOUNTYID,
        @NEWCONGRESSIONALDISTRICTID = NEWCONGRESSIONALDISTRICTID,
        @NEWDPC = NEWDPC,
        @NEWCART = NEWCART,
        @NEWLOT = NEWLOT,
        @VALIDATIONMESSAGE = VALIDATIONMESSAGE,
        @ADDRESSCHANGED = ADDRESSCHANGED,
        @CERTIFICATIONDATA = CERTIFICATIONDATA,
        @SEQUENCE = SEQUENCE
    from dbo.BATCHADDRESSVALIDATION
    where ID = @ID;

    return 0;