USP_DATAFORMTEMPLATE_ADD_BATCHPEOPLEFINDERBATCHROW

The save procedure used by the add dataform template "PeopleFinder Batch Row Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@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
@NEWSTATEID	uniqueidentifier	IN	New state ID
@ISDECEASED	bit	IN	Deceased

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHPEOPLEFINDERBATCHROW(
    @ID uniqueidentifier = null output,
    @BATCHID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SEQUENCE int,
    @PEOPLEFINDERID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier = null,
    @OLDADDRESSID uniqueidentifier = null,
    @NEWADDRESSBLOCK nvarchar(150) = null,
    @NEWCITY nvarchar(50) = null,
    @NEWPOSTCODE nvarchar(12) = null,
    @OTHERLASTNAME nvarchar(100) = null,
    @NEWPHONENUMBER nvarchar(100) = null,
    @NEWADDRESSINFOSOURCE nvarchar(20) = null,
    @DECEASEDYEAR dbo.UDT_FUZZYDATE = null,
    @DECEASEDYEARDISPLAY nvarchar(4) = null,
    @CONFIDENCELEVEL smallint = null,    
    @SENDMAIL bit = null,
    @NEWSTATEID uniqueidentifier = null,
    @ISDECEASED bit = null
) 
as

    set nocount on;

    declare @CURRENTDATE datetime;

    if @ID is null
        set @ID = newid();

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    set @CURRENTDATE = getdate();

  if @ISDECEASED = 1
    begin
      if len(@DECEASEDYEAR) <> 8 
        begin
          set @DECEASEDYEAR = LEFT(@DECEASEDYEAR,4) + '0000'
        end
    end
  else
    begin
      set @DECEASEDYEAR = '00000000'
    end

    begin try
        insert into dbo.BATCHPEOPLEFINDER
        (
      ID,
      BATCHID,
      ADDEDBYID,
      CHANGEDBYID,
      DATEADDED,
      DATECHANGED,
      SEQUENCE,
      PEOPLEFINDERID,
      CONSTITUENTID,
      OLDADDRESSID,
      NEWADDRESSBLOCK,
      NEWCITY,
      NEWPOSTCODE,
      OTHERLASTNAME,
      NEWPHONENUMBER,
      NEWADDRESSINFOSOURCE,
      DECEASEDYEAR,
      CONFIDENCELEVEL,
      SENDMAIL,
      NEWSTATEID,
      ISDECEASED
        ) 
        values 
        (
      @ID,
      @BATCHID,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE,
      @SEQUENCE,
      @PEOPLEFINDERID,
      @CONSTITUENTID,
      @OLDADDRESSID,
      @NEWADDRESSBLOCK,
      @NEWCITY,
      @NEWPOSTCODE,
      @OTHERLASTNAME,
      @NEWPHONENUMBER,
      @NEWADDRESSINFOSOURCE,
      @DECEASEDYEAR,
      @CONFIDENCELEVEL,
      @SENDMAIL,
      @NEWSTATEID,
      @ISDECEASED
        );
    end try
    begin catch
        exec.dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;