Finance | Project Operations, Human Resources, ...

Get position Id from PersonnelNumber using x++

(0) Share

Report

Posted on by skd

390

Hey Team,

I'm rehiring employees and therefore I need the last issued Position Id for that employee. I have the personnel number of that employee so how can I find the most recent position for that employee using the Personnelnumber? Please help me with this issue.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Junaid Idrees on at

Like (0)

Report

RE: Get position Id from PersonnelNumber

Hi Skd,

Did you check the worker Position assignment screen to check the Position ID:

Data Source: HcmPositionWorkerAssignment
Data Field: Position

Was this reply helpful? Yes No
skd 390 on at

Like (0)

Report

RE: Get position Id from PersonnelNumber using x++

Hey Junaid Idrees,

I want to do this through x++.

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report
RE: Get position Id from PersonnelNumber using x++

Hi skd,

Please check the following code:

HcmWorker hcmWorker; HcmPosition hcmPosition; HcmPositionWorkerAssignment hcmPositionWorkerAssignment; select firstonly hcmWorker where hcmWorker.personnelNumber == 000001; // Personnal number hcmWorker.name())); // worker Name info(strfmt(“Department Name :%1”,hcmWorker.primaryDepartmentName(); // department name select * from hcmPositionWorkerAssignment where hcmPositionWorkerAssignment.Worker == hcmWorker.RecId; info(strfmt(“Start date :%1”, DateTimeUtil::date(hcmPositionWorkerAssignment.ValidFrom))); // Start date select * from hcmPosition where hcmPosition.RecId == hcmPositionWorkerAssignment.Position; info(strfmt(“Position name :%1”, hcmPositionDetail::find(hcmPosition.RecId).Description)); // Position Name

Was this reply helpful? Yes No
skd 390 on at

Like (0)

Report

RE: Get position Id from PersonnelNumber using x++

Hey Will Wu,

I tried the above code but it's not giving me position of past workers, which is a problem. As I want to rehire those employee who have been terminated, so can you give me a solution to this?

This was the result I got when I tried to get position of the past worker:

Was this reply helpful? Yes No