View Full Version: Payroll History Removal

LawsonTalk > Database > Payroll History Removal


Title: Payroll History Removal
Description: getting rid of pay history for go-live


bgodwin - April 13, 2007 05:20 PM (GMT)
We are in go-live and want to use our current data system as our go-live with the exception of the data created by running a payroll (want to remove any evidence that we ran a payroll). I've reviewed various items in the data file text and technical text in effort to find out what tables would have to be 1) wiped out and 2) what tables would need values reset (i.e. comphist and coda).

Apparently the pr300 purge of hist does not take out everything. Does anyone have the info on this, is it do-able?

I'm concerned that I could have overlooked a table/data, does anyone out there have this expertise/knowledge?

So far I've deleted the data from these tables:
paymastr
paydeductn
prtime
prdistrib
prcheck
pacoments
quartded
quartwage
premdedhst
EMPACHDIST
praudit

Additional tables that may need to be deleted or have the totals adjusted to zero:

comphist
coda
quartwage
quartded
prdeddtl
prempgarn (shows garnishment balances)
onetmded
prtrdadj (check adjustments)
timerecord
taeemaster (pto balances)
vesthours

need to reload pto balances & emdedmastr (balances on some deductions)




Hosted for free by InvisionFree