web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Terminated worker is neither terminated on cdm_worker nor cdm_employment. Is it normal?

(0) ShareShare
ReportReport
Posted on by 25

Hi Friends,

I am trying to working it out how the termination process works. Trying to make a UML diagram to build my workflows based on. So I am running tests. I have terminated the worker on Dynamics 365 for human resources. But for some reasons, I cannot find the worker terminated in neither of tables (cdm_employment, cdm_worker) in Dataverse (CDS). 

Does not seem to be an expected behavior or at least I hope not. Can you please help me understand why? Any recommendation is welcomed 

worker number = 0000559Worker number = 00005597848.Termination-_2D00_-employee-terminated.JPG

Thank you,

Kia

I have the same question (0)
  • Kia Sepahmansoor Profile Picture
    25 on at

    Hi all,

    Notice the worker status has become 'Inactive' now. What do you think was holding back the 'status change' ?

    Many thanks,

    Kia

  • Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    Hi Kia,

    I don't find the change in status but I can see changes in employment end date.

    pastedimage1608848725018v1.png

    I'm not sure whether it is a designed behavior or a bug.

  • Kia Sepahmansoor Profile Picture
    25 on at

    Thanks Parag for your help. My issue is that worker has 1-to-Many relationship with employment as the worker can be hired in multiple entities therefore multiple employment records. In real world, a worker has 1 contract at a time therefore 1 employment record at a time there exists.

    In order to retrieve an employment record associated with a worker, I'd need to filter out all employment records which are not active (employment end date is reached or is in the past).

    I suggest better option would have been if employment status attribute is set to 'inactive' once the cdm_employmentenddate is reached.

    Thanks,

  • Suggested answer
    Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    Hi Kia,

    I will suggest you post on the idea in the MS portal

    experience.dynamics.com/.../

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 341 Most Valuable Professional

#2
CU10121822-0 Profile Picture

CU10121822-0 312

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 262 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans