USP_DATAFORMTEMPLATE_VIEW_BBAIMPORTFILES

The load procedure used by the view dataform template "Target Analytics Import Files View Form"

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.
@CONSTITUENTFILE	varbinary	INOUT	Constituents
@CONSTITUENTFILENAME	nvarchar(255)	INOUT	Constituents
@CONSTITUENTFILESTATUSCODE	tinyint	INOUT	Constituent file status
@CONSTITUENTFILEHASERRORS	bit	INOUT	Constituent file has errors
@SUGGESTEDMEMBERSHIPLEVELSFILE	varbinary	INOUT	Suggested membership levels
@SUGGESTEDMEMBERSHIPLEVELSFILENAME	nvarchar(255)	INOUT	Suggested membership levels
@SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE	tinyint	INOUT	Suggested membership levels file status
@SUGGESTEDMEMBERSHIPLEVELSFILEHASERRORS	bit	INOUT	Suggested membership levels file has errors
@TARGETGIFTRANGESFILE	varbinary	INOUT	Target gift ranges
@TARGETGIFTRANGESFILENAME	nvarchar(255)	INOUT	Target gift ranges
@TARGETGIFTRANGESFILESTATUSCODE	tinyint	INOUT	Target gift ranges file status
@TARGETGIFTRANGESFILEHASERRORS	bit	INOUT	Target gift ranges file has errors
@WEALTHESTIMATORRATINGSFILE	varbinary	INOUT	Wealth estimator ratings
@WEALTHESTIMATORRATINGSFILENAME	nvarchar(255)	INOUT	Wealth estimator ratings
@WEALTHESTIMATORRATINGSFILESTATUSCODE	tinyint	INOUT	Wealth estimator ratings file status
@WEALTHESTIMATORRATINGSFILEHASERRORS	bit	INOUT	Wealth estimator ratings file has errors
@MODELINGANDPROPENSITYFILE	varbinary	INOUT	Modeling and propensity
@MODELINGANDPROPENSITYFILENAME	nvarchar(255)	INOUT	Modeling and propensity
@MODELINGANDPROPENSITYFILESTATUSCODE	tinyint	INOUT	Modeling and propensity file status
@MODELINGANDPROPENSITYFILEHASERRORS	bit	INOUT	Modeling and propensity file has errors
@ANALYTICSPROJECTDATE	date	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BBAIMPORTFILES (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,

                    @CONSTITUENTFILE varbinary(max) = null output,
                    @CONSTITUENTFILENAME nvarchar(255) = null output,
                    @CONSTITUENTFILESTATUSCODE tinyint = null output,
                    @CONSTITUENTFILEHASERRORS bit = null output,

                    @SUGGESTEDMEMBERSHIPLEVELSFILE varbinary(max) = null output,
                    @SUGGESTEDMEMBERSHIPLEVELSFILENAME nvarchar(255) = null output,
                    @SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE tinyint = null output,
                    @SUGGESTEDMEMBERSHIPLEVELSFILEHASERRORS bit = null output,


                    @TARGETGIFTRANGESFILE varbinary(max) = null output,
                    @TARGETGIFTRANGESFILENAME nvarchar(255) = null output,
                    @TARGETGIFTRANGESFILESTATUSCODE tinyint = null output,
                    @TARGETGIFTRANGESFILEHASERRORS bit = null output,


                    @WEALTHESTIMATORRATINGSFILE varbinary(max) = null output,
                    @WEALTHESTIMATORRATINGSFILENAME nvarchar(255) = null output,
                    @WEALTHESTIMATORRATINGSFILESTATUSCODE tinyint = null output,
                    @WEALTHESTIMATORRATINGSFILEHASERRORS bit = null output,


                    @MODELINGANDPROPENSITYFILE varbinary(max) = null output,
                    @MODELINGANDPROPENSITYFILENAME nvarchar(255) = null output,
                    @MODELINGANDPROPENSITYFILESTATUSCODE tinyint = null output,
                    @MODELINGANDPROPENSITYFILEHASERRORS bit = null output,

                    @ANALYTICSPROJECTDATE date = null output
                ) as
                    set nocount on;

                    set @DATALOADED = 1;

                    select top 1
                        @CONSTITUENTFILE = null,    /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
                        @CONSTITUENTFILENAME = IMF.CONSTITUENTFILENAME,
                        @CONSTITUENTFILESTATUSCODE = IMF.CONSTITUENTFILESTATUSCODE,
                        @CONSTITUENTFILEHASERRORS = case when len(cast(IMF.CONSTITUENTFILEERRORS as nvarchar(max))) > 0 then 1 else 0 end,

                        @SUGGESTEDMEMBERSHIPLEVELSFILE = null,    /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
                        @SUGGESTEDMEMBERSHIPLEVELSFILENAME = IMF.SUGGESTEDMEMBERSHIPLEVELSFILENAME,
                        @SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE = IMF.SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE,
                        @SUGGESTEDMEMBERSHIPLEVELSFILEHASERRORS = case when len(cast(IMF.SUGGESTEDMEMBERSHIPLEVELSFILEERRORS as nvarchar(max))) > 0 then 1 else 0 end,

                        @TARGETGIFTRANGESFILE = null,    /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
                        @TARGETGIFTRANGESFILENAME = IMF.TARGETGIFTRANGESFILENAME,
                        @TARGETGIFTRANGESFILESTATUSCODE = IMF.TARGETGIFTRANGESFILESTATUSCODE,
                        @TARGETGIFTRANGESFILEHASERRORS = case when len(cast(IMF.TARGETGIFTRANGESFILEERRORS as nvarchar(max))) > 0 then 1 else 0 end,

                        @WEALTHESTIMATORRATINGSFILE = null,    /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
                        @WEALTHESTIMATORRATINGSFILENAME = IMF.WEALTHESTIMATORRATINGSFILENAME,
                        @WEALTHESTIMATORRATINGSFILESTATUSCODE = IMF.WEALTHESTIMATORRATINGSFILESTATUSCODE,
                        @WEALTHESTIMATORRATINGSFILEHASERRORS = case when len(cast(IMF.WEALTHESTIMATORRATINGSFILEERRORS as nvarchar(max))) > 0 then 1 else 0 end,

                        @MODELINGANDPROPENSITYFILE = null,    /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
                        @MODELINGANDPROPENSITYFILENAME = IMF.MODELINGANDPROPENSITYFILENAME,
                        @MODELINGANDPROPENSITYFILESTATUSCODE = IMF.MODELINGANDPROPENSITYFILESTATUSCODE,
                        @MODELINGANDPROPENSITYFILEHASERRORS = case when len(cast(IMF.MODELINGANDPROPENSITYFILEERRORS as nvarchar(max))) > 0 then 1 else 0 end,

                        @ANALYTICSPROJECTDATE = ANALYTICSPROJECT.DATE
                    from dbo.BBAIMPORTFILES IMF
                    left join dbo.ANALYTICSPROJECT on ANALYTICSPROJECT.ID = IMF.ANALYTICSPROJECTID;

                    return 0;