USP_DATAFORMTEMPLATE_EDIT_INDIVIDUAL_5

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@LASTNAME	nvarchar(100)	IN
@FIRSTNAME	nvarchar(50)	IN
@MIDDLENAME	nvarchar(50)	IN
@MAIDENNAME	nvarchar(100)	IN
@NICKNAME	nvarchar(50)	IN
@TITLECODEID	uniqueidentifier	IN
@SUFFIXCODEID	uniqueidentifier	IN
@GENDERCODE	tinyint	IN
@BIRTHDATE	UDT_FUZZYDATE	IN
@GIVESANONYMOUSLY	bit	IN
@PICTURE	varbinary	IN
@PICTURETHUMBNAIL	varbinary	IN
@PICTURECHANGED	bit	IN
@WEBADDRESS	UDT_WEBADDRESS	IN
@MARITALSTATUSCODEID	uniqueidentifier	IN
@TITLE2CODEID	uniqueidentifier	IN
@SUFFIX2CODEID	uniqueidentifier	IN
@GENDERCODEID	uniqueidentifier	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_INDIVIDUAL_5
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @LASTNAME nvarchar(100),
    @FIRSTNAME nvarchar(50),
    @MIDDLENAME nvarchar(50),
    @MAIDENNAME nvarchar(100),
    @NICKNAME nvarchar(50),
    @TITLECODEID uniqueidentifier,
    @SUFFIXCODEID uniqueidentifier,
    @GENDERCODE tinyint,
    @BIRTHDATE dbo.UDT_FUZZYDATE,
    @GIVESANONYMOUSLY bit,
    @PICTURE varbinary(max),
    @PICTURETHUMBNAIL varbinary(max),
    @PICTURECHANGED bit,
    @WEBADDRESS dbo.UDT_WEBADDRESS,
    @MARITALSTATUSCODEID uniqueidentifier,
    @TITLE2CODEID uniqueidentifier,
    @SUFFIX2CODEID uniqueidentifier,
    @GENDERCODEID uniqueidentifier
) as
    set nocount on;

  begin try
      -- moved original code in the USP bellow, which is shared with other areas other then individual edit (duplicate search resolution screen)
          exec dbo.USP_INDIVIDUAL_EDITSAVE @ID, @CHANGEAGENTID, @LASTNAME, @FIRSTNAME, @MIDDLENAME, @MAIDENNAME, @NICKNAME, @TITLECODEID, @SUFFIXCODEID,
                                       @GENDERCODE, @BIRTHDATE, @GIVESANONYMOUSLY, @PICTURE, @PICTURETHUMBNAIL, @PICTURECHANGED, @WEBADDRESS,
                                       @MARITALSTATUSCODEID, @TITLE2CODEID, @SUFFIX2CODEID, @GENDERCODEID;
    end try
  begin catch
      exec dbo.USP_RAISE_ERROR;
      return 1;
  end catch

    return 0;