DJensen999
MIS
- Jan 27, 2014
- 145
I've been digging on this one for a few days.
I have noticed that 3700 does not let you delete an employee if they are the "changed by" person in the tables "hist_emp_job_otm_lvl_dtl" and "hist_job_otm_lvl_dtl", which is not allowing old supervisors/managers to be deleted from the system, as these tables appear to never purge. A quick search of stored procedures shows only 7 of them touching these tables, 3 of them being complete clears of the tables in question. Is there a purge routine out there for this data that I'm missing that isn't splm_purge_data?
I have noticed that 3700 does not let you delete an employee if they are the "changed by" person in the tables "hist_emp_job_otm_lvl_dtl" and "hist_job_otm_lvl_dtl", which is not allowing old supervisors/managers to be deleted from the system, as these tables appear to never purge. A quick search of stored procedures shows only 7 of them touching these tables, 3 of them being complete clears of the tables in question. Is there a purge routine out there for this data that I'm missing that isn't splm_purge_data?