PRTIME

Not sure what you mean by breakdown, but yes. Here is a sample SQL. select employee, pay_sum_grp, job_code, hm_process_lev, process_level, hours, department, tr_date, per_end_date, date_stamp from PROD.PRTIME prt where company=1000 and employee = 12345 AND prt.date_stamp >= '01-JAN-2013' AND prt.date_stamp <= '31-DEC-2013' order by per_end_date, pay_sum_grp

Thank you, this is exactly what I am looking for. Actually I got an email from one of my users asking me to create a batch report program for requests recevied for a breakdown of salary information for an employee by pay types in X class. So I am assuming she wants a report by employee listing all the pay types that are in X class.

Here is another example that relates to Pay Classes that you might find useful. select emp.employee, (select TO_CHAR(sum(hours), '99999990.99') from PROD.prtime prt where company = 1000 AND employee = 12345 AND (prt.date_stamp >= '26-JAN-2012' AND prt.date_stamp <= '08-FEB-2012') AND pay_sum_grp IN (select psg.pay_sum_grp FROM PROD.psgrelate psg WHERE psg.company = 1000 AND psg.pay_class = 'MRT' AND psg.wages_flag = 'I')) AS hours, (select TO_CHAR(sum(wage_amount), '99999990.99') from PROD.prtime prt where company = 1000 AND employee = 12345 AND (prt.date_stamp >= '26-JAN-2012' AND prt.date_stamp <= '08-FEB-2012') AND pay_sum_grp IN (select psg.pay_sum_grp FROM PROD.psgrelate psg WHERE psg.company = 1000 AND psg.pay_class = 'MRG' AND psg.wages_flag = 'I')) AS amount from PROD.employee emp where emp.company=1000 and emp.employee = 12345

Oh wow, this is one is even more helpful, thanks!!! I was actually trying to figure out how to select in 'RET' when I saw your post.

You're welcome! I didn't know until your second post that you were looking for pay types within a pay class.