Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
Need a SQL query to get the employee count processed in the payroll for a particular interval
Hi All,
I Need a SQL query to get the employee count processed in the payroll for a particular interval.
Say They payroll has started at 8 PM and completed at 10 PM. I need to find out every 15 mins how many assignment records got processed at the end of the payroll run.
The problem here is pay_assignment_actions table does not have any date columns,even pay_run_results,pay_run_result_values do not have and only pay_payroll_actions table has.So I need to run my query every 15 mins to get the count if we use pay_payroll_action and pay_assigmment_actions table.
Tagged:
0