Announcements
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,
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,186 Super User 2024 Season 2
Martin Dráb 227,996 Super User 2024 Season 2
nmaenpaa 101,148