No data in one of the payroll audit tables
Summary:
No data in PAY_ASSIGNED_PAYROLLS_DN_
Content (please ensure you mask any confidential information):
Hi Team,
I need to fetch the deleted payroll name when existing payroll is deleted and added again with same effective date i.e payroll changes done in correction mode. I checked data in below tables,
PAY_ASSIGNED_PAYROLLS_F_
PAY_ASSIGNED_PAYROLLS_DN_
I could see deleted data in PAY_ASSIGNED_PAYROLLS_F_ but in this table do not have any attribute to identify the person whose data got deleted. Other table
PAY_ASSIGNED_PAYROLLS_DN_ has attributes like PAYROLL_ID,PAYROLL_TERM_ID to identify the person but this table is blank.