Which Global Payroll Table/Column stores the Pending & Failed counts for Payroll Activity Reports?

Hi, I would like to ask for assistance from anyone who is familiar with Global Payroll tables and views. We are currently encountering an issue where our SQL query is not retrieving the Pending and Failed counts for the following payroll reports:

• Payroll Activity Report – Details
• Payroll Activity Report – Summary

We are retrieving the Success, Pending, and Failed values from the following tables and columns :

• Success: pay_flow_task_instances.fi_total_completed — accurate count based on HCM UI
• Pending: pay_stats_flow_actions.unprocessed — unable to retrieve the count while the report is still in progress
• Failed: pay_stats_flow_actions.stat_error_total —