LPL - DirectSupervisor employee ID

Hello Everyone,

I am trying to set an initial value on a field equal to the employee ID of the actor's Direct Supervisor.

I've been toying with something like:

actor.agent(Employee).DirectSupervisor.DirectSupervisorWorkAssignment.DirectSupervisorEmployee

actor.agent(Employee).PrimaryWorkAssignment.DirectSupervisor.DirectSupervisorEmployee

Neither of the above was successful obviously. I seem to be struggling to wrap my head around converting the value of the employee's direct supervisor ID and then hunting that number back around to an Employee ID.

Any insights would be most appreciated!

Find more posts tagged with

Infor Lawson Technology Group - Discussion

Accepted answers

All comments

don-kintzle

I think the answer may depend on where you are trying to set this initial value? For instance what form/business class are you trying to do this on?

0811130630195911.xls

don-kintzle

But the field you want to use is DirectSupervisorEmployee

unknown

Hey Don, yes that would be helpful eh!

I am trying to achieve this on the JobRequisitionInformation form within the JobRequisition business class. The specific field is the Approver 1 field. I would like this field to have an initial value equal to the actors direct supervisor employee ID.

unknown

I have tried initial value is actor.agent(Employee).DirectSupervisorEmployee

I have tried initial value is DirectSupervisorEmployee

The first just turns the field grey with no data populated

The second generates an LPL error

0911060553270289.pdf

don-kintzle

Sorry we do not use this portion of GHR at this time. But to comfirm, you want Approver 1 populated with the Employee Number of the Supervisor listed in the Direct Manager field. Is that what I am understanding?

0911060553270289.pdf

unknown

The supervisor's table (Direct Supervisor) isn't related by employee number so I don't think you can do it directly.

I think it's that way so you can be a Supervisor without being an Employee or an actor.

That being said, the way I know to do it is to find the WorkAssignment.Employee that have a Position.PositionIsSupervisor = JobRequistion.Direct Supervisor.

Drawback: there can be more than one. I can do it in SQL but I don't know how in LPL.

inal_us_payroll_eligibilityreport_for_the_afforda.pdf

rmbell

I use the following:

paragraph
HiringManager
select is WithActivePrimaryWorkAssignment
required
initial value is DirectSupervisor.FirstAssignmentIsSupervisorWAEmp

Not sure if you can leverage that, but it determines the employee id of the position that supervises the position being requested vs the supervisor of the actor entering the req.

unknown

I was actually provided a simple solution by Derick Safarian. On the JobRequision business class I created a DerivedField.

____ is a DerivedField
type is Alpha size 12
return actor.agent(Employee).DirectSupervisorEmployee

I then just set the initial value equal to the derived field. I was definitely making this over-complicated. Thank you everyone for your suggestions!

Copyright © 2025 Infor. All rights reserved.