Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Employee turnover and Rehires (Employee, xEmployee, xEmpDate)

Posted on by 60

 Greetings,

I am new to MS Dynamics SL and am trying to provide a custom report on the turnover of employees.  I am unclear as to the business process that occurs between the Employee, xEmployee and xEmpdate.  xEmployee is really throwing me off because there are very few records in that table.  Employee to xEmpdate seems more logical - any hire/rehire (hiredate/termdate) of an employee gets recorded in xEmpdate - Employee holds the Employee data as well as the latest strtdate and enddate.  Any information would be helpfull.

 

Thanks in advance! 

*This post is locked for comments

  • Toni Savage Profile Picture
    Toni Savage 260 on at
    Re: Re: Re: Re: Re: Employee turnover and Rehires (Employee, xEmployee, xEmpDate)

    Yep!  Do you  have any module called "Human Resources?"

    This could also be some kind of add-on for Projects, if you have that, too.

    Sorry I can't be more help, but there are dozens of add-ins that might relate to customers...

     

    Toni

  • NewToDynamicsSL Profile Picture
    NewToDynamicsSL 60 on at
    Re: Re: Re: Re: Employee turnover and Rehires (Employee, xEmployee, xEmpDate)

     I do see a lot of tables prefixed by XHR_ as well.  This leads me to beleive that it is an add on.  Does this sound correct?

     

    Also, thanks so much for your help!

  • Toni Savage Profile Picture
    Toni Savage 260 on at
    Re: Re: Re: Employee turnover and Rehires (Employee, xEmployee, xEmpDate)

    No, Solomon reserves the "X" letter only for non-Microsoft add-ons.  These are often very well designed to integrate seamlessly with Solomon, so it is hard for a user to tell.  Do you have telephone support from your reseller? 

    Do you perhaps have the "Human Resources" add on from Silverbrook?   I don't personally know of any other add-ons that use employee records.

  • NewToDynamicsSL Profile Picture
    NewToDynamicsSL 60 on at
    Re: Re: Employee turnover and Rehires (Employee, xEmployee, xEmpDate)

     I don't beleive there is an add in module.  We recently upgraded to Solomon 7 and I see a lot of tables beginning with X in the current and previous version.  Does this seem possible?

  • Toni Savage Profile Picture
    Toni Savage 260 on at
    Re: Employee turnover and Rehires (Employee, xEmployee, xEmpDate)

    Any file name that starts with an X is not a standard SL file.  You must have an add-in of some sort that has created those tables... any idea what that might be?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans