Move Employee Document table record to Sys Attachment table

Kirankumar Nal1
Tera Contributor

Dear All,

 

Need to help in below,

 

Would like to move the existing attachments uploaded in Employee Document (sn_hr_ef_employee_document) table to sys_attachment table using script.

 

Please suggest me on this.

 

Thank you
 
Regards,
Kirankumar
5 REPLIES 5

Hello Michael,

 

Thank you for the information provided.

Actually, Employee Document Management licence is getting expired and it is not getting extended in our organization.

So, we don't want to keep the attachments in Employee Document table.

As the attachments are stored in both sys attachment and employee document table,

can I update sys attachment records to the actual hr case table and its sys id and then remove the records in employee document table?

 

Could you please let me know on this.

 

Thank you