Relation Between HcmWorker and HcmPosition.

select PersonnelNumber,Recid from hcmWorker
          where hcmWorker.PersonnelNumber == '000006'
      join Position,worker from hcmPositionWorkerAssignment
          where hcmPositionWorkerAssignment.Worker == hcmWorker.Recid
      join PositionId,RecId from hcmPosition
          where hcmPosition.RecId == hcmPositionWorkerAssignment.Position;

    info(strFmt("%1,%2",hcmWorker.PersonnelNumber,hcmPosition.PositionId));