Delete a Batch

On occasion, you may need to delete all the data entered in a saved uncommitted batch from your database, such as to remove a duplicate batch. We recommend you back up your database before you delete any information.

The BatchTypeSpec's DeleteBatchRecordOperation element is used to provide the ID of the record operation spec that deletes the data from a batch created from the batch type. If not specified, the default batch delete record operation (USP_BATCH_DELETE) is used. The default batch delete record operation deletes the batch and any rows from the staging table (base table) that reference the batch. If you have special logic that needs to occur when you delete a batch, you should not use the default delete record operation.

The Enhanced Revenue Batch is an example of a batch that utilizes the DeleteBatchRecordOperation element to specify the ID of a record operation spec to define the USP_BATCHREVENUE_DELETEBATCH stored procedure which provides special logic to delete an Enhanced Revenue Batch.

For more information, see "Delete an Uncommitted Batch" within the Batch Entry chapter of the Blackbaud CRM Batch and Import Guide.