RQ approver

I think it is WFMETRICS

Jonathan, just a note--WFMETRICS only has that data if you're using self-service approval...

Hi guys.. i cant find WFMETRICS in prod or LOGAN... where exactly is this table. located... ?... thanks again

Never mind.. got it... .. but it has no data... do you guys know if there's any where else i could look.. thanks

Sounds like you're not using self-service approval. So, you'll probably want to look at a few things. On REQHEADER, the APPROVED-FL as to whether the requiistion is approved; the ATTAIN-LEVEL field will tell you which level of approval has been reached. You also need look at the APPROVE-CD field on the REQHEADER (assuming you're doing header-level, and not line-level approval). Then look into the RQAPPCODE table to see who that approver is..

I did all that, but i needed the approver ID. What happened was, we had some Reqs that shows that it has been approved, even though the person responsible for approving it haven't approve those reqs... I wanted to see who login and use the approval code to approve those reqs.. Do who know if there's a way to do this.. thanks again John