Legal Entity Name, Legal Entity Id, Data Area Id blank when Employee Leaves

(1) Share

Report

Posted on by DynamicsAX_dpw

HI,

I have Custom Entity called ABCWorker (Not sure of the underlining tables that is used to build this ), when I run the below SQL

SELECT
scw.PERSONNELNUMBER
,scw.LEGALENTITY
,scw.LEGALENTITYID
,scw.LEGALENTITYNAME

FROM dbo.ABCWorker scw

The Fields LEGALENTITY, LEGALENTITYID and LEGALENTITYNAME are all Blank for Employees that have been Terminated.

Does anyone know if there are tables that holds this information for when an Employee Leaves the company? As this is causing a nightmare for reporting.

Thanks

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi there,

You should use hcmworker and HCMemployment tables which give you all workers with their employment dates and company information.

Was this reply helpful? Yes No