USP_DATAFORMTEMPLATE_PRELOAD_ADD_ORGTOGROUP_RELATIONSHIP

The load procedure used by the edit dataform template "Relationship Organization 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_ORGTOGROUP_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
                        from dbo.UFN_CONSTITUENT_DISPLAYNAME(@CONSTITUENTID) NF

                        select @PRIMARYISCONSTITUENT = ISCONSTITUENT
                        from dbo.CONSTITUENT
                        where ID = @CONSTITUENTID

                        set @CONSTITUENTTYPE = 1;
                        set @RECIPROCALCONSTITUENTTYPE = 2; --default to group


                        return 0;