Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 59
	Members: 0
	Total: 59

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

Time in a position

3 Replies

0 Subscribed to this topic

23 Subscribed to this forum

Sort:

Author

Messages

charliewilliam

Basic Member

Posts: 16

New Poster

7/19/2010 1:56 PM

Hi All,

I have a request to calculate the length of time an employee has been in his/her position. I need to consider promotions, demotions, new hires. I am not sure which table(s) to start with...

Could someone point me in the right direction?

Thanks in advance,

CW

mark.cook

Veteran Member

Posts: 444

New Poster

7/19/2010 3:25 PM

Do you use personel actions to process these transactions? If so you can use the PERSACTHIST table to pull out those actions with dates of the transactions.

charliewilliam

Basic Member

Posts: 16

New Poster

7/19/2010 3:39 PM

Yes, Personel Actions are used to process these transactions. I did look at PERSACTHIST but didn't see how just a change in the jobcode can be pulled. Can you suggest a formula?

CW

Ruma Malhotra

Veteran Member

Posts: 412

7/19/2010 3:52 PM

To look at a change in any field that is processed by a personnel action and to know what the before image and after image to a field is you will have to look at 2 tables which are PERSACTHST and HRHSITORY. There is a field number field in HRHISTORY that refers to the actual field that was changed. The same can be seen on PA54 or HR54 to kno what field number is the actual field referring to in the HRHISTORY table.