How to return primary work assignment direct supervisor name from Employee business class

Hello,

Has anyone had any luck finding or creating a field to return the active primary work assignment's direct supervisor's name from the Employee business class?

I see that the delivered fields in the Employee business class will return the direct supervisor's employee ID number, work email, or actor, but haven't been able to find any delivered fields to bring back the PWA direct supervisor's presentation name.

I've been poring over the table definitions documentation and also tried creating a custom derived field (LPL is below), but it's not bringing back any values through ISD:

Employee is a BusinessClass

owned by hr

Derived Fields

PrimaryWorkAssignmentDirectSupervisorEmployeeName is a DerivedField

type is Alpha size 100

return ActivePrimaryWorkAssignmentRel.first DirectSupervisorManagerEmpRel.ReportingRelation.ManagerEmpID.EmployeeName

It seems like it shouldn't be this difficult!

Thanks for any help,

Noelle

Find more posts tagged with

Accepted answers

All comments

sheila-millea

Not sure if this is helpful, but we use this on the Work Assignment overview screen: DirectSupervisor.SupervisorEmployeeNameLabelSnapshot

Jennifer Stroud

Are you using the WorkAssignment business class for your ISD query?

sheila-millea

Sorry, this isn't for ISD - I misread and thought you wanted to display the Supv Name within the Infor screen. My mistake.

pknaul

We built a derived field and actually used the temp manager data so that if the direct supervisor role was vacant, it would give us the next one in the hierarchy.

XLHFirstTemporaryManagerName is a DerivedField

type is Alpha size 250

if (DirectSupervisor not entered)

return blank

if (first DirectSupervisorActiveRel exists)

return first DirectSupervisorActiveRel.Name.PreferredFirstAndLastName

LocalDirectSupervisor = DirectSupervisor

while (LocalDirectSupervisor.ParentSupervisor entered)

LocalDirectSupervisor = LocalDirectSupervisor.ParentSupervisor

if (first LocalDirectSupervisorActiveRel exists)

return first LocalDirectSupervisorActiveRel.Name.PreferredFirstAndLastName

Jennifer Stroud

I use WorkAssignment. DirectSupervisorNameSnapshot

mmacgown

There is a delivered manager field on the Resource record "At A Glance" tab already; the reference string is "ActivePrimaryWorkAssignmentRel.DirectSupervisor.firstActiveAssignmentIsSupervisorWorkAssignment.Employee.Name.PreferredFirstAndLastName". Suggest trying that option.

unknown

Thanks, Sheila. It seems like this should work, but for some reason my ISD query doesn't return any values for this field.

unknown

I'm actually working on modifying an IPA that is querying the Employee business class. I'm just using ISD queries to validate that I'm working with the right fields.

unknown

I still appreciate the suggestion! It seems like it should work either way, whether on screen or through ISD/IPA.

unknown

Thanks, Jennifer! This is close to what I need, but my IPA produces a comma-delimited file, so I don't think I can use the presentation name after all, since it contains commas.

I was able to modify my custom LPL to this to get the manager's presentation name:

Employee is a BusinessClass
owned by hr

Derived Fields

PrimaryWorkAssignmentDirectSupervisorEmployeeName is a DerivedField
type is Alpha size 100
return ActivePrimaryWorkAssignmentRel.first DirectSupervisorManagerEmpRel.ManagerName

But again, now that I think more about it, I don't think that will work for my file, so now I'm trying to figure out how to just get the first and last name with no comma.

unknown

This works fine for most employees, but as Paula indicated, if the employee reports up to a vacant manager position, then this field will return a blank value. The difficulty is that the IPA I'm modifying is already querying a delivered derived field from the Employee business class, DirectSupervisorEmployee, which looks at the ReportingRelationship business class to give the employee ID number of the next supervisor up, for a vacant manager situation. This is resulting in a file with the next supervisor's employee ID appropriately filled in, but a blank name column for that supervisor since there's technically no supervisor's name on the employee's primary work assignment. I was hoping to find or build a similar field on the Employee business class that would use the ReportingRelationship business class to return the name (without commas) of the next supervisor up.

Copyright © 2025 Infor. All rights reserved.