USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOIND_4

Updates a relationship between two individuals.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@ISSPOUSE	bit	IN	Is spouse?
@PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply to <Constituent> for revenue from <Reciprocal>
@PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition credit match percent
@RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply to <Reciprocal> for revenue from <Constituent>
@RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition credit match percent
@PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition credit type
@RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition credit type
@COMMENTS	nvarchar(max)	IN	Comments

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOIND_4
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,                                                                        
                        @RELATIONSHIPTYPECODEID uniqueidentifier,
                        @RECIPROCALTYPECODEID uniqueidentifier,                                                
                        @STARTDATE datetime,
                        @ENDDATE datetime,
                        @ISSPOUSE bit,
                        @PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit,
                        @PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2),
                        @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit,
                        @RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2),
                        @PRIMARYRECOGNITIONTYPECODEID uniqueidentifier,
                        @RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier,
                        @COMMENTS nvarchar(max)
                    )
                    as

                        exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOIND_5
                            @ID,
                            @CHANGEAGENTID,                                                                
                            @RELATIONSHIPTYPECODEID,
                            @RECIPROCALTYPECODEID,                                        
                            @STARTDATE,
                            @ENDDATE,
                            @ISSPOUSE,
                            @PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
                            @PRIMARYSOFTCREDITMATCHFACTOR,
                            @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
                            @RECIPROCALSOFTCREDITMATCHFACTOR,
                            @PRIMARYRECOGNITIONTYPECODEID,
                            @RECIPROCALRECOGNITIONTYPECODEID,
                            @COMMENTS,
                            0;