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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (