How to capture the exact time card approver in to a BI report?

Summary:

The requirement is to capture the exact time card approver into the BI report, we do have an existing report to capture the time cards that are edited. Now we want to capture the approver of those time cards because some time cards are automatically approved through the system.

Content (required):

sql query to capture the time card with the approver

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

23A

Code Snippet (add any code snippets that support your topic, if applicable):