Get Position and Department of an employee | AX 2012

A simple job to get position/designation and department of an employee using employee id:

static void WorkerPositionDepartment(Args _args)
{
    HcmWorker                       hcmWorker;
    HcmPositionWorkerAssignment     hcmPositionWorkerAssignment;
    OMOperatingUnit                 oMOperatingUnit;
    HcmPositionDetail               hcmPositionDetail;
    HcmJob                          hcmJob;
    HcmPosition                     hcmPosition;
    DirPerson                       dirPerson;

    select Person, RecId from hcmWorker
        where hcmWorker.PersonnelNumber == "ABC-0000043";

    select Position from hcmPositionWorkerAssignment
        where hcmPositionWorkerAssignment.Worker == hcmWorker.RecId;

    select JobId from hcmJob
        join hcmPositionDetail
        where hcmJob.RecId == hcmPositionDetail.Job &&
              hcmPositionDetail.POSITION == hcmPositionWorkerAssignment.POSITION &&
              //hcmPositionDetail.Position == hcmWorker.RecId &&
              hcmPositionDetail.ValidTo > DateTimeUtil::utcNow();

    //select Name from oMOperatingUnit
        //join hcmPositionDetail
        //where hcmPositionDetail.Department == oMOperatingUnit.RecId &&
                //hcmPositionDetail.Position == hcmWorker.RecId &&
                 //hcmPositionDetail.ValidTo > DateTimeUtil::utcNow();
    select Name from oMOperatingUnit
        join hcmPositionDetail
        where hcmPositionDetail.Department == oMOperatingUnit.RecId &&
                hcmPositionDetail.Position == hcmPositionWorkerAssignment.Position &&
                 hcmPositionDetail.ValidTo > DateTimeUtil::utcNow();

    select Name from dirPerson
        where dirPerson.RecId == hcmWorker.Person;

    //IhlVisitorsLog_ds.object(fieldNum(IhlVisitorsLog,Host)).setValue(dirPerson.Name);
    //IhlVisitorsLog_ds.object(fieldNum(IhlVisitorsLog,JobId)).setValue(hcmJob.JobId);
    //IhlVisitorsLog_ds.object(fieldNum(IhlVisitorsLog,Department)).setValue(oMOperatingUnit.Name);
    //IhlVisitorsLog_ds.research(true);

    info("Name:"+dirPerson.Name);
    info("Designation:"+hcmJob.JobId);
    info("Department:"+oMOperatingUnit.Name);
}