Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select LOWER( c.VALUE ) Company, w.NAME WorkerName, e.VALIDFROM EmploymentFrom, e.VALIDTO EmpoymentTo
- from HCMEMPLOYMENT e
- left join HcmWorkerDetailsView w on w.PARTITION = e.PARTITION and w.RECID = e.WORKER
- left join DIMATTRIBUTECOMPANYINFO c on c.PARTITION = e.PARTITION and c.RECID = e.LEGALENTITY
- where w.NAME like 'WorkerName%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement