USP_RECORDOPERATION_BBAIMPORTFILES_CLEARALL
Executes the "Target Analytics Import Files: Clear All" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Input parameter indicating the ID of the record being updated. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the update. |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
CREATE procedure dbo.USP_RECORDOPERATION_BBAIMPORTFILES_CLEARALL(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier
) as
set nocount on;
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
begin try
update
dbo.BBAIMPORTFILES
set
CONSTITUENTFILE = null,
CONSTITUENTFILENAME = '',
CONSTITUENTFILESTATUSCODE = 0,
CONSTITUENTFILEERRORS = '',
SUGGESTEDMEMBERSHIPLEVELSFILE = null,
SUGGESTEDMEMBERSHIPLEVELSFILENAME = '',
SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE = 0,
SUGGESTEDMEMBERSHIPLEVELSFILEERRORS = '',
TARGETGIFTRANGESFILE = null,
TARGETGIFTRANGESFILENAME = '',
TARGETGIFTRANGESFILESTATUSCODE = 0,
TARGETGIFTRANGESFILEERRORS = '',
WEALTHESTIMATORRATINGSFILE = null,
WEALTHESTIMATORRATINGSFILENAME = '',
WEALTHESTIMATORRATINGSFILESTATUSCODE = 0,
WEALTHESTIMATORRATINGSFILEERRORS = '',
MODELINGANDPROPENSITYFILE = null,
MODELINGANDPROPENSITYFILENAME = '',
MODELINGANDPROPENSITYFILESTATUSCODE = 0,
MODELINGANDPROPENSITYFILEERRORS = '',
ANALYTICSPROJECTID = null,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = @CURRENTDATE
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;