A Social Network for PeopleSoft Professionals

SQL update payroll check data

Our Payroll dept ran payroll last week and found out later that they had about 1200 checks wrong. There was an overpayment on an Earns Code. We are in the middle of an Open Enrollment and too many days had passed so a restore was not an option. We restored to a test environment and figured out what the employees were suppose to get paid and adjusted the Dir Deposit. Employees with a check (about 100) were re-processed in prod. We were looking to see it it was possible to run a off-cycle to adjust the remaining 1000 employees. It looks like the only way to correct these values without manually re-processing each employee is to SQL update database with correct values. Has anyone ever done this or has anyone ever run into this issue?

Thanks!
Oscar

Tags: Payroll, SQL, Update

0 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by PSoftPros on October 27, 2009 at 8:11am

Hi Oscar,

Your problem seems rather complex for a simple SQL Update. Given that there are so many tables involved, including tax tables, etc.. I would highly advise against performing a SQL Update. If you have not done so already, log a case with Oracle and get their input. My guess is that they will tell you to run the off cycle.

Good Luck!
Derek

▶ Reply

Permalink Reply by Oscar Garcia on October 27, 2009 at 9:34am

Derek,
did open a case with Oracle, because of all the amounts (tax, flsa rates, YTD totals...), the off-cycle was not going to give us what we needed. I restored a copy of prod right before we confirmed and ran the missing job. Since I have all those amounts, that was what I was going to use to update data for the affected employees. Oracle support said that either it was the manual check by check or sql update. I am looking at about 25 tables that will need to be updated.

thanks,
Oscar

Derek Tomei said:

Hi Oscar,

Your problem seems rather complex for a simple SQL Update. Given that there are so many tables involved, including tax tables, etc.. I would highly advise against performing a SQL Update. If you have not done so already, log a case with Oracle and get their input. My guess is that they will tell you to run the off cycle.

Good Luck!
Derek

▶ Reply

Permalink Reply by Angela Morehouse-Brown on October 28, 2009 at 5:46pm

Were you able to find a resolution? From what I gather, it sounds like a major clean up process. I agree with Derek, this is a very complex problem, especially since the direct deposits no longer match the pay data. In the future, depending on the amount, deduct it from the next payroll (a few optoins for this), or reverse and reissue as an off-cycle - live check, these are the cleanest. Messing with all of the underlying pay data/pay earns, all of the balance fields, etc. is a very complex process and can lead to major issues at year end or even quarter end. Were the earnings taxable, if so, there is another complex piece to the puzzle. I hope you found a simpler solution for correcting the problem. If you corrected the direct deposits, posting a manual check may be the cleaner route to take so all of the balances (all fields and pay data in general) update properly, but definitely cross reference the amounts you actually paid in the DDP file. Some taxes on the manual checks may need an over-ride since the total earnings is now a different amount and may make the tax amounts off, for federal, select states, etc.