Tuesday, 22 January 2019

Department of a worker / Employee x++

static void EmpDepartment(Args _args)
{
HcmWorker hcmWorker;
HcmPositionWorkerAssignment workerAssignment;
HcmPosition hcmPosition;
HcmPositionDetail hcmPositionDetail;
OMOperatingUnit omOperatingUnit;

select omOperatingUnit
join hcmPositionDetail
where hcmPositionDetail.Department == oMOperatingUnit.RecId
join hcmPosition
where hcmPosition.RecId == hcmPositionDetail.Position
Join workerAssignment
where workerAssignment.Position == hcmPosition.RecId
join hcmWorker
where hcmWorker.RecId == workerAssignment.Worker
&& hcmWorker.PersonnelNumber == “891”;

info(strFmt(“%1”, omOperatingUnit.Name));
}

No comments:

Post a Comment