USP_DATAFORMTEMPLATE_EDIT_PEOPLEFINDERPROCESSOPTIONS_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@MINIMUMRANKCODE	int	IN
@MARKASDECEASED	bit	IN
@UPDATELASTNAMECODE	tinyint	IN
@UPDATEPHONENUMBER	bit	IN
@PHONETYPECODEID	uniqueidentifier	IN
@INFOSOURCECODEID	uniqueidentifier	IN
@ADDFORMERLASTNAMEASALIAS	bit	IN
@MARKPHONEASPRIMARY	bit	IN
@UPDATEADDRESS	bit	IN
@OLDADDRESSTYPECODEID	uniqueidentifier	IN
@NEWADDRESSTYPECODEID	uniqueidentifier	IN
@NEWADDRESSINFOSOURCECODEID	uniqueidentifier	IN
@MARKADDRESSASPRIMARY	bit	IN

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PEOPLEFINDERPROCESSOPTIONS_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MINIMUMRANKCODE int,
    @MARKASDECEASED bit,
    @UPDATELASTNAMECODE tinyint,
    @UPDATEPHONENUMBER bit,
    @PHONETYPECODEID uniqueidentifier,
    @INFOSOURCECODEID uniqueidentifier,
    @ADDFORMERLASTNAMEASALIAS bit,
    @MARKPHONEASPRIMARY bit,
    @UPDATEADDRESS bit,
    @OLDADDRESSTYPECODEID uniqueidentifier,
    @NEWADDRESSTYPECODEID uniqueidentifier,
    @NEWADDRESSINFOSOURCECODEID uniqueidentifier,
    @MARKADDRESSASPRIMARY bit
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        update dbo.PEOPLEFINDER
        set
            MINIMUMRANKCODE = @MINIMUMRANKCODE,
            MARKASDECEASED = @MARKASDECEASED,
            UPDATELASTNAMECODE = @UPDATELASTNAMECODE,
            UPDATEPHONENUMBER = @UPDATEPHONENUMBER,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE,
            PHONETYPECODEID = @PHONETYPECODEID,
            INFOSOURCECODEID = @INFOSOURCECODEID,
            ADDFORMERLASTNAMEASALIAS = @ADDFORMERLASTNAMEASALIAS,
            MARKPHONEASPRIMARY = @MARKPHONEASPRIMARY,
            UPDATEADDRESS = @UPDATEADDRESS,
            OLDADDRESSTYPECODEID = @OLDADDRESSTYPECODEID,
            NEWADDRESSTYPECODEID = @NEWADDRESSTYPECODEID,
            NEWADDRESSINFOSOURCECODEID = @NEWADDRESSINFOSOURCECODEID,
            MARKADDRESSASPRIMARY = @MARKADDRESSASPRIMARY
        where
            ID = @ID
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;