Greetings,

The information in those legacy PR tables was moved to PR_PayrollHistoryHeader and PR_PayrollHistoryDetail for Payroll 2.0.

For more information, go to the Information Center in Sage 100 and click on the Resource link. Then click the File Layouts and Program Information link. Click on the Cross Reference Information topic. Select Old File Names to New File Names Mappings, then Select Payroll.  Here you will see the Payroll Schema mappings for the old to new file names.

Thank you,
Kent

The File Layouts and Program Information list these details.

https://help-sage100.na.sage.com/2019/FLOR/Content/Old_File_Names_to_New_File_Names_Listing/PayrollFileMapping.htm

Yes, I'm now getting data.  Hoping you can answer a couple more questions:

1) I'm linking PR_Employee to PR_PayrollHistoryHeader on EmployeeKey, but all demographic fields from PR_Employee are blank in my report.  Any idea why?

2) There used to be separate fields for Earning and Deduction amounts.  Now it looks like both are stored in PayAmt.  Is that correct?

Thank you!

-Eric

Is number 1 a security feature?

Greetings,

For 1) See the Following help topic:https://help-sage100.na.sage.com/2020/index.htm#Subsystems/PR/Concept/Security_for_PII.htm?Highlight=Payroll PII

For 2) you are correct.  The Amount data from the legacy PR_23 table records is mapped to PayAmt in the PR_PayrollHistoryDetail table during conversion.

Thank you,
Kent