Search code examples
peoplesoftpeoplecode

PeopleSoft Query Manager Table Name

I cannot for the life of me figure out the table name that would enable me to see the approval queue.

There is time pending approval in the approval process "TLReportedTime" and I'm looking for a table to build a report so that I can see who the approval is pending with...

Solution

  • (PS_)EOAW_USERINST is the table that stores the information with who a step's approval is pending with.