Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5210

	People Online:
	Visitors: 169
	Members: 0
	Total: 169

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

Object Id - link between tables

1 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

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

Posts: 3353

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...