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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Workers Information / tables

(0) ShareShare
ReportReport
Posted on by

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,

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

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

  • André Arnaud de Calavon Profile Picture
    303,691 Super User 2026 Season 1 on at

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

  • Community Member Profile Picture
    on at

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

  • Verified answer
    Community Member Profile Picture
    on at

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

  • Ann2015 Profile Picture
    1,128 on at

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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans