1,045
How can I determine when a Pay Code was last used (ie not used in the past 3 years)? I'm trying to do some cleanup so I can get them unassigned to individuals and eventually deleted.
Thank you.
*This post is locked for comments
I may have answered my own question with the following script:
SELECT PAYROLCD, MAX(CHEKDATE)
FROM UPR30300
GROUP BY PAYROLCD
With 15+ years of payroll history, that will be a bit cumbersome.
Check history table? You could see when the deductions were paid and work backwards from there
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (