USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOIND_5

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
@MEMBERSOFSAMEHOUSEHOLD	bit	IN
@COPYCONTACTINFO	bit	IN
@SKIP_ADDING_SECURITYGROUPS	bit	IN	Skip adding security groups

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOIND_5
(
    @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),
    @MEMBERSOFSAMEHOUSEHOLD bit,
    @COPYCONTACTINFO bit,
    @SKIP_ADDING_SECURITYGROUPS bit
)
as

    declare @IS_NEW_SPOUSE bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIP_INDTOIND_3 @ID=@ID, @IS_NEW_SPOUSE=@IS_NEW_SPOUSE output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOIND_6
        @ID,
        @CHANGEAGENTID,
        @RELATIONSHIPTYPECODEID,
        @RECIPROCALTYPECODEID,
        @STARTDATE,
        @ENDDATE,
        @ISSPOUSE,
        @PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
        @PRIMARYSOFTCREDITMATCHFACTOR,
        @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
        @RECIPROCALSOFTCREDITMATCHFACTOR,
        @PRIMARYRECOGNITIONTYPECODEID,
        @RECIPROCALRECOGNITIONTYPECODEID,
        @COMMENTS,
        @MEMBERSOFSAMEHOUSEHOLD,
        @COPYCONTACTINFO,
        @SKIP_ADDING_SECURITYGROUPS,
        @IS_NEW_SPOUSE;