Skip to main content



No record found.

Microsoft Dynamics SL forum

employee promotion date

Posted on by 350


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!

  • Alex Pan Profile Picture
    Alex Pan 350 on at
    RE: employee promotion date


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


  • Verified answer
    Christopher Hanson Profile Picture
    Christopher Hanson 110 on at
    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.

  • 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans