Where are requests that have not yet been approved saved?

Question

Hi there, 
 I'm using One Identity Manager 8.2.0, and I would like to know in which table of the DB I can find the request that has yet to be approved, together with the UID of the Person that is in charge to approve them. Otherwise, it could be okay to find a table in which for each Person I can find how many requests he/she still has to approve. 
 As you can see, PersonWantsOrg is not what I need, because it doesn't give any information about who is the next approver. 
 Thanks in advance for your help.

Klaus Müller · Accepted Answer

PWOHelperPWO contains all possible approvers for the "open" orders. That includes the Chief Approval Team, future (not yet active) decission steps, requests for comments and likely more. The WebFrontend more or less shows the result of the query select * from QER_VITShopDecisionPerson where rulerlevel <> 2 and decisionorcomment = 'D' and uid_person = ''

Where are requests that have not yet been approved saved?

Top Replies