Need table information to create entire REQ approval life cycle

Summary:

We are trying to create a BIP report to capture approval details for the same transaction, including who approved it, at which stage it was pending approval, and who reassigned it to whom. We are using this information to build the report, but we are not able to identify the exact tables required for this requirement.

Content (please ensure you mask any confidential information):

Table list to see entire workflow for single transaction (Eg: if REQ created and went to 4 levels of approval,we nwant to see all 4 levels who approved the REQ)

Version (include the version you are using, if applicable):