Wages/Hours by POSITION for specific check, not using QUARTWAGE table

I am looking for a way to pull wages/hours by a department, for a specific check and have the position worked populate. I don't want to use the QUARTWAGE because I need to have it for individual checks; not a QUARTER total. The PAYMASTER table doesn't give me PAYCODES or HOURS?

Any ideas on a good way to use back-end tables to get this?

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Accepted answers

All comments

joseph-carfagno

try dumping PRTIME - that should give you the information you are looking for.

unknown

I use this for various things.. you can modify it based on your actual needs:

SELECT PT.EMPLOYEE
,PT.PER_END_DATE
,SUM(CASE WHEN PT.PAY_SUM_GRP IN ('WNC','CWU','CDW','CWN')
THEN PT.WAGE_AMOUNT ELSE 0 END) AS WC_WAGES
,SUM((CASE WHEN PT.PAY_SUM_GRP IN ('DPC','NPC','UPD','UPN')
THEN PT.WAGE_AMOUNT ELSE 0 END)*.80) AS PTCV_WAGES
,R_POSITION
FROM ls_apps.PRTIME PT

INNER JOIN ls_apps.PAYMASTR AS PM
ON PT.EMPLOYEE = PM.EMPLOYEE AND PT.CHECK_ID = PM.CHECK_ID

WHERE PAY_SUM_GRP IN ('WNC','CWU','CDW','CWN','DPC','NPC','UPD','UPN')
AND CHECK_DATE = '12/31/2020'
--AND @PER_BEG_DATE = '10/07/2018' AND PER_END_DATE = '10/20/2018'
--AND PT.PROCESS_LEVEL IN ('100', '110', '120', '130', '131', '200', '220', '300', '560', '570', '700', '710', '712', '800')
GROUP BY PT.EMPLOYEE, PT.PER_END_DATE, R_POSITION
ORDER BY PT.EMPLOYEE

unknown

I use PRTIME and it shows the period end date, dept, accounting unit, job, position, rate and union that the hours are populated by the TRDATE (time record date) for the payment. I don't think it has the pay date, just period end date.

unknown

You can join to PAYMASTR to get the check date if you need it.

Copyright © 2025 Infor. All rights reserved.