Contact support

Software - TimeLOG Web / Synergy WF

TLW - Permanent deletion of the employees in bulk

TLW

Replace 92 with the employee number you need to remove.

  • delete from clockingpauses where ClockingId in (select clockingid from clockings where employeeid in (select id from employees where departmentId = 92))
  • delete from clockings where employeeid in (select id from employees where departmentId = 92)
  • update employees set AbsenceManagerId = null where absencemanagerid in (select id from employees where departmentId = 92)
  • update employees set NotificationManager1 = null where NotificationManager1 in (select id from employees where departmentId = 92)
  • update employees set NotificationManager2 = null where NotificationManager2 in (select id from employees where departmentId = 92)
  • delete from dbo.Link_Employee_EmployeeActivity where EmployeeId in (select id from employees where departmentId = 92)
  • delete from dbo.Link_Employee_WeeklyShift where EmployeeId in (select id from employees where departmentId = 92)
  • delete from dbo.IrDeviceTemplates where EmployeeId in (select id from employees where departmentId = 92)
  • delete from dbo.IrTemplates where EmployeeId in (select id from employees where departmentId = 92)
  • delete from dbo.ClockingData where Empid in (select id from employees where departmentId = 92)
  • delete from dbo.ScoresAbnormalities where EmployeeId in (select id from employees where departmentId = 92)
  • delete from dbo.DisplayEmployeesSettings where EmployeeId in (select id from employees where departmentId = 92)
  • delete from dbo.RecapAbsences where EmployeeId in (select id from employees where departmentId = 92)
  • delete from dbo.EmployeeAssignedContracts where EmployeeId in (select id from employees where departmentId = 92)
  • delete from employees where departmentId = 92