Accidentally confirmed pay for one Employee.

DESCRIPTION:  Accidentally confirmed pay for one Employee.

SOLUTIONS:

There are two options available to reverse a Confirmed Pay:

1. To restore the database from Last Night Backup OR
2. The below Tables need to be deleted and updated.

SELECT STATEMENT:

select * from EC_PAYRUN_POINTER

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER = '2022xx'

select * from EC_EMPLOYEE_PAY_INPUT

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

select * from EC_EMPLOYEE_PAY_INPUT_EI

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

select * from EC_EMPLOYEE_PAY_RECORD

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

select * from EC_EMPLOYEE_PAY_RECORD2

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

select * from EC_EMPLOYEE_ACCOUNTING

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

select * from EC_EMPLOYEE_DAILY_STAT2_DATA

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

select * from EC_EMPLOYEE_DAILY_EI_DATA

where EMPLOYEE_ID = 'xxxxx'

and RUN_EMP_GROUP_CODE = 'XXXXXXX'

and RUN_PAY_NUMBER >= '2022xx'

select * from EC_EMPLOYEE_CHEQUE

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

DELETE STATEMENT: 

delete EC_PAYRUN_POINTER

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER = '2022xx'

delete EC_EMPLOYEE_PAY_INPUT

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

delete EC_EMPLOYEE_PAY_INPUT_EI

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

delete EC_EMPLOYEE_PAY_RECORD

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

delete EC_EMPLOYEE_PAY_RECORD2

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

delete EC_EMPLOYEE_ACCOUNTING

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

delete EC_EMPLOYEE_DAILY_EI_DATA

where EMPLOYEE_ID = 'xxxxx'

and RUN_EMP_GROUP_CODE = 'XXXXXXX'

and RUN_PAY_NUMBER >= '2022xx'

delete EC_EMPLOYEE_CHEQUE

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER >= '2022xx'

UPDATE STATEMENT: 

update EC_EMPLOYEE_YTD_ENTITY

set AMOUNT = AMOUNT - CURRENT_AMOUNT

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER = '2022xx'

update EC_EMPLOYEE_YTD_ENTITY

set CURRENT_AMOUNT = '0'

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER = '2022xx'

update EC_EMPLOYEE_SEN_SERV

set SEN_SERV_VALUE = SEN_SERV_VALUE - CURRENT_SEN_SERV_VALUE

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER = '2022xx'

update EC_EMPLOYEE_SEN_SERV

set CURRENT_SEN_SERV_VALUE = '0'

where EMPLOYEE_ID = 'xxxxx'

and EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER = '2022xx'

update EC_PAY_PERIOD_CALENDAR

set PROCESSED_BY_PAYROLL_IND = 'N'

where EMP_GROUP_CODE = 'XXXXXXX'

and PAY_NUMBER = '2022xx'