USP_DATAFORMTEMPLATE_PRELOAD_ADD_GROUPTOGROUP_RELATIONSHIP

The load procedure used by the edit dataform template "Relationship Group to Group Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTNAME	nvarchar(700)	INOUT
@CONSTITUENTTYPE	int	INOUT
@PRIMARYISCONSTITUENT	bit	INOUT
@RECIPROCALCONSTITUENTTYPE	int	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_GROUPTOGROUP_RELATIONSHIP
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @CONSTITUENTNAME nvarchar(700) = null output,
                        @CONSTITUENTTYPE int = null output,
                        @PRIMARYISCONSTITUENT bit = null output,
                        @RECIPROCALCONSTITUENTTYPE int = null output --used for recognition defaults, must be updated in uimodel to reflect group or household

                    )
                    as
                        set nocount on;

                        select @CONSTITUENTNAME = NF.NAME,
                               @PRIMARYISCONSTITUENT = ISCONSTITUENT
                        from dbo.CONSTITUENT
                            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                        where ID = @CONSTITUENTID;

                        set @CONSTITUENTTYPE = 2;
                        set @RECIPROCALCONSTITUENTTYPE = 2;

                        return 0;