Who's On?

	Membership:
	Latest: Wayne Willis
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5190

	People Online:
	Visitors: 225
	Members: 0
	Total: 225

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

Object Id - link between tables

Sort:

You are not authorized to post a reply.

Author

Messages

bgodwin

Veteran Member

Posts: 143

8/30/2007 7:16 PM

GSC advised us to remove a row in pay rate hist table due to a bug. I noticed that this row had an object id with corresponding records in hrhistory and persacthst.

Wouldn't I need to remove the corresponding rows in those other 2 tables also? If yes, what could have happened if I did not remove them?

John Henley

Senior Member

Posts: 3349

8/31/2007 1:10 AM

Beverly, I would say no, since that would invalidate historical data. Not having the record will just result in the drill-around working. What really should be done is to change the OBJ-ID on the PERSACTHST and HRHISTORY records to point to the CORRECT PRRATEHIST entry...

You are not authorized to post a reply.