USP_SPOUSERELATIONSHIP_SETUPHOUSEHOLD

Sets up the household membership for a spousal relationship.

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@SPOUSEID	uniqueidentifier	IN
@COPYCONTACTINFO	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@SKIP_ADDING_SECURITYGROUPS	bit	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SKIP_ADDING_SITES	bit	IN
@UPDATECONSTITUENTMARITALSTATUS	bit	IN
@INDIVIDUALCOPYCONTACTINFO	bit	IN

Definition

Copy



            CREATE procedure dbo.USP_SPOUSERELATIONSHIP_SETUPHOUSEHOLD
            (
                @CONSTITUENTID uniqueidentifier,
                @SPOUSEID uniqueidentifier,
                @COPYCONTACTINFO bit,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null,
                @SKIP_ADDING_SECURITYGROUPS bit = 0,
                @CURRENTAPPUSERID uniqueidentifier = null,
                @SKIP_ADDING_SITES bit = 0,
                @UPDATECONSTITUENTMARITALSTATUS bit = 1,
                @INDIVIDUALCOPYCONTACTINFO bit = 1
            )
            as
                set nocount on;

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                if @CHANGEDATE is null
                    set @CHANGEDATE = getdate()

                --WI 541503.  We should not be changing the marital status if one of the spouses is deceased.

                if exists (select 'x' from dbo.DECEASEDCONSTITUENT where ID in (@CONSTITUENTID,@SPOUSEID))
                    set @UPDATECONSTITUENTMARITALSTATUS = 0

                exec USP_MARRIAGEOPTIONS_APPLYRULES @CONSTITUENTID, @SPOUSEID, @CHANGEAGENTID, @CHANGEDATE, @UPDATECONSTITUENTMARITALSTATUS;

                declare @COPYEMAILADDRESS bit
                declare @COPYPHONENUMBER bit

                select 
                    @COPYEMAILADDRESS = COPYEMAILADDRESS,
                    @COPYPHONENUMBER = COPYPHONENUMBER
                from
                    dbo.UFN_MARRIAGERULE_GETRULES()

                exec dbo.USP_RELATIONSHIP_SETUPHOUSEHOLD @CONSTITUENTID, @SPOUSEID, 
                    @COPYCONTACTINFO, @CHANGEAGENTID, @CHANGEDATE, @SKIP_ADDING_SECURITYGROUPS,@CURRENTAPPUSERID,'9d3aff90-42d0-4db0-a4c1-703d25fd1902',
                    @SKIP_ADDING_SITES, @COPYEMAILADDRESS, @COPYPHONENUMBER, @INDIVIDUALCOPYCONTACTINFO;