USP_EDIT_INDIVIDUAL

Update individual profile information partially

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
@MARITALSTATUSCODEID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_EDIT_INDIVIDUAL
                (
                    @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,
                    @MARITALSTATUSCODEID uniqueidentifier
                ) as
                    set nocount on;
                    declare @CURRENTDATE datetime;

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

                    set @CURRENTDATE = getdate();

                    begin try
                            update 
                                dbo.[CONSTITUENT] 
                            set
                                [KEYNAME] = ISNULL(@LASTNAME,KEYNAME),
                                [FIRSTNAME] = ISNULL(@FIRSTNAME,FIRSTNAME),
                                [MIDDLENAME] = ISNULL(@MIDDLENAME,MIDDLENAME),
                                [MAIDENNAME] = ISNULL(@MAIDENNAME,MAIDENNAME),
                                [NICKNAME] = ISNULL(@NICKNAME,NICKNAME),
                                [TITLECODEID] = ISNULL(@TITLECODEID,TITLECODEID),
                                [SUFFIXCODEID] = ISNULL(@SUFFIXCODEID,SUFFIXCODEID),
                                [ISORGANIZATION] = 0,
                                [GENDERCODE] = ISNULL(@GENDERCODE,GENDERCODE),
                                [BIRTHDATE] = ISNULL(@BIRTHDATE,BIRTHDATE),
                                [MARITALSTATUSCODEID] = ISNULL(@MARITALSTATUSCODEID,MARITALSTATUSCODEID),
                                [DATECHANGED] = @CURRENTDATE,
                                [CHANGEDBYID] = @CHANGEAGENTID
                            where 
                                [CONSTITUENT].ID = @ID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;