Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Kia Sepahmansoor

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 = 0000559 7848.Termination-_2D00_-employee-terminated.JPG

Thank you,

Kia

All responses (4)

Answers (0)

Suggested answer

Parag Chapre 12,271 Most Valuable Professional on at

Like (0)

Report

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 25 on at

Like (0)

Report

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 12,271 Most Valuable Professional on at

Like (0)

Report

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.

I'm not sure whether it is a designed behavior or a bug.
Kia Sepahmansoor 25 on at

Like (0)

Report

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