USP_DATAFORMTEMPLATE_EDIT_COAUPDATEPROCESSOPTIONS

The save procedure used by the edit dataform template "AddressFinder Process Options Edit Data Form".

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.
@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
@INFOSOURCECODEID	uniqueidentifier	IN	Information source

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_COAUPDATEPROCESSOPTIONS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @UPDATEADDRESSCODE tinyint,
    @SAVEFORMERADDRESS bit,
    @ADDRESSTYPECODEID uniqueidentifier,
    @FOOTNOTECODE1REASONCODEID uniqueidentifier,
    @FOOTNOTECODE2REASONCODEID uniqueidentifier,
    @FOOTNOTECODE3REASONCODEID uniqueidentifier,
    @FOOTNOTECODE4REASONCODEID uniqueidentifier,
    @FOOTNOTECODE5REASONCODEID uniqueidentifier,
    @FOOTNOTECODE6REASONCODEID uniqueidentifier,
    @FOOTNOTECODE7REASONCODEID uniqueidentifier,
    @INFOSOURCECODEID uniqueidentifier
)

as
    set nocount on;

    declare @MAILGRADEFREASONCODEID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_COAUPDATEPROCESSOPTIONS
        @ID = @ID,
        @MAILGRADEFREASONCODEID = @MAILGRADEFREASONCODEID output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_COAUPDATEPROCESSOPTIONS_2
        @ID,
        @CHANGEAGENTID,
        @UPDATEADDRESSCODE,
        @SAVEFORMERADDRESS,
        @ADDRESSTYPECODEID,
        @FOOTNOTECODE1REASONCODEID,
        @FOOTNOTECODE2REASONCODEID,
        @FOOTNOTECODE3REASONCODEID,
        @FOOTNOTECODE4REASONCODEID,
        @FOOTNOTECODE5REASONCODEID,
        @FOOTNOTECODE6REASONCODEID,
        @FOOTNOTECODE7REASONCODEID,
        @INFOSOURCECODEID,
        @MAILGRADEFREASONCODEID

  return 0;