Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Using Dataverse connector unable to find Financial Dimension information and Office Location Information

Posted on by Microsoft Employee

I am having difficulty in seeing where in the tables the data for the following fields in Dynamics HR:

  1. Financial Dimensions / Operating Units (In the employment tab)
    1. CostCentre / CostCentreName (Referred to as Operating Units but we have renamed the label)
    2. Titles i.e. R30 - again has been renamed
  2. Office Location within the Profile Tab

pastedimage1643815626221v3.png

pastedimage1643815692594v4.png

Any idea which tables this information may be in ?  

Thanks in advance


Scott

  • Verified answer
    Parag Chapre Profile Picture
    Parag Chapre 12,271 Most Valuable Professional on at
    RE: Using Dataverse connector unable to find Financial Dimension information and Office Location Information

    This data is stored at Employment entity > Dimension Display Value

    pastedimage1643816705174v2.png

    Using dataverse connector>> cdm_employment > Dimension Display Value

    OfficeLocation is stored at HcmWorkerEntity  > OFFICELOCATION

    pastedimage1643816729052v3.png

    Office location is not available in dataverse entity for workers.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans