USP_DATAFORMTEMPLATE_EDITLOAD_PEOPLEFINDERPROCESSOPTIONS

The load 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 used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@MINIMUMRANKCODE	int	INOUT	Only import constituent information that meets or exceeds this match confidence ranking
@MARKASDECEASED	bit	INOUT	If PeopleFinder determines that a constituent is deceased, mark the constituent as deceased and follow rules for life changes
@UPDATELASTNAMECODE	tinyint	INOUT	If PeopleFinder returns a last name:
@UPDATEPHONENUMBER	bit	INOUT	Add new phone number from PeopleFinder
@PHONETYPECODEID	uniqueidentifier	INOUT	Phone type
@INFOSOURCECODEID	uniqueidentifier	INOUT	Information source
@ADDFORMERLASTNAMEASALIAS	bit	INOUT	Add the former last name as an alias
@MARKPHONEASPRIMARY	bit	INOUT	Mark the phone number from PeopleFinder as primary
@UPDATEADDRESS	bit	INOUT
@OLDADDRESSTYPECODEID	uniqueidentifier	INOUT
@NEWADDRESSTYPECODEID	uniqueidentifier	INOUT
@NEWADDRESSINFOSOURCECODEID	uniqueidentifier	INOUT
@MARKADDRESSASPRIMARY	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PEOPLEFINDERPROCESSOPTIONS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @MINIMUMRANKCODE int = null output,
    @MARKASDECEASED bit = null output,
    @UPDATELASTNAMECODE tinyint = null output,
    @UPDATEPHONENUMBER bit = null output,
    @PHONETYPECODEID uniqueidentifier = null output,
    @INFOSOURCECODEID uniqueidentifier = null output,
    @ADDFORMERLASTNAMEASALIAS bit = null output,
    @MARKPHONEASPRIMARY bit = null output,
    @UPDATEADDRESS bit = null output,
    @OLDADDRESSTYPECODEID uniqueidentifier = null output,
    @NEWADDRESSTYPECODEID uniqueidentifier = null output,
    @NEWADDRESSINFOSOURCECODEID uniqueidentifier = null output,
    @MARKADDRESSASPRIMARY bit = null output
    )
as

    set nocount on;

    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @MINIMUMRANKCODE = MINIMUMRANKCODE,
        @MARKASDECEASED = MARKASDECEASED,
        @UPDATELASTNAMECODE = UPDATELASTNAMECODE,
        @UPDATEPHONENUMBER = UPDATEPHONENUMBER,
        @PHONETYPECODEID = PHONETYPECODEID,
        @INFOSOURCECODEID = INFOSOURCECODEID,
        @ADDFORMERLASTNAMEASALIAS = ADDFORMERLASTNAMEASALIAS,
        @MARKPHONEASPRIMARY = MARKPHONEASPRIMARY,
        @UPDATEADDRESS = UPDATEADDRESS,
        @OLDADDRESSTYPECODEID = OLDADDRESSTYPECODEID,
        @NEWADDRESSTYPECODEID = NEWADDRESSTYPECODEID,
        @NEWADDRESSINFOSOURCECODEID = NEWADDRESSINFOSOURCECODEID,
        @MARKADDRESSASPRIMARY = MARKADDRESSASPRIMARY
    from
        dbo.PEOPLEFINDER
    where
        ID = @ID

    return 0;