USP_DATAFORMTEMPLATE_EDITLOAD_HOUSEHOLDRECOGNITIONSETTINGS

The load procedure used by the edit dataform template "Household Recognition Settings Edit"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@HOUSEHOLDRECOGNIZEHOUSEHOLD	bit	INOUT	Household
@HOUSEHOLDRECOGNIZEMEMBERS	tinyint	INOUT	All members
@HOUSEHOLDSPECIFIEDMEMBERS	xml	INOUT	Household specified members
@MEMBERRECOGNIZEHOUSEHOLD	bit	INOUT	Household
@MEMBERRECOGNIZEMEMBER	bit	INOUT	Member
@MEMBERRECOGNIZEOTHERMEMBERS	tinyint	INOUT	All other members
@MEMBERSPECIFIEDMEMBERS	xml	INOUT	Member specified members
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@HOUSEHOLDREVENUERECOGNITIONTYPECODEID	uniqueidentifier	INOUT	Default recognition credit type
@MEMBERREVENUERECOGNITIONTYPECODEID	uniqueidentifier	INOUT	Default recognition credit type
@MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID	uniqueidentifier	INOUT	Default recognition credit type
@DONORREVENUERECOGNITIONTYPE	nvarchar(100)	INOUT	Donor type

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_HOUSEHOLDRECOGNITIONSETTINGS
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @HOUSEHOLDRECOGNIZEHOUSEHOLD bit = null output,
                        @HOUSEHOLDRECOGNIZEMEMBERS tinyint = null output,
                        @HOUSEHOLDSPECIFIEDMEMBERS xml = null output,
                        @MEMBERRECOGNIZEHOUSEHOLD bit = null output,
                        @MEMBERRECOGNIZEMEMBER bit = null output,
                        @MEMBERRECOGNIZEOTHERMEMBERS tinyint = null output,
                        @MEMBERSPECIFIEDMEMBERS xml = null output,
                        @TSLONG bigint = 0 output,
                        @HOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier = null output,
                        @MEMBERREVENUERECOGNITIONTYPECODEID uniqueidentifier = null output,
                        @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier = null output,
                        @DONORREVENUERECOGNITIONTYPE nvarchar(100) = null output 
                    )
                    as
                        set nocount on;

                        select
                            @HOUSEHOLDRECOGNIZEHOUSEHOLD = HOUSEHOLDRECOGNIZEHOUSEHOLD,
                            @HOUSEHOLDRECOGNIZEMEMBERS = HOUSEHOLDRECOGNIZEMEMBERSCODE,
                            @MEMBERRECOGNIZEHOUSEHOLD = MEMBERRECOGNIZEHOUSEHOLD, 
                            @MEMBERRECOGNIZEMEMBER = MEMBERRECOGNIZEMEMBER, 
                            @MEMBERRECOGNIZEOTHERMEMBERS = MEMBERRECOGNIZEOTHERMEMBERSCODE,
                            @HOUSEHOLDREVENUERECOGNITIONTYPECODEID = HOUSEHOLDREVENUERECOGNITIONTYPECODEID,
                            @MEMBERREVENUERECOGNITIONTYPECODEID = MEMBERREVENUERECOGNITIONTYPECODEID,
                            @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID = MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID,
                            @DATALOADED = 1
                        from dbo.UFN_HOUSEHOLD_GETRECOGNITIONSETTINGS(@ID)

                        if @HOUSEHOLDRECOGNIZEMEMBERS = 2
                            set @HOUSEHOLDSPECIFIEDMEMBERS = dbo.UFN_HOUSEHOLDRECOGNITIONS_GETHOUSEHOLDSPECIFIEDMEMBERS_TOITEMLISTXML(@ID)

                        if @MEMBERRECOGNIZEOTHERMEMBERS = 2
                            set @MEMBERSPECIFIEDMEMBERS = dbo.UFN_HOUSEHOLDRECOGNITIONS_GETMEMBERSPECIFIEDMEMBERS_TOITEMLISTXML(@ID)

                        select @DONORREVENUERECOGNITIONTYPE = dbo.UFN_REVENUERECOGNITIONTYPECODE_GETDESCRIPTION(DONORREVENUERECOGNITIONTYPECODEID)
                        from dbo.RECOGNITIONDEFAULT;