USP_DATAFORMTEMPLATE_EDIT_BBAIMPORTFILES_LOAD

The load procedure used by the edit dataform template "Target Analytics Import Files Edit 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.
@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.
@CONSTITUENTFILE	varbinary	INOUT	Constituents
@CONSTITUENTFILENAME	nvarchar(255)	INOUT	Constituents
@DISPLAYEDCONSTITUENTFILENAME	nvarchar(255)	INOUT	Constituents
@CONSTITUENTFILECHANGED	bit	INOUT	Constituent file changed?
@SUGGESTEDMEMBERSHIPLEVELSFILE	varbinary	INOUT	Suggested membership levels
@SUGGESTEDMEMBERSHIPLEVELSFILENAME	nvarchar(255)	INOUT	Suggested membership levels
@DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME	nvarchar(255)	INOUT	Suggested membership levels
@SUGGESTEDMEMBERSHIPLEVELSFILECHANGED	bit	INOUT	Suggested membership levels file changed?
@TARGETGIFTRANGESFILE	varbinary	INOUT	Target gift ranges
@TARGETGIFTRANGESFILENAME	nvarchar(255)	INOUT	Target gift ranges
@DISPLAYEDTARGETGIFTRANGESFILENAME	nvarchar(255)	INOUT	Target gift ranges
@TARGETGIFTRANGESFILECHANGED	bit	INOUT	Target gift ranges file changed?
@WEALTHESTIMATORRATINGSFILE	varbinary	INOUT	Wealth estimator ratings
@WEALTHESTIMATORRATINGSFILENAME	nvarchar(255)	INOUT	Wealth estimator ratings
@DISPLAYEDWEALTHESTIMATORRATINGSFILENAME	nvarchar(255)	INOUT	Wealth estimator ratings
@WEALTHESTIMATORRATINGSFILECHANGED	bit	INOUT	Wealth estimator ratings file changed?
@MODELINGANDPROPENSITYFILE	varbinary	INOUT	Modeling and propensity
@MODELINGANDPROPENSITYFILENAME	nvarchar(255)	INOUT	Modeling and propensity
@DISPLAYEDMODELINGANDPROPENSITYFILENAME	nvarchar(255)	INOUT	Modeling and propensity
@MODELINGANDPROPENSITYFILECHANGED	bit	INOUT	Modeling and propensity file changed?
@ANALYTICSPROJECTID	uniqueidentifier	INOUT
@ANALYTICSPROJECTDATE	date	INOUT
@ANALYTICSPROJECTUSEDBEFORE	bit	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBAIMPORTFILES_LOAD (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @CONSTITUENTFILE varbinary(max) = null output,
                        @CONSTITUENTFILENAME nvarchar(255) = null output,
                        @DISPLAYEDCONSTITUENTFILENAME nvarchar(255) = null output,
                        @CONSTITUENTFILECHANGED bit = null output,
                        @SUGGESTEDMEMBERSHIPLEVELSFILE varbinary(max) = null output,
                        @SUGGESTEDMEMBERSHIPLEVELSFILENAME nvarchar(255) = null output,
                        @DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME nvarchar(255) = null output,
                        @SUGGESTEDMEMBERSHIPLEVELSFILECHANGED bit = null output,
                        @TARGETGIFTRANGESFILE varbinary(max) = null output,
                        @TARGETGIFTRANGESFILENAME nvarchar(255) = null output,
                        @DISPLAYEDTARGETGIFTRANGESFILENAME nvarchar(255) = null output,
                        @TARGETGIFTRANGESFILECHANGED bit = null output,
                        @WEALTHESTIMATORRATINGSFILE varbinary(max) = null output,
                        @WEALTHESTIMATORRATINGSFILENAME nvarchar(255) = null output,
                        @DISPLAYEDWEALTHESTIMATORRATINGSFILENAME nvarchar(255) = null output,
                        @WEALTHESTIMATORRATINGSFILECHANGED bit = null output,
                        @MODELINGANDPROPENSITYFILE varbinary(max) = null output,
                        @MODELINGANDPROPENSITYFILENAME nvarchar(255) = null output,
                        @DISPLAYEDMODELINGANDPROPENSITYFILENAME nvarchar(255) = null output,
                        @MODELINGANDPROPENSITYFILECHANGED bit = null output,
                        @ANALYTICSPROJECTID uniqueidentifier = null output,
                        @ANALYTICSPROJECTDATE date = null output,
                        @ANALYTICSPROJECTUSEDBEFORE bit = null output
                    ) as
                        set nocount on;

                        set @TSLONG = 0;

                        if exists (select top 1 ID from dbo.BBAIMPORTFILES IMF where IMF.CONSTITUENTFILESTATUSCODE = 2 or IMF.SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE = 2 or IMF.TARGETGIFTRANGESFILESTATUSCODE = 2 or IMF.WEALTHESTIMATORRATINGSFILESTATUSCODE = 2 or IMF.MODELINGANDPROPENSITYFILESTATUSCODE = 2) begin
                            set @DATALOADED = 0;
                        end
                        else begin
                            set @DATALOADED = 1;
                        end

                        select top 1
                            @CONSTITUENTFILE = null,    /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
                            @CONSTITUENTFILENAME = IMF.CONSTITUENTFILENAME,
                            @DISPLAYEDCONSTITUENTFILENAME = IMF.CONSTITUENTFILENAME,
                            @SUGGESTEDMEMBERSHIPLEVELSFILE = null,    /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
                            @SUGGESTEDMEMBERSHIPLEVELSFILENAME = IMF.SUGGESTEDMEMBERSHIPLEVELSFILENAME,
                            @DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME = IMF.SUGGESTEDMEMBERSHIPLEVELSFILENAME,
                            @TARGETGIFTRANGESFILE = null,    /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
                            @TARGETGIFTRANGESFILENAME = IMF.TARGETGIFTRANGESFILENAME,
                            @DISPLAYEDTARGETGIFTRANGESFILENAME = IMF.TARGETGIFTRANGESFILENAME,
                            @WEALTHESTIMATORRATINGSFILE = null,    /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
                            @WEALTHESTIMATORRATINGSFILENAME = IMF.WEALTHESTIMATORRATINGSFILENAME,
                            @DISPLAYEDWEALTHESTIMATORRATINGSFILENAME = IMF.WEALTHESTIMATORRATINGSFILENAME,
                            @MODELINGANDPROPENSITYFILE = null,    /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
                            @MODELINGANDPROPENSITYFILENAME = IMF.MODELINGANDPROPENSITYFILENAME,
                            @DISPLAYEDMODELINGANDPROPENSITYFILENAME = IMF.MODELINGANDPROPENSITYFILENAME,
                            @ANALYTICSPROJECTID = IMF.ANALYTICSPROJECTID,
                            @ANALYTICSPROJECTDATE = ANALYTICSPROJECT.DATE,
                            @ANALYTICSPROJECTUSEDBEFORE = case when exists(select 1 from dbo.MODELINGANDPROPENSITYDELIVERY where MODELINGANDPROPENSITYDELIVERY.ANALYTICSPROJECTID = IMF.ANALYTICSPROJECTID) then 1 else 0 end,
                            @TSLONG = IMF.TSLONG
                        from dbo.BBAIMPORTFILES IMF
                        left join dbo.ANALYTICSPROJECT on ANALYTICSPROJECT.ID = IMF.ANALYTICSPROJECTID;

                        return 0;