employee promotion date

(0) Share

Report

Posted on by Alex Pan

350

Hello

I am pulling information from SL and I need to know the promotion date for each employee if any. the PJEMPLOY table does not seem to be the correct table.

Any suggestions are highly appreciated!

*This post is locked for comments

All responses (3)

Answers (1)

Alex Pan 350 on at

Like (0)

Report

RE: employee promotion date

Christopher

I think you are right, but I used another table PJRate. Assuming when people get promoted, their rate will be different.

Thanks!
Verified answer

Christopher Hanson 110 on at

Like (0)

Report

RE: employee promotion date

Alex, it sounds like you are using project controller.

I believe that the table you are looking for is PJEMPPJT. It is the table that has a record of each rate and effective date by employee. Join PJEMPPJT to the PJEMPLOY table to get employee names.
Carolyn Kolpien on at

Like (0)

Report

RE: employee promotion date

Hi Alex,

In which screen are you entering the promotion date? I don't see that on my standard SL screens?

If it is a custom screen, you could go into Customization Manager while the screen is open and look at the properties for that field.

Let me know which screen you are using for promotion dates.