USP_DATAFORMTEMPLATE_PRELOAD_CONSTITUENTNAMEFORMAT_COPYTOSPOUSE

The load procedure used by the edit dataform template "Name Format Copy to Spouse Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@NAMEFORMATID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent ID
@NAMEFORMATFUNCTIONID	uniqueidentifier	INOUT	Name
@NAMEFORMATTYPECODEID	uniqueidentifier	INOUT	Type
@PRIMARYADDRESSEE	bit	INOUT	Primary addressee
@PRIMARYSALUTATION	bit	INOUT	Primary salutation
@CUSTOMNAME	nvarchar(700)	INOUT	Custom name
@SITEID	uniqueidentifier	INOUT	Site
@SITEREQUIRED	bit	INOUT	Site Required

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_CONSTITUENTNAMEFORMAT_COPYTOSPOUSE
                    (
                        @NAMEFORMATID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @CONSTITUENTID uniqueidentifier = null output,
                        @NAMEFORMATFUNCTIONID uniqueidentifier = null output,
                        @NAMEFORMATTYPECODEID uniqueidentifier = null output,
                        @PRIMARYADDRESSEE bit = null output,
                        @PRIMARYSALUTATION bit = null output,
                        @CUSTOMNAME nvarchar(700) = null output,
                        @SITEID uniqueidentifier = null output,
                        @SITEREQUIRED bit = null output
                    )
                    as
                    begin
                        set nocount on;

                        set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);

                        select
                            @CONSTITUENTID = SPOUSERELATIONSHIP.RECIPROCALCONSTITUENTID,
                            @NAMEFORMATFUNCTIONID = NAMEFORMATFUNCTIONID,
                            @NAMEFORMATTYPECODEID = NAMEFORMATTYPECODEID,
                            @PRIMARYADDRESSEE = PRIMARYADDRESSEE,
                            @PRIMARYSALUTATION = PRIMARYSALUTATION,
                            @CUSTOMNAME = CUSTOMNAME,
                            @SITEID = SITEID
                        from
                            dbo.NAMEFORMAT
                            left join dbo.RELATIONSHIP SPOUSERELATIONSHIP on NAMEFORMAT.CONSTITUENTID = SPOUSERELATIONSHIP.RELATIONSHIPCONSTITUENTID and SPOUSERELATIONSHIP.ISSPOUSE = 1
                        where
                            NAMEFORMAT.ID = @NAMEFORMATID;

                        return 0;
                    end