Who's On?

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

	People Online:
	Visitors: 452
	Members: 0
	Total: 452

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

Effective Date & System Change Date

3 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

MARIA O.

Basic Member

Posts: 9

1/24/2014 5:55 PM

I want to select records for a Crystal report based on change date, if personnel actions were not used. I saw a previous post that indicated the effective date on HR11 is field 267. I want to display the two fields on a Crystal report. Does anyone know if they are in the EMPLOYEE table, or are they maintained in the HRHISTORY table? Thank you.

Margie Gyurisin

Veteran Member

Posts: 538

1/27/2014 12:38 PM

I believe you want to look in the HRHISTORY table.

Margie Gyurisin

Veteran Member

Posts: 538

1/27/2014 12:39 PM

That same data can most likely be queried via HR65 and reported via HR70 or HR170.

MARIA O.

Basic Member

Posts: 9

1/27/2014 7:39 PM

Thanks. I went with the system change date in the HRHISTORY table and got the desired results.