Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Adding HcmWorker Relat...
Finance | Project Operations, Human Resources, ...
Answered

Adding HcmWorker Related datasources to data entity

(0) ShareShare
ReportReport
Posted on by CU30040608-0
Hi Experts. 

I have created a HcmWorker data entity but I only have access to a few fields. 
When i look at the already existing HcmWorkerEntity I can see that it has added a lot of datasources:
 
 

I can see that DirPersonBaseEntity has a lot of relevant fields like FirstName and LastName. But when i look at the NameTabPage Form on the worker page (the form that displays FirstName, LastName and so on..) I can that the FirstName field uses a datasource called DirPersonName (not DirPersonBaseEntity). 

My questions: 
1. How can i see which datasources i should add in my data entity to get full access to all the information i need? Is there an overview of the relationsships somewhere?
2. What is a Dir table?
3. Does anyone know where to find a guide in adding datasources and creating relationsships between them? I havent been able to find a guide on this. 
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,354 Most Valuable Professional on at
    Adding HcmWorker Related datasources to data entity
    You can't remove fields in an extensions, but you normally shouldn't. You're not supposed to change all existing tables, entities and forms and remove all fields that you don't need at the moment. You disable some of them by configuration key, hide by security, or simply ignore.
     
    Note that creating an extension is just one of your options. You can also create a custom entity that uses the standard entity as its data source. Then you don't have to duplicate all logic of the standard entity, while you have a full control on things like the list of fields.
     
    Of course, there may be situations where creating a custom entity is needed, such as when you want to improve performance by removing some parts of the standard entity, but it should be the last resort.
  • CU30040608-0 Profile Picture
    CU30040608-0 on at
    Adding HcmWorker Related datasources to data entity
    Thank you for the explanation Martin. 

    I thought about extending the HcmWorkerEntity and adding my custom worker fields to it. But i noticed that when extending the HcmWorkerEntity i was not able to remove the filds that i didnt want to include. On top of that visual studio had a hard time handling it and started laggin extemly :P Would you always extend an existing data entity if one exists? Even though it has a lot of information not needed?
  • Martin Dráb Profile Picture
    Martin Dráb 230,354 Most Valuable Professional on at
    Adding HcmWorker Related datasources to data entity
    Forms usually take data from tables, not data entities. If you have a reason not to use DirPersonBaseEntity, you can open its definition to see which tables it consists of and how they're related.
     
    Ideally, don't create a second entity for the same purpose - use the existing one.
     
    There is no "Dir" table - the core table there is DirPartyTable, which represents a party (an individual or an organization) in general. These may be customers, vendors, legal entities, workers and so on.

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! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans