web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Suggested answer
    Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at
    RE: Terminated worker is neither terminated on cdm_worker nor cdm_employment. Is it normal?

    Hi Kia,

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

    experience.dynamics.com/.../

  • Kia Sepahmansoor Profile Picture
    25 on at
    RE: Terminated worker is neither terminated on cdm_worker nor cdm_employment. Is it normal?

    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,

  • Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at
    RE: Terminated worker is neither terminated on cdm_worker nor cdm_employment. Is it normal?

    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
    RE: Terminated worker is neither terminated on cdm_worker nor cdm_employment. Is it normal?

    Hi all,

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

    Many thanks,

    Kia

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans