USP_DATAFORMTEMPLATE_EDIT_BATCHPEOPLEFINDERBATCHROW

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.
@SEQUENCE	int	IN	Sequence
@PEOPLEFINDERID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@OLDADDRESSID	uniqueidentifier	IN
@NEWADDRESSBLOCK	nvarchar(150)	IN	New address
@NEWCITY	nvarchar(50)	IN	New city
@NEWPOSTCODE	nvarchar(12)	IN	New zip
@OTHERLASTNAME	nvarchar(100)	IN	Other last name
@NEWPHONENUMBER	nvarchar(100)	IN	New phone number
@NEWADDRESSINFOSOURCE	nvarchar(20)	IN	New address info source
@DECEASEDYEAR	UDT_FUZZYDATE	IN	Year deceased
@DECEASEDYEARDISPLAY	nvarchar(4)	IN	Year deceased
@CONFIDENCELEVEL	smallint	IN	Confidence level
@SENDMAIL	bit	IN	Send mail
@NEWSTATE	nvarchar(50)	IN	New state
@ISDECEASED	bit	IN	Deceased
@NEWSTATEID	uniqueidentifier	IN
@CONFIDENCELEVELLETTER	nvarchar(1)	IN	Confidence level

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BATCHPEOPLEFINDERBATCHROW
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @SEQUENCE int,
  @PEOPLEFINDERID uniqueidentifier,
  @CONSTITUENTID uniqueidentifier,
  @OLDADDRESSID uniqueidentifier,
  @NEWADDRESSBLOCK nvarchar(150),
  @NEWCITY nvarchar(50),
  @NEWPOSTCODE nvarchar(12),
  @OTHERLASTNAME nvarchar(100),
  @NEWPHONENUMBER nvarchar(100),
  @NEWADDRESSINFOSOURCE nvarchar(20),
  @DECEASEDYEAR dbo.UDT_FUZZYDATE,
  @DECEASEDYEARDISPLAY nvarchar(4),
  @CONFIDENCELEVEL smallint,
  @SENDMAIL bit,
  @NEWSTATE nvarchar(50),
  @ISDECEASED bit,
  @NEWSTATEID uniqueidentifier,
  @CONFIDENCELEVELLETTER nvarchar(1)
)
as
  set nocount on;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHPEOPLEFINDERBATCHROW
    @ID = @ID;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHPEOPLEFINDERBATCHROW_2
    @ID,
    @CHANGEAGENTID,
    @SEQUENCE,
    @PEOPLEFINDERID,
    @CONSTITUENTID,
    @OLDADDRESSID,
    @NEWADDRESSBLOCK,
    @NEWCITY,
    @NEWPOSTCODE,
    @OTHERLASTNAME,
    @NEWPHONENUMBER,
    @NEWADDRESSINFOSOURCE,
    @DECEASEDYEAR,
    @DECEASEDYEARDISPLAY,
    @CONFIDENCELEVEL,
    @SENDMAIL,
    @ISDECEASED,
    @NEWSTATEID;

  return 0;