Where can I find the details for the check paycodes? Which sql table? Not UPR30100......
I need wages by paycode by check date by employee
(I'm using sql and smartlist builder)
*This post is locked for comments
figured it out - needed UPR30300
specifically states above - report by paycode by checkdate by employee - to get regular hours, overtime hours and salary hours and wages for each type
I don't think you can get it from a single table, but you can create sql script by using multiple tables to get the wages, what you are exactly doing.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156