USP_DATAFORMTEMPLATE_EDIT_PEOPLEFINDERPROCESSOPTIONS

The save procedure used by the edit dataform template "PeopleFinder Process Options Edit Data Form".

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.
@MINIMUMRANKCODE	int	IN	Only import constituent information that meets or exceeds this match confidence ranking
@MARKASDECEASED	bit	IN	If PeopleFinder determines that a constituent is deceased, mark the constituent as deceased and follow rules for life changes
@UPDATELASTNAMECODE	tinyint	IN	If PeopleFinder returns a last name:
@UPDATEPHONENUMBER	bit	IN	Add new phone number from PeopleFinder
@PHONETYPECODEID	uniqueidentifier	IN	Phone type
@INFOSOURCECODEID	uniqueidentifier	IN	Information source
@ADDFORMERLASTNAMEASALIAS	bit	IN	Add the former last name as an alias
@MARKPHONEASPRIMARY	bit	IN	Mark the phone number from PeopleFinder as primary

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PEOPLEFINDERPROCESSOPTIONS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MINIMUMRANKCODE int,
    @MARKASDECEASED bit,
    @UPDATELASTNAMECODE tinyint,
    @UPDATEPHONENUMBER bit,
    @PHONETYPECODEID uniqueidentifier,
    @INFOSOURCECODEID uniqueidentifier,
    @ADDFORMERLASTNAMEASALIAS bit,
    @MARKPHONEASPRIMARY bit
)
as
    set nocount on;

    declare @UPDATEADDRESS bit;
    declare @OLDADDRESSTYPECODEID uniqueidentifier;
    declare @NEWADDRESSTYPECODEID uniqueidentifier;
    declare @NEWADDRESSINFOSOURCECODEID uniqueidentifier;
    declare @MARKADDRESSASPRIMARY bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PEOPLEFINDERPROCESSOPTIONS
        @ID = @ID,
        @UPDATEADDRESS = @UPDATEADDRESS output,
        @OLDADDRESSTYPECODEID = @OLDADDRESSTYPECODEID output,
        @NEWADDRESSTYPECODEID = @NEWADDRESSTYPECODEID output,
        @NEWADDRESSINFOSOURCECODEID = @NEWADDRESSINFOSOURCECODEID output,
        @MARKADDRESSASPRIMARY = @MARKADDRESSASPRIMARY output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_PEOPLEFINDERPROCESSOPTIONS_2
        @ID,
        @CHANGEAGENTID,
        @MINIMUMRANKCODE,
        @MARKASDECEASED,
        @UPDATELASTNAMECODE,
        @PHONETYPECODEID,
        @INFOSOURCECODEID,
        @ADDFORMERLASTNAMEASALIAS,
        @MARKPHONEASPRIMARY,
        @UPDATEADDRESS,
        @OLDADDRESSTYPECODEID,
        @NEWADDRESSTYPECODEID,
        @NEWADDRESSINFOSOURCECODEID,
        @MARKADDRESSASPRIMARY

    return 0;