Report on Approval Rules - Each transaction and what the workflow is for it.

Summary:

We are looking for a solution to find the workflow for each of our transactions and the stages each goes through. We want to grab all of the approval rules we have to evaluate and store them in a report.

i.e. Change Assignment (HR Submits - Manager Approves - FYI to Employee) - Just an example, but something in a format like this. We don't want to see who it is assigned to, we want to see the approval rule set up itself.

I did not see any subject area that would solve this issue, does anyone have a SQL query or solution for this? The only solution we know of is manually going into each transaction and getting the workflow that way, but with so many transactions we wanted to see if there is a better solution.