For my labor hour reporting, I have chosen to look at the Job Cost tables and filter for the Labor Costs.  I am able to get the RT and OT hours and cost without using the PR tables.  Specifically, I use JCT_CURRENT__TRANSACTION.

Related to your question re: PRT, RTT, PJF.  The 1st 2 letters relate to the module, and the last letter relates to whether the table contents are Transaction, Master, Activity, etc:

PRT = Payroll Module - Transaction

For my labor hour reporting, I have chosen to look at the Job Cost tables and filter for the Labor Costs.  I am able to get the RT and OT hours and cost without using the PR tables.  Specifically, I use JCT_CURRENT__TRANSACTION.

Related to your question re: PRT, RTT, PJF.  The 1st 2 letters relate to the module, and the last letter relates to whether the table contents are Transaction, Master, Activity, etc:

PRT = Payroll Module - Transaction

Thanks for the reply, that helps a ton.

Regarding getting Labor costs from JCT_CURRENT__TRANSACTION, what column are you matching on? Also how do you differentiate between overtime and non-overtime?

In my case I am looking for hours rather than costs... would that be in the same table?

Glad you found it helptul!

Based on my setup, I can filter down to just PR transactions by Category.  My payroll setup has a separate Job Cost Category for Regular Time and Overtime.  To get the hours, I use the [Units] column.

Can you clarify your question re: column matching?

Regarding column matching, I was curious which column you use to filter the rows of data to just labor, but you have answered that.