Get Accurate Request Status

[aksharkay]

Hi,

Can anyone please help me with the table name which I need to refer to get exact request status?

I wish to know in which table I can find a request status code for a Request ID or Request Key which says that the request has been "Partially Approved".

Thanks & Regards,

Akshar

[sai_sp]

@aksharkay You can refer to the status column in the table ars_requests

[dgandhi]

Please find below required information.

Above is the value for status, ars_requests is the table name.

[aksharkay]

@sai_sp @dgandhi I can only see requests with status 1, 3 and 6 in the Data Analyzer, even though I have requests of all statuses on the Request History UI. Also, after a request is successfully completed, the status on the UI changes to "Approved" and never to "Completed". Finally, in the below example, I have two requests: one has status "Approved" on UI and the other has status "Partially Approved". But in Data Analyzer, the status code for both is 3 due to which I am unable to differentiate the actual status of the two.

Do you have any workarounds or inputs on this?