Hello All, I am trying to make custom SSRS reports on our PTO data, any idea which tables would have the information I would need? I'm interested in the number of hours as well. we use another entity that records time, but all the data gets migrated into GP and payroll is cut out from GP. therefore I'm guessing data should also exist in GP, but I just don't know where to look. any help would be appreciated. Thank you
*This post is locked for comments
This is assuming you are using Payroll and not HR to track information.
The tables I have used for reports are:
UPR00100 which has the accrual rates, balances.
UPR30100 which has by payroll ending balances, but you would need to filter to the paydate in question
UPR30300 would allow you to total PTO use, but you would have to tie in pay codes , etc to get that.
There are several views you can use too.
companydb.dbo.Employees (uses UPR00100 information)
companydb.dbo.EmployeeSummary (uses UPR30100 information)
Hope this helps!
Zara
Share
Report
All responses (
Answers (
