Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 428
	Members: 0
	Total: 428

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Employee missing on the HR11?--deleted somehow?

7 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

MichelleW

Basic Member

Posts: 20

7/14/2009 2:32 PM

Had a good one come up this morning. Payroll called and was trying to look up a well known active employee, the message says employee does not exist. If I run a crystal report on the HR History file there is data there, its almost like they got deleted from the Employee table only..
Only one of my security classes allow a Delete on the HR11-however when it is done on the Hr11 itself, the history goes with it as well so I am really stumped on this one!
We have restored the employee from a back up file but anyone have any idea how we would find out how that employee got deleted???

John Henley

Posts: 3353

7/14/2009 3:00 PM

If it was the entire table, and PAEMPLOYEE was intact, I would suspect database-level truncation (assuming the table structure was there, just no data).

Perhaps via Lawson commands, bldxxxddl -UR or truncfile.
Or truncate table via SQL.

Reminds me of a time a client told me that the DBA had removed all of the indexes "because they were taking too much space".

MichelleW

Basic Member

Posts: 20

7/15/2009 2:01 PM

the table itself was fine, just had one employee missing from it....HRHistory was there, PR history was there...very weird,
we have eliminated the possiblity of someone running a HR125 on this employee...have no idea how this happened but will need to come up with something for the powers that be!

John Henley

Posts: 3353

7/15/2009 3:00 PM

Was the employee deleted from PAEMPLOYEE?

stephanie

Veteran Member

Posts: 330

7/15/2009 3:04 PM

I know I should never say it can't be done, but I would've made a bet that it couldn't be done - through any normal channels, anyway! Do any of your users have access to screen painting? Could someone have deleted instead of changed?

wilcoxmad

Veteran Member

Posts: 87

7/16/2009 4:46 PM

Does someone have access to SQL tools? Sounds like someone used something besides Lawson products to delete the employee.

MichelleW

Basic Member

Posts: 20

7/17/2009 11:54 AM

the PAemployee information was there as well as the payrate history hr history...and no we do not have a screen painting program...still straching my head!

John Henley

Posts: 3353

7/17/2009 12:15 PM

In that case, I would have to suspect someone deleted via SQL.