Get Position of a Worker

Below Code snippet can be use to find the  assigned position  of a worker .

select hcmWorker
where hcmWorker.PersonnelNumber == hcmPersonnelNumberId;

//hcmPositionWorker Assingment table is date effective . but here we get only the active position of //a worker
select hcmPositionWorkerAssignment
order by hcmPositionWorkerAssignment.RecId desc
where hcmPositionWorkerAssignment.Worker == hcmWorker::findByPersonnelNumber(hcmPersonnelNumberId).RecId;

hcmPosition = hcmPosition::find(hcmPositionWorkerAssignment.position);


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s