Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Workers Information / tables

(0) ShareShare
ReportReport
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,

*This post is locked for comments

  • Ann2015 Profile Picture
    Ann2015 1,122 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... 291,904 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.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans