Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Micros Res 3700 - LM Data Purge

Status
Not open for further replies.
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 just posted a similar question the other day. It seems premium pay does not purge as well so any employees that have premium pay attached can not be deleted either.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top