I'm going out my mind trying to find out HOW to query off of the PRDISTRIB table while still getting the pay code (reg, ovt, hol, etc). The PRTIME shows the wages broken by employee into the pay codes, but it does not yet do the split for those that are in the emdistmast table..only the prdistrib shows the true distribution of the wages. The prdistrib shows deduction codes but not pay codes and I cannot find a link back on this. At this point I have to use the prtime and manually bust out any employees that have a split distribution (yuk)

Also - this is odd to me, but one persons pto payout shows in prtime as per end 11/3 but in prdistrib as per end 10/26. Which made my #'s not match up and sent me on a hunting expedition that I did not enjoy...any ideas on how the per end could be different?

any assistance will save my sanity!!!

never mind - I found a link from prdistrib to the prpaycode table it is seq nbr and pcd seq nbr...so now i can get prdistrib to show the pay code as i needed.