Scripts to Clear Pay Stub Data and Rerun Cheques after Payrun Revert

Scripts to Clear Pay Stub Data and Rerun Cheques after Payrun Revert

GOAL: To provide scripts to clear out the Pay Stub data under EC_WEB_PAY_STAT for the scenario where a pay run was erroneously Confirmed, and Cheques were erroneously created. 

Once the pay run is reverted, users can use the below script to clear out Pay Stub data for the EMP_GROUP and PAYNUM combination in question.

Step 1: Revert the Pay in question using either

Revert Pay for One Employee: Helpdesk : edsembli

Revert Pay for Entire Group: Helpdesk : edsembli

Step 2: Fix necessary changes for Pay > Re-Run > Confirm Pay

Step 3: Clear out EC_WEB_PAY_STAT (Pay Stub) data before re-running Cheques and EFT

Note: This step can be completed alongside Step 1, thus allowing the board to fix the pay, confirm it and simply run Cheques and EFT all together. 

select * from EC_WEB_PAY_STAT

where EMP_GROUP_CODE = 'xxxx'

and PAY_NUMBER = 'YYYYNN'

delete from EC_WEB_PAY_STAT

where EMP_GROUP_CODE = 'xxxx'

and PAY_NUMBER = 'YYYYNN'

---------------------------

select * from EC_WEB_PAY_STAT_DED

where EMP_GROUP_CODE = 'xxxx'

and PAY_NUMBER = 'YYYYNN'

delete from EC_WEB_PAY_STAT_DED

where EMP_GROUP_CODE = 'xxxx'

and PAY_NUMBER = 'YYYYNN'

----------------------------

select * from EC_WEB_PAY_STAT_EARN

where EMP_GROUP_CODE = 'xxxx'

and PAY_NUMBER = 'YYYYNN'

delete from EC_WEB_PAY_STAT_EARN

where EMP_GROUP_CODE = 'xxxx'

and PAY_NUMBER = 'YYYYNN'

----------------------------

IMPORTANT NOTE: Once the delete script is run for EC_WEB_PAY_STAT table (First Script), this will automatically clear out the EARN and DED tables as well.