Looking for ways to track employee position history in GP SQL tables

(0) Share

Report

Posted on by polaris

145

Greetings,

I am trying to find a way to link the historical employee position with employee id, if possible. For instance, the employee 101 in 2013 was an analyst but in January 2014 became a senior analyst. I need to reflect that change

-- polaris

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

If you have the HR module then the info you are looking for is in tables MPOSHIST, MPOSMAIN.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like
a
(0)

Report
Copy link

Link copied!

In addition to the above tables, also have a look on the below tables.

1. PC Position Setup History (PC30301).

2. PC Position Pay Codes History (PC30302).

Hope this helps!!!

Was this reply helpful? Yes No
polaris 145 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. Everything worked great!

Was this reply helpful? Yes No