DESCRIPTION: Accidentally confirmed pay for one Employee.
SOLUTIONS:
There are two options available to reverse a Confirmed Pay:
- To restore the database from Last Night Backup OR
- 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'