News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX forum Workers Information / ...

Microsoft Dynamics AX forum

Answered

Workers Information / tables

(0) Share

Report

Report

Posted on by Community Member 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:

All responses Img

All responses (5)

Answers Img

Answers (1)

Ann2015 1,120 on at

Like (0)

Report

RE: Workers Information / tables

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

Community Member Microsoft Employee on at

Like (0)

Report

RE: Workers Information / tables

You should look into HCMWorker, DirPersonName, HCMEmployment and HCMPositionWorkerAssignment.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Workers Information / tables

I need name, last name, personnal number, Position, Title, description, job, Start and End
André Arnaud de Cal... 290,186 Super User 2024 Season 2 on at

Like (0)

Report

RE: Workers Information / tables

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

Like (0)

Report

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

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Leaderboard

#1

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

#2

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

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans