Skip to main content

Notifications

Microsoft Dynamics AX forum
Answered

Workers Information / tables

Posted on by Microsoft Employee

Hi,

I would like to get a list of workers and the information attached to them. What are the tables I should look at?

Thank you,

Categories:
  • Ann2015 Profile Picture
    Ann2015 1,120 on at
    RE: Workers Information / tables

    How would I find if the employee is Exempt or Non Exempt?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Workers Information / tables

    You should look into HCMWorker, DirPersonName, HCMEmployment and HCMPositionWorkerAssignment.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Workers Information / tables

    I need name, last name, personnal number, Position, Title, description, job, Start and End

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,186 Super User 2024 Season 2 on at
    RE: Workers Information / tables

    There are many inherited tables and related tables. What information/columns/fields do you need on your list?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Workers Information / tables

    I would start with "HCMWorker" and follow the relations. You can also take a look at the query HcmWorkerListPage to determine the tables.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans