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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Employee turnover and ...
Microsoft Dynamics SL (Archived)

Employee turnover and Rehires (Employee, xEmployee, xEmpDate)

(0) ShareShare
ReportReport
Posted on by NewToDynamicsSL 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

I have the same question (0)
  • 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?

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

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October 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