Jdog,
You can have a look at this posting https://bobj-board.org/t/105734, it discusses in an XI scenario the two “transactional” tables in Auditor and a method to delete rows. I suppose that before performing the deletes, that one could write an SQL statement to take the “to be deleted” rows and append to an archival table somewhere, then perform the deletes. Write back if you have any further questions.
Thanks,
John
jsanzone 
(BOB member since 2006-09-12)