Delete History

The Delete section action calls on a Blackbaud Delete Record Operation named "Business Process Status: Delete" to delete a business process instance's history. The feature uses the USP_BUSINESSPROCESSSTATUS_DELETE stored procedure to delete a row in the BusinessProcessStatus table for the given ID.  When a row is deleted from the BusinessProcessStatus table the related child records are deleted within the BusinessProcessOutput table by a foreign key with a cascade delete. The BusinessProcessOutput table's TableName column refers to the output table generated by the business process CLR code. When a row within BusinessProcessOutput table is deleted, a trigger attempts to delete the associated output table.