web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / employee promotion date
Microsoft Dynamics SL (Archived)

employee promotion date

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    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.

  • Verified answer
    Christopher Hanson Profile Picture
    Christopher Hanson 110 on at

    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.

  • Alex Pan Profile Picture
    Alex Pan 350 on at

    Christopher

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

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans