USP_DATAFORMTEMPLATE_EDITLOAD_EMAILADDRESS_2

The load procedure used by the edit dataform template "Email Address Edit Form 2"

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.
@EMAILADDRESSTYPECODEID	uniqueidentifier	INOUT	Type
@EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email address
@PRIMARY	bit	INOUT	Set as primary email address
@DONOTEMAIL	bit	INOUT	Do not send email to this address
@SPOUSENAME	nvarchar(154)	INOUT
@SPOUSEHASMATCHINGEMAILADDRESS	bit	INOUT
@UPDATEMATCHINGSPOUSEEMAILADDRESS	bit	INOUT	Update matching email information for spouse
@ISHOUSEHOLD	bit	INOUT
@ISHOUSEHOLDMEMBER	bit	INOUT
@UPDATEMATCHINGHOUSEHOLDEMAILADDRESS	bit	INOUT	Update matching email addresses in household
@MATCHINGHOUSEHOLDMEMBERS	xml	INOUT	Household members
@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.
@INFOSOURCECODEID	uniqueidentifier	INOUT	Information source
@INFOSOURCECOMMENTS	nvarchar(256)	INOUT	Comments
@CONSTITUENTDATAREVIEWROLLBACKREASONID	uniqueidentifier	INOUT	Reason
@FORCEDPRIMARY	bit	INOUT
@CANEDITPRIMARY	bit	INOUT
@INVALIDFIELDS	nvarchar(256)	INOUT
@ORIGINCODE	tinyint	INOUT	Origin
@STARTDATE	date	INOUT	Start date
@ENDDATE	date	INOUT	End date
@INVALIDEMAIL	bit	INOUT
@EMAILBOUNCEDDATE	date	INOUT
@EMAILISCONFIDENTIAL	bit	INOUT
@DONOTEMAILREASONCODEID	uniqueidentifier	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EMAILADDRESS_2 (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @EMAILADDRESSTYPECODEID uniqueidentifier = null output,
                    @EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
                    @PRIMARY bit = null output,
                    @DONOTEMAIL bit = null output,
                    @SPOUSENAME nvarchar(154) = null output,
                    @SPOUSEHASMATCHINGEMAILADDRESS bit = null output,
                    @UPDATEMATCHINGSPOUSEEMAILADDRESS bit = null output,
                    @ISHOUSEHOLD bit = null output,
                    @ISHOUSEHOLDMEMBER bit = null output,
                    @UPDATEMATCHINGHOUSEHOLDEMAILADDRESS bit = null output,
                    @MATCHINGHOUSEHOLDMEMBERS xml = null output,
                    @TSLONG bigint = 0 output,
                    @INFOSOURCECODEID uniqueidentifier = null output,
                    @INFOSOURCECOMMENTS nvarchar(256) = null output,
                    @CONSTITUENTDATAREVIEWROLLBACKREASONID uniqueidentifier = null output,    -- used by constituent data review

                    @FORCEDPRIMARY bit = null output,            -- used by constituent data review

                    @CANEDITPRIMARY bit = null output,            -- used by constituent data review

                    @INVALIDFIELDS nvarchar(256) = null output,    -- used by constituent data review

                    @ORIGINCODE tinyint = null output,
                    @STARTDATE date = null output,
                    @ENDDATE date = null output,
                    @INVALIDEMAIL bit = null output,
                    @EMAILBOUNCEDDATE date = null output,
                    @EMAILISCONFIDENTIAL bit = null output,
                    @DONOTEMAILREASONCODEID uniqueidentifier = null output
                )
                as
                    set nocount on;

                    -- moved original code in the USP bellow, which is shared with other areas other then email address edit (duplicate search resolution screen)

                    exec dbo.USP_EMAILADDRESS_EDITLOAD @ID, @DATALOADED output, @EMAILADDRESSTYPECODEID output, @EMAILADDRESS output, @PRIMARY output, @DONOTEMAIL output,
                        @SPOUSENAME output, @SPOUSEHASMATCHINGEMAILADDRESS output, @UPDATEMATCHINGSPOUSEEMAILADDRESS output, @ISHOUSEHOLD output, 
                        @ISHOUSEHOLDMEMBER output, @UPDATEMATCHINGHOUSEHOLDEMAILADDRESS output, @MATCHINGHOUSEHOLDMEMBERS output, @TSLONG output, @INFOSOURCECODEID output,
                        @INFOSOURCECOMMENTS output, @CONSTITUENTDATAREVIEWROLLBACKREASONID output, @FORCEDPRIMARY output, @CANEDITPRIMARY output, @INVALIDFIELDS output,
                        @ORIGINCODE output, @STARTDATE output, @ENDDATE output, @INVALIDEMAIL output, @EMAILBOUNCEDDATE output,@EMAILISCONFIDENTIAL output,@DONOTEMAILREASONCODEID output;

                    return 0;