Is there a way to query the hours paid in a pay class on a payment that has not been closed?

unknown

Good Afternoon All,

I am struggling with an automation that will calculate a .05 deduction for each hour of straight time worked.  

We have a union whose Political Action Fund Deductions are .05 per hour of straight time worked (rounded down to the nearest nickel).  I know this is possible in IPA, however, I am struggling to find the correct table that contains the information needed.  

We created a Pay Class in Lawson - 30P that contains the pay codes (with their hours) that the deduction calculation is based on.  From there I want Payroll to run an automation that would query the employee's PR140 record to determine the number of hours were worked.  From there the automation would take the total hours and multiply it by .05 (rounded down).  

I am struggling to write the query that will query the employee's open payment record (after the batch has been released), but before the payment is closed that has the Pay Class and I can query those exact pay codes.  

Is this something that would be accommodated by a SQL Script?  If so, what would the SQL Query look like to find this information?  Any help would be greatly appreciated.  Thank you!

Chad Dirst

Hi Tommy, 

Is your deduction on the PR05 set to an amount per hour?  And is that not working.  If the .05 cent rounding is an issue I would recommend you do this via a Custom Calculation.  Then it is all baked into the PR140 and there are not other processes that need to be run but is calculated during the PR140.  The data is contained in PAYMASTER (to get open payments), PRTIME (to get hours), and PAYDEDUCTN (employee deductions).