USP_DATAFORMTEMPLATE_PRELOAD_UPDATEMULTIPLECONSTITUENTSFROMMFO

The load procedure used by the edit dataform template "Update Constituents From MatchFinder Online Process Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTRECORDTYPE	uniqueidentifier	INOUT	Constituent record type
@BATCHTEMPLATEID	uniqueidentifier	INOUT	Batch template ID

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_UPDATEMULTIPLECONSTITUENTSFROMMFO
                    (
                        @CONSTITUENTRECORDTYPE uniqueidentifier = null output,
                        @BATCHTEMPLATEID uniqueidentifier = null output
                    )
                    as
                    set nocount on;

                    select @CONSTITUENTRECORDTYPE = ID
                    from dbo.RECORDTYPE
                    where upper(NAME) = 'CONSTITUENT';

                    set @BATCHTEMPLATEID = '900BA52A-07D2-4917-8A50-039F64872D57'; --UpdateMultipleConstituents.Batch


                    return 0;