USP_DATAFORMTEMPLATE_EDIT_ADDRESS_6

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.
@ADDRESSTYPECODEID	uniqueidentifier	IN	Type
@PRIMARY	bit	IN	Set as primary address
@DONOTMAIL	bit	IN	Do not send mail to this address
@STARTDATE	UDT_MONTHDAY	IN	Start date
@ENDDATE	UDT_MONTHDAY	IN	End date
@COUNTRYID	uniqueidentifier	IN	Country
@STATEID	uniqueidentifier	IN	State
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(50)	IN	City
@POSTCODE	nvarchar(12)	IN	ZIP
@CART	nvarchar(10)	IN	CART
@DPC	nvarchar(8)	IN	DPC
@LOT	nvarchar(5)	IN	LOT
@OMITFROMVALIDATION	bit	IN	Omit this address from validation
@COUNTYCODEID	uniqueidentifier	IN	County
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN	Congressional district
@STATEHOUSEDISTRICTCODEID	uniqueidentifier	IN	State house district
@STATESENATEDISTRICTCODEID	uniqueidentifier	IN	State senate district
@LOCALPRECINCTCODEID	uniqueidentifier	IN	Local precinct
@INFOSOURCECODEID	uniqueidentifier	IN	Information source
@REGIONCODEID	uniqueidentifier	IN	Region
@LASTVALIDATIONATTEMPTDATE	datetime	IN	Last attempt
@VALIDATIONMESSAGE	nvarchar(200)	IN	Validation message
@CERTIFICATIONDATA	int	IN
@UPDATECONTACTS	bit	IN	Update contacts that use this address
@DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@UPDATEMATCHINGHOUSEHOLDADDRESSES	bit	IN	Update matching addresses in household
@HISTORICALSTARTDATE	date	IN	Start date
@HISTORICALENDDATE	date	IN	End date
@INFOSOURCECOMMENTS	nvarchar(256)	IN	Comments
@ISCONFIDENTIAL	bit	IN	This address is confidential

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_ADDRESS_6
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @ADDRESSTYPECODEID uniqueidentifier,
    @PRIMARY bit,
    @DONOTMAIL bit,
    @STARTDATE dbo.UDT_MONTHDAY,
    @ENDDATE dbo.UDT_MONTHDAY,
    @COUNTRYID uniqueidentifier,
    @STATEID uniqueidentifier,
    @ADDRESSBLOCK nvarchar(150),
    @CITY nvarchar(50),
    @POSTCODE nvarchar(12),
    @CART nvarchar(10),
    @DPC nvarchar(8),
    @LOT nvarchar(5),
    @OMITFROMVALIDATION bit,
    @COUNTYCODEID uniqueidentifier,
    @CONGRESSIONALDISTRICTCODEID uniqueidentifier,
    @STATEHOUSEDISTRICTCODEID uniqueidentifier,
    @STATESENATEDISTRICTCODEID uniqueidentifier,
    @LOCALPRECINCTCODEID uniqueidentifier,
    @INFOSOURCECODEID uniqueidentifier,
    @REGIONCODEID uniqueidentifier,
    @LASTVALIDATIONATTEMPTDATE datetime,
    @VALIDATIONMESSAGE nvarchar(200),
    @CERTIFICATIONDATA integer,
    @UPDATECONTACTS bit,
    @DONOTMAILREASONCODEID uniqueidentifier,
    @UPDATEMATCHINGHOUSEHOLDADDRESSES bit,
    @HISTORICALSTARTDATE date,
    @HISTORICALENDDATE date,
    @INFOSOURCECOMMENTS nvarchar(256),
    @ISCONFIDENTIAL bit
)

as
    set nocount on;

    declare @CONSTITUENTDATAREVIEWROLLBACKREASONID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ADDRESS_4 @ID=@ID, @CONSTITUENTDATAREVIEWROLLBACKREASONID=@CONSTITUENTDATAREVIEWROLLBACKREASONID output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_ADDRESS_7
        @ID,
        @CHANGEAGENTID,
        @ADDRESSTYPECODEID,
        @PRIMARY,
        @DONOTMAIL,
        @STARTDATE,
        @ENDDATE,
        @COUNTRYID,
        @STATEID,
        @ADDRESSBLOCK,
        @CITY,
        @POSTCODE,
        @CART,
        @DPC,
        @LOT,
        @OMITFROMVALIDATION,
        @COUNTYCODEID,
        @CONGRESSIONALDISTRICTCODEID,
        @STATEHOUSEDISTRICTCODEID,
        @STATESENATEDISTRICTCODEID,
        @LOCALPRECINCTCODEID,
        @INFOSOURCECODEID,
        @REGIONCODEID,
        @LASTVALIDATIONATTEMPTDATE,
        @VALIDATIONMESSAGE,
        @CERTIFICATIONDATA,
        @UPDATECONTACTS,
        @DONOTMAILREASONCODEID,
        @UPDATEMATCHINGHOUSEHOLDADDRESSES,
        @HISTORICALSTARTDATE,
        @HISTORICALENDDATE,
        @INFOSOURCECOMMENTS,
        @ISCONFIDENTIAL,
        @CONSTITUENTDATAREVIEWROLLBACKREASONID;

    return 0;