HR Case data and associated table clean up

Dsinghal
Kilo Expert

‎01-07-2019 03:35 AM

We have a requirement to delete all closed HR cases and all related tables, after a certain amount of time. This is to comply with GDPR.

Where can we get the list of tables that would need to be cleaned up as part of this exercise?

What is the best approach for a scheduled clean up of this data? Use "Table Cleanup" or the archiving functionality.

Also how to delete the attachments associated with a case. When we delete the cases, the related case attachments are not getting deleted from sys_attachment table.

0 Helpfuls
  • 1,496 Views
2 REPLIES 2

Alberto Consonn
ServiceNow Employee
ServiceNow Employee

‎01-07-2019 03:42 AM

Hi,

here you will find the list of tables used by HR management.

I would suggest to use Table Cleanup, just remember to Modify the Auto Flush data retention policy (Modify data retention policy for ATF test results)

 Please, remember to mark Correct or Helpful if you find my response useful.

Cheers
Alberto

0 Helpfuls

Dsinghal
Kilo Expert
In response to Alberto Consonn

‎02-01-2019 06:51 AM

Hi Alberto,

 

Thanks for the reply.

While the link you posted points to the old ver of HR management, it did help me to find the list of records though. I should have mentioned that we use the scoped app version.

I also found that only sys tables can be used under table clean up. Tables containing case management data have to be purged via the archiving method.

Regards

0 Helpfuls