Support hard delete when record is soft deleted