USP_DATAFORMTEMPLATE_VIEW_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS

The load procedure used by the view dataform template "Household Recognition Default Settings View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@HOUSEHOLDRECOGNIZEHOUSEHOLD	bit	INOUT	Household
@HOUSEHOLDRECOGNIZEMEMBERS	bit	INOUT	All members
@MEMBERRECOGNIZEHOUSEHOLD	bit	INOUT	Household
@MEMBERRECOGNIZEMEMBER	bit	INOUT	Member
@MEMBERRECOGNIZEOTHERMEMBERS	bit	INOUT	All other members
@HOUSEHOLDREVENUERECOGNITIONTYPE	nvarchar(100)	INOUT	Household recognition credit type
@MEMBERREVENUERECOGNITIONTYPE	nvarchar(100)	INOUT	Member recognition credit type
@MEMBERHOUSEHOLDREVENUERECOGNITIONTYPE	nvarchar(100)	INOUT	Member household recognition credit type

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS
                (
                    @DATALOADED bit = 0 output,
                    @HOUSEHOLDRECOGNIZEHOUSEHOLD bit = null output,
                    @HOUSEHOLDRECOGNIZEMEMBERS bit = null output,
                    @MEMBERRECOGNIZEHOUSEHOLD bit = null output,
                    @MEMBERRECOGNIZEMEMBER bit = null output,
                    @MEMBERRECOGNIZEOTHERMEMBERS bit = null output,
                    @HOUSEHOLDREVENUERECOGNITIONTYPE nvarchar(100) = null output,
                    @MEMBERREVENUERECOGNITIONTYPE nvarchar(100) = null output,
                    @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPE nvarchar(100) = null output
                )
                as
                    set nocount on;

                    select top 1
                        @HOUSEHOLDRECOGNIZEHOUSEHOLD = HOUSEHOLDRECOGNIZEHOUSEHOLD,
                        @HOUSEHOLDRECOGNIZEMEMBERS = HOUSEHOLDRECOGNIZEMEMBERS,
                        @MEMBERRECOGNIZEHOUSEHOLD = MEMBERRECOGNIZEHOUSEHOLD,
                        @MEMBERRECOGNIZEMEMBER = MEMBERRECOGNIZEMEMBER,
                        @MEMBERRECOGNIZEOTHERMEMBERS = MEMBERRECOGNIZEOTHERMEMBERS,
                        @HOUSEHOLDREVENUERECOGNITIONTYPE = HHCODE.DESCRIPTION,
                        @MEMBERREVENUERECOGNITIONTYPE = MEMBERCODE.DESCRIPTION,
                        @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPE = MEMBERHOUSEHOLDCODE.DESCRIPTION,
                        @DATALOADED = 1
                    from dbo.HOUSEHOLDINFO
                    left join dbo.REVENUERECOGNITIONTYPECODE HHCODE on HOUSEHOLDINFO.HOUSEHOLDREVENUERECOGNITIONTYPECODEID = HHCODE.ID
                    left join dbo.REVENUERECOGNITIONTYPECODE MEMBERCODE on HOUSEHOLDINFO.MEMBERREVENUERECOGNITIONTYPECODEID = MEMBERCODE.ID                    
                    left join dbo.REVENUERECOGNITIONTYPECODE MEMBERHOUSEHOLDCODE on HOUSEHOLDINFO.MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID = MEMBERHOUSEHOLDCODE.ID                    
                    order by HOUSEHOLDINFO.DATEADDED

                    -- If the global settings don't exist yet, default to unselected for everything

                    if @DATALOADED = 0
                    begin
                        set @HOUSEHOLDRECOGNIZEHOUSEHOLD = 0
                        set @HOUSEHOLDRECOGNIZEMEMBERS = 0
                        set @MEMBERRECOGNIZEHOUSEHOLD = 0
                        set @MEMBERRECOGNIZEMEMBER = 0
                        set @MEMBERRECOGNIZEOTHERMEMBERS = 0
                        set @DATALOADED = 1                        
                    end