USP_DATAFORMTEMPLATE_EDIT_DATATUNEUP

Previous save procedure from DataTuneUp.Edit.xml

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.
@ADDRESSFORMATTINGCODE	tinyint	IN	Address formatting
@DONOTABBREVIATE	bit	IN	Do not abbreviate address elements according to USPS format
@CAPITALIZE	bit	IN	Capitalize the entire address
@UPDATEADDRESSCODE	tinyint	IN	Update addresses
@SAVEFORMERADDRESS	bit	IN	Save former address in constituent address list when there is a forwardable move
@ADDRESSTYPECODEID	uniqueidentifier	IN	Set address type on former address to
@FOOTNOTECODE1REASONCODEID	uniqueidentifier	IN	Forwardable move
@FOOTNOTECODE2REASONCODEID	uniqueidentifier	IN	Moved with no forwarding address
@FOOTNOTECODE3REASONCODEID	uniqueidentifier	IN	PO box closed
@FOOTNOTECODE4REASONCODEID	uniqueidentifier	IN	Move to foreign address
@FOOTNOTECODE5REASONCODEID	uniqueidentifier	IN	Forwardable move, but secondary address cannot be verified
@FOOTNOTECODE6REASONCODEID	uniqueidentifier	IN	Change of address form filed, but new address not in USPS records
@FOOTNOTECODE7REASONCODEID	uniqueidentifier	IN	Temporary address has lapsed

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DATATUNEUP
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @ADDRESSFORMATTINGCODE tinyint,
    @DONOTABBREVIATE bit,
    @CAPITALIZE bit,
    @UPDATEADDRESSCODE tinyint,
    @SAVEFORMERADDRESS bit,
    @ADDRESSTYPECODEID uniqueidentifier,
    @FOOTNOTECODE1REASONCODEID uniqueidentifier,
    @FOOTNOTECODE2REASONCODEID uniqueidentifier,
    @FOOTNOTECODE3REASONCODEID uniqueidentifier,
    @FOOTNOTECODE4REASONCODEID uniqueidentifier,
    @FOOTNOTECODE5REASONCODEID uniqueidentifier,
    @FOOTNOTECODE6REASONCODEID uniqueidentifier,
    @FOOTNOTECODE7REASONCODEID uniqueidentifier
)
as
    set nocount on;

    declare @INFOSOURCECODEID uniqueidentifier;
    declare @ADDRESSVALIDATION_INFOSOURCECODEID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DATATUNEUP @ID = @ID, @INFOSOURCECODEID = @INFOSOURCECODEID output, 
    @ADDRESSVALIDATION_INFOSOURCECODEID = @ADDRESSVALIDATION_INFOSOURCECODEID output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_DATATUNEUP_2 @ID, @CHANGEAGENTID, @ADDRESSFORMATTINGCODE, @DONOTABBREVIATE, @CAPITALIZE, @UPDATEADDRESSCODE, @SAVEFORMERADDRESS, @ADDRESSTYPECODEID, @FOOTNOTECODE1REASONCODEID, @FOOTNOTECODE2REASONCODEID, @FOOTNOTECODE3REASONCODEID, @FOOTNOTECODE4REASONCODEID, @FOOTNOTECODE5REASONCODEID, @FOOTNOTECODE6REASONCODEID, @FOOTNOTECODE7REASONCODEID, @INFOSOURCECODEID,
    @ADDRESSVALIDATION_INFOSOURCECODEID;