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
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
How would I find if the employee is Exempt or Non Exempt?
You should look into HCMWorker, DirPersonName, HCMEmployment and HCMPositionWorkerAssignment.
I need name, last name, personnal number, Position, Title, description, job, Start and End
There are many inherited tables and related tables. What information/columns/fields do you need on your list?
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 Cal... 291,904 Super User 2024 Season 2
Martin Dráb 230,605 Most Valuable Professional
nmaenpaa 101,156