USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOGROUP_2

Updates a relationship between an individual and a group.

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
@COMMENTS	nvarchar(max)	IN	Comments

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOGROUP_2
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,                                                                        
                    @RELATIONSHIPTYPECODEID uniqueidentifier,
                    @RECIPROCALTYPECODEID uniqueidentifier,                                                
                    @STARTDATE datetime,
                    @ENDDATE datetime,
                    @COMMENTS nvarchar(max)
                )
                as

                    declare @PRIMARYISCONSTITUENT bit;
                    declare @PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit;
                    declare @PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2);
                    declare @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit;
                    declare @RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2);
                    declare @PRIMARYRECOGNITIONTYPECODEID uniqueidentifier;
                    declare @RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier;

                    exec USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIP_INDTOGROUP
                        @ID = @ID,
                        @PRIMARYISCONSTITUENT = @PRIMARYISCONSTITUENT output,
                        @PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @PRIMARYSOFTCREDITRELATIONSHIPEXISTS output,
                        @PRIMARYSOFTCREDITMATCHFACTOR = @PRIMARYSOFTCREDITMATCHFACTOR output,
                        @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS output,
                        @RECIPROCALSOFTCREDITMATCHFACTOR = @RECIPROCALSOFTCREDITMATCHFACTOR output,
                        @PRIMARYRECOGNITIONTYPECODEID = @PRIMARYRECOGNITIONTYPECODEID output,
                        @RECIPROCALRECOGNITIONTYPECODEID = @RECIPROCALRECOGNITIONTYPECODEID output

                    exec USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOGROUP_3
                        @ID,
                        @CHANGEAGENTID,                                                                        
                        @RELATIONSHIPTYPECODEID,
                        @RECIPROCALTYPECODEID,                                                
                        @STARTDATE,
                        @ENDDATE,
                        @COMMENTS,
                        @PRIMARYISCONSTITUENT,
                        @PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
                        @PRIMARYSOFTCREDITMATCHFACTOR,
                        @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
                        @RECIPROCALSOFTCREDITMATCHFACTOR,
                        @PRIMARYRECOGNITIONTYPECODEID,
                        @RECIPROCALRECOGNITIONTYPECODEID

                    return 0;