How to get skipped record in Run Periodic Payroll Activity Report run

Summary:

How to get skipped record in Run Periodic Payroll Activity Report run

Content (please ensure you mask any confidential information):

Hi All,

Greetings!

We had submitted the flow # Run Periodic Payroll Activity Report , along with Payroll Relationship Group which have multiple employees included in it.

The run has got completed with Total =1 and Ignored=1

How can we get skipped record in Run Periodic Payroll Activity Report run?

I tried using the query -

Select

pay_pa.action_type,pay_pa.effective_date,pprdn.payroll_relationship_number,

aa.action_status

from pay_payroll_actions pa,

pay_requests pr,

pay_flow_instances fi,