USP_DATAFORMTEMPLATE_ADD_HOUSEHOLDMEMBER_PRELOAD

The load procedure used by the edit dataform template "Household Member Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@GROUPID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PRIMARYCONTACTNAME	nvarchar(154)	INOUT	Primary contact name
@PRIMARYCONTACTID	uniqueidentifier	INOUT	Primary contact ID
@HOUSEHOLDRECOGNIZEMEMBERS	tinyint	INOUT	Household recognize members type
@MEMBERRECOGNIZEOTHERMEMBERS	tinyint	INOUT	Member recognize other members type

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_HOUSEHOLDMEMBER_PRELOAD
                    (
                        @GROUPID uniqueidentifier,
                        @PRIMARYCONTACTNAME nvarchar(154) = null output,
                        @PRIMARYCONTACTID uniqueidentifier = null output,
                        @HOUSEHOLDRECOGNIZEMEMBERS tinyint = null output,
                        @MEMBERRECOGNIZEOTHERMEMBERS tinyint = null output
                    )
                    as
                        set nocount on;

                        select                 
                            @PRIMARYCONTACTNAME = C.NAME,
                            @PRIMARYCONTACTID = C.ID
                        from dbo.GROUPMEMBER GM
                        inner join dbo.CONSTITUENT as C on GM.MEMBERID = C.ID
                        where GM.GROUPID = @GROUPID and GM.ISPRIMARY = 1;

                        select
                            @HOUSEHOLDRECOGNIZEMEMBERS = HOUSEHOLDRECOGNIZEMEMBERSCODE,
                            @MEMBERRECOGNIZEOTHERMEMBERS = MEMBERRECOGNIZEOTHERMEMBERSCODE
                        from dbo.UFN_HOUSEHOLD_GETRECOGNITIONSETTINGS(@GROUPID)

                        return 0;